Consider the following ER model for a university system:

There is a called that connects these entities. This relationship models that:

A Professor teaches a Course to a Student.
A Course can be taught by multiple Professors, but each Professor only teaches a specific Course.
A Student can enroll in multiple Courses but must have exactly one assigned Professor per Course.

Which of the following is the best way to simplify this three-way relationship while preserving all constraints?

Question

Consider the following ER model for a university system:

There is a    called    that connects these entities. This relationship models that: 
 
 A Professor teaches a Course to a Student. 
 A Course can be taught by multiple Professors, but each Professor only teaches a specific Course. 
 A Student can enroll in multiple Courses but must have exactly one assigned Professor per Course. 
 
 Which of the following is the best way to simplify this three-way relationship while preserving all constraints?

Answer

Split into two relationships, each involving a new associative entity: 
  (One-to-Many) 
   (Many-to-One for Student-Course, but stores the assigned ProfID explicitly)

Answer

Introduce an associative entity called CourseAssignment with attributes    and maintain the three-way relationship.

Answer

Create two binary relationships: 
   (Many-to-One) 
   (Many-to-Many)

Answer

Create two binary relationships: 
   (One-to-One) 
   (Many-to-One)

Crowdly

Consider the following ER model for a university system: There is...

Want instant access to all verified answers on moodlenew.iitd.ac.in?