The following E-R diagram shows a M:N relationship between two relations. To map this E-R diagram into a logical database model:
A) divide the content of the Course relation to establish two relations having 1:N relationships
B) add the primary key of the Student relation as an attribute in the Course relation
C) create a new relation whose primary key is a composite of the primary keys of two relations
D) add the primary key of the Course relation as an attribute in the Student relation

Question

The following E-R diagram shows a M:N relationship between two relations. To map this E-R diagram into a logical database model: 
A) divide the content of the Course relation to establish two relations having 1:N relationships 
B) add the primary key of the Student relation as an attribute in the Course relation 
C) create a new relation whose primary key is a composite of the primary keys of two relations 
D) add the primary key of the Course relation as an attribute in the Student relation

Quizplus · Accepted Answer

The Answer of The following E-R diagram shows a M:N relationship between two relations. To map this E-R diagram into a logical database model: 
A) divide the content of the Course relation to establish two relations having 1:N relationships 
B) add the primary key of the Student relation as an attribute in the Course relation 
C) create a new relation whose primary key is a composite of the primary keys of two relations 
D) add the primary key of the Course relation as an attribute in the Student relation

The Following E-R Diagram Shows a M:N Relationship Between Two