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.
-Which of the following is true according to the ABC Retailer ER diagram?
A)A product can belong to multiple brands but it must belong to at least one brand
B)Each product belongs to multiple brands
C)Each product belongs to exactly one brand
D)Each product belongs to either one brand or no brand at all

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. 
-Which of the following is true according to the ABC Retailer ER diagram?
A)A product can belong to multiple brands but it must belong to at least one brand 
B)Each product belongs to multiple brands 
C)Each product belongs to exactly one brand 
D)Each product belongs to either one brand or no brand at all

Quizplus · Accepted Answer

According to the ER diagram, each product can be associated with only one brand as there is a one-to-many relationship between the Brand table and the Product table, with the Product table containing the foreign key to the Brand table. Therefore, option C is the correct choice.

ABC RETAILER Observe the ER Diagram for the ABC Retailer