Question

1001 Agosto deco Fair Oaks Pass 06 Ronald Regan Way gram [email protected] 1006 Cicily Oklahoma City Oklahoma Massachusetts 02453 [email protected] 02154 Arkansas Way 93728 Brickson Park Crossing Young America Minnesota 1017 Jaye Columbia South Carolina 29240 Massachusetts 02283 District of Columbia 20503 shington 55412 8213 Clyde Gallagher Crossing 1028 Hew 1029 Wade North Little Rock Arkansas Building Building Nine Building Building Eight Building Building Seven Building Building Seven 330-554-5929 The Chung Shan Medical and Dental College Enclosure The George Brown College Enclosure Training 419-832-4576 The Australian College of Kuwait Enclosure The University of Arkansas Enclosure The St. Andrews Presbyterian College Enclosure Animal Feeding Building Building Ten Building Building Seven Building Building Four Building Building Five Building Building Six Building Building Two The University of Avkansas Enclosure The St. Andrews Presbyterian College Enclosure The St. Andrews Presbyterian College Enclosure The George Brown College Enclosure 114-316-8793 Animal Feeding 828-113-8262 Building Building One The George Brown College Enclosure St. Andrews Presbyterian College Enclosure The Hyogo University of Education Enclosure Animal Feeding

Normalization Diagram: Create a 1NF, 2NF and 3NF diagram from the above spreadsheet. A 2NF diagram may not be needed.

ER Diagram: Create an EERD from the above spreadsheet and the Normalization Diagram in Step 1. Use the following business rules:

- Employees are either Volunteers or Paid Employees but not both.

- A Paid Employee is either a Contractor or works directly for the zoo, but can't be both.

- Everyone is assigned a department, and assigned to a building or enclosure.