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.
Answer:C
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.