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 brand can have many products but it does not have to have any products
B)A brand can have many products and it has to have at least one product
C)Each brand is associated with exactly one product
D)A brand is not associated with any products

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 brand can have many products but it does not have to have any products 
B)A brand can have many products and it has to have at least one product 
C)Each brand is associated with exactly one product 
D)A brand is not associated with any products

Quizplus · Accepted Answer

According to the ER diagram, a brand can be associated with many products and the minimum cardinality of the relationship between Brand and Product is 1, which means that each brand must have at least one product. Therefore, option B is the correct choice. Option A is incorrect as it states that a brand can have many products but it does not have to have any products, which contradicts the minimum cardinality constraint. Option C is incorrect as it says that each brand is associated with exactly one product, which is not true based on the ER diagram. Option D is also incorrect as it contradicts the fact that a brand can be associated with one or many products.

ABC RETAILER Observe the ER Diagram for the ABC Retailer