EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking
Dispatcher:

This ER diagram will be used for the following questions citing Eaglerun Trucking Dispatcher ER Diagram.

-How many unique non-primary key columns will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
A)0
B)1
C)2

Question

EAGLERUN TRUCKING DISPATCHER
Observe the ER diagram for the Eaglerun Trucking
 Dispatcher:

This ER diagram will be used for the following questions citing Eaglerun Trucking Dispatcher ER Diagram.

-How many unique non-primary key columns will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
A)0 
B)1 
C)2

Quizplus · Accepted Answer

The non-primary-key columns would be those that are not part of any primary key constraint. In the Eaglerun Trucking Dispatcher ER diagram, we can see that there are two attributes - dispatch_date and load_status - that are not part of any primary key constraint. Therefore, the relational schema mapped from this ER diagram will have 2 unique non-primary key columns.

EAGLERUN TRUCKING DISPATCHER Observe the ER Diagram for the Eaglerun Trucking