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!
ACADEMIC WRITERS DEN(AWD)
Our mission is to promote academic success by providing students with superior research and writing, produced by exceptional writers and editors.
1818 N Vermont Ave
Los Angeles, CA, United States