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

question 65

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

---

Definitions:

Lemon

A product, often a used car, that is found to be defective only after it has been bought.

Corolla

The collective term for the petals of a flower, which are usually colored and serve to attract pollinators.

Adverse Selection

A situation where asymmetric information results in high-risk individuals being more likely to engage in agreements, often observed in insurance markets.

Automobile Finance Company

A financial institution that provides loans to individuals or businesses specifically for the purpose of purchasing automobiles.