CSIS3310 – quiz # 3

1) Draw an E-R Diagram for the tables in assignments 2 and 3 ?

Customers, Agents and Products are related to Orders. In all three relationships (one-to-many), Orders is the child entity.

2) For the following Supertype-subtype relationship, indicate if it is Total (complete) or Partial and if it is Exclusive (Disjoint) or Inclusive (Overlapping.

Person is in Jail, on Parole or Free ?

Total and Disjoint

Vehicle is a Truck, Boat or Car ?

Partial, Disjoint

Athlete is a Basketball Player or Tennis Player ?

Partial, Overlapping