An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which one of the following conditions, can the relational table for R be merged with that of A?

GATE : Computer Science and IT

An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which one of the following conditions, can the relational table for R be merged with that of A?

A. Relationship R is one-to-many and the participation of A in R is total

B. Relationship R is one-to-many and the participation of A in R is partial

C. Relationship R is many-to one and the participation of A in R is total

D. Relationship R is many-to one and the participation of A in R is partial

Solution

C. Relationship R is many-to one and the participation of A in R is total

Explanation

Note: only M to N relationship needs exclusive table: If a relationship is 1 to M or M to 1 then that relation could be included in the many side table with the help of foreign key concept.