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 optional columns will the relational schema mapped from the ABC Retailer ER diagram have?
A)0
B)1
C)2

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 optional columns will the relational schema mapped from the ABC Retailer ER diagram have?
A)0 
B)1 
C)2

Quizplus · Accepted Answer

Optional columns in a relational schema correspond to optional relationships in an ER diagram. The ABC Retailer ER diagram does not have any optional relationships, therefore, the relational schema will not have any optional columns.

ABC RETAILER Observe the ER Diagram for the ABC Retailer