For this assignment you will be creating an Entity Relationship Diagram in LucidChart. First you can run the script in SQL Server to create the Unnormalized Zoo database, and review the tables to understand what are the entities and relationships involved. Your diagram should include correct use of relationships $($one$-$to$-$many, many$-$to$-$many, one$-$to$-$one$),$ identifying$/$non$-$identifying lines, consistent style for column$/$table

names, and correct use of primary and foreign keys. The datatypes should be listed for each column but do not need to be specific, just int or varchar for example is good enough. Optionality does not need to be included.

Hint: After normalization, there should be six tables.

Business Rules

$-$An animal can be scheduled multiple veterinary visits, with each visit being

associated with only one animal.

$-$An enclosure can contain many animals, but an animal will only belong to one

enclosure.

$-$An enclosure can be assigned many keepers, but a keeper will only be assigned

one enclosure to care for.

$-$Aside from their enclosure, a keeper can be assigned to one or more animals for

care from any enclosure, and an animal can have multiple assigned keepers.

$-$An animal can have multiple feeding schedules, and each listed feeding

schedule is unique to one animal.

Ensure that the database is normalized to $3$NF$,$ but do not make a new table to only remove one column from an existing table. All tables should have a primary key

specified.

$($The image below is the tables I$\text{'}$m working with$)$