Question discussion

While converting an E-R diagram to a relational schema, a many-to-many relationship between two entity sets is represented by

1531Medium DSSSB TGT Computer Science 0 replies

While converting an E-R diagram to a relational schema, a many-to-many relationship between two entity sets is represented by

Aadding a foreign key to either entity's table
Ba separate relation whose key combines the keys of both entity sets
Cmerging the two entity sets into one table
Da multivalued attribute

Correct answer: B

Explanation

A many-to-many relationship needs its own table containing the primary keys of both participating entities (as foreign keys).

Join the discussion Report an error

Discussion 0

Nobody has replied yet. Start the discussion!