2. (24 points) The data table below shows a relation called ZOO ANIMALS, which records information a

/in /by

2. (24 points) The data table below shows a relation called ZOO ANIMALS, which records information about animals, exhibits, a

2. (24 points) The data table below shows a relation called ZOO ANIMALS, which records information about animals, exhibits, and keepers. Note: This raw data file is also available on ICON. ZOO ANIMALS Animal Name ID 1001 Mike Sex Age Mate Exhibit Keeper ID E209 Keeper Name Jim Fowler M Exhibit Exhibit Type Outdoor Walk Through Outdoor 1002 | 1003 Species Amur Tiger Western Lowland Gorilla African Lion California Sea Lion Koko Simba F M E224 E209 Dian Fossey Jim Fowler 7 1004 M Aquatic E198 Bindi Irwin Andre Fruit Stripe Nala Outdoor 1005 1006 Grevy's Zebra African Lion E209 E209 Jim Fowler Jim Fowler F 8 Outdoor Walk Through 1007 Big Cats Tropic 1012 World 1006 Big Cats Ocean Adventure African Prairie | 1003 Big Cats Tropic World Ocean Adventure African 1011 Prairie Ocean Adventure African 1009 Prairie Tropic | 1002 World E224 Rusty Mr. Popper Dian Fossey Two-Toed Sloth Humboldt Penguin 1008 Aquatic E198 Bindi Irwin 1009 Peppa F Outdoor E209 Jim Fowler Red River Hog Humboldt Penguin 1010 Skipper Aquatic E198 Bindi Irwin 1011 Wilbur M E209 Jim Fowler Red River Hog Western Lowland Gorilla Outdoor Walk Through 1012 King м E224 Dian Fossey a. Construct a single graphical relation for ZOO ANIMALS and diagram the functional dependencies. Make sure to include primary keys, foreign keys, and relationships, if needed. Note: Do not create any new, surrogate keys. b. What is the normal form of this relation? Explain why and be specific. Provide your answer as a text box or on a new sheet. Break down ZOO ANIMALS into a set of third normal form relations. Draw the graphical relational schema and diagram the functional dependencies and relationships. Note: Do not create any new, surrogate keys.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.