Match each of the following E-R structures with its relational representation.
-Create a relation with a composite primary key that includes the primary key of the entity on which this entity depends and nonkey attributes.
A)regular entity
B)weak entity
C)binary or unary 1:1 relationship
D)binary 1:N relationship
E)binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Question

Quizplus · Accepted Answer

A weak entity depends on another entity, so its primary key includes the primary key of the entity on which it depends. It also includes nonkey attributes.

Answer: E
 A M:N relationship or associative entity also depends on other entities, so its primary key includes the primary keys of those entities. It also includes nonkey attributes. The associative entity itself may also have its own primary key.

Match Each of the Following E-R Structures with Its Relational