1. Write the relationship sentences for this E-R Diagram.

CUSTOMER : ORDER

Each CUSTOMER _____________________________________________________

Each ORDER _________________________________________________________
 

ORDER : ITEM

Each ORDER _________________________________________________________

Each ITEM ___________________________________________________________
 

ITEM : WAREHOUSE

Each ITEM _____________________________________________________________

Each WAREHOUSE ______________________________________________________
 

2. Given the following diagram, complete (correctly mark in the softbox) the UID for what in your opinion should uniquely  identifies the CUSTOMER entity.

3. Draw an Entity-Relationship diagram to represent the following (attributes are not needed):

a Each EMPLOYEE must be assigned to one and only one DEPARTMENT.
b Each DEPARTMENT may be responsible for one or more EMPLOYEEs.
c Each EMPLOYEE may be assigned to one or more ACTIVITIES.
d Each ACTIVITY may be performed by one or more EMPLOYEEs.
 
 
 
 
 
 
 
 
 
 
 
 
 
 

4. Draw the Entity for the following (include entity name, attributes, UID, mandatory / optionality):

For a small theater, each ticket is uniquely identified by its date of performance and its seat number.  The ticket may contain information about special hearing devices available at that seat, whether the seat is wheel chair assessable.
 
 
 
 
 
 
 
 
 
 
 

5. Given the following explanation and diagram, complete the UIDs:

A business needs to track the work assignments of its employees. Employees are given work assignments to projects. An employee may be given multiple assignments to a single project, each with a different date of assignment.