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