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

Multiple Choice

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