For a Binary Many-To-Many Relationship Existing Between Entity Types a and B

question 45

Multiple Choice

For a binary many-to-many relationship existing between entity types A and B:

• A) a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship.
• B) the primary keys of relation A and relation B become foreign keys in a new relation C.
• C) secondary keys are used to establish the relationship.
• D) place the primary key of either entity in the relation for the other entity or do this for both entities.
• E) none of the above.

---

Definitions:

Benzophenone

An organic compound with the formula (C6H5)2CO, often used as a photoinitiator or to perfume soaps.

Alkene

A hydrocarbon that contains at least one carbon-carbon double bond, characterized by the general formula CnH2n and playing a vital role in organic synthesis.

Dimethyl Sulfide

A sulfur-containing organic compound with the formula (CH3)2S, known for its distinctive smell.

Methyl Acrylate

An organic compound used as a monomer in the production of polyacrylic fibers and resins.