ABC RETAILER
Observe the ER diagram for the ABC Retailer:

This ER diagram will be used for the following questions citing ABC Retailer ER Diagram.
-How many columns will the relation PROMOTION have in the relational schema mapped from the ABC Retailer ER diagram?
A)2
B)3
C)4

Question

ABC RETAILER
Observe the ER diagram for the ABC Retailer:

This ER diagram will be used for the following questions citing ABC Retailer ER Diagram. 
-How many columns will the relation PROMOTION have in the relational schema mapped from the ABC Retailer ER diagram?
A)2 
B)3 
C)4

Quizplus · Accepted Answer

The PROMOTION relation has two attributes (columns) in the ER diagram, but since it is a binary relationship between two entities (PRODUCT and STORE), it will be represented with a separate relation in the relational schema with three columns: PROMOTION_ID, PRODUCT_ID, and STORE_ID.

ABC RETAILER Observe the ER Diagram for the ABC Retailer