An ER model of a database consists of entity types A and

Home » Database » Database miscellaneous » Question

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?

1. Relationship R is one-to-many and the participation of A in R is total.
2. Relationship R is one-to-many and the participation of A in R is partial.
3. Relationship R is many-to-one and the participation of A in R is total.
4. Relationship R is many-to-one and the participation of A in R is partial.

Correct Option: C

In one to many or many to one participation, relation is merged in table which is on many side and if there participation then relation is merged in that side consider entity set A, B in the relationship set R. Relation R merge with that of A and B.

According to the above figure. Many to one relationship set can merge towards entity set 'A' & Participation towards A side can be total. Hence option (c) is correct.