A. When a many-to-many relationship in E-R model is mapped into relational data

Question

A. When a many-to-many relationship in E-R model is mapped into relational data model, the many-to-many relationship is generally represented as

a. a primary key.
b. a foreign key.
c. a primary key in one table and a foreign key in another table or the same table of the primary key.
d. a table with a pair of foreign keys, each of which is associated to a primary key in its parent table.

B. A join path used for a join operation

a. represents a relationship inherited from E-R model representation of a database schema.
b. involves a primary key attribute and a foreign key attribute.
c. implies a referential integrity constraint.
d. all of a., b., and c.

Explanation / Answer

Dear, A) c. a primary key in one table and a foreign key in another table or the same table of the primary key.
B) c. implies a referential integrity constraint.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.