Question
What is wrong with the following set of tables, designed for a small ZOO? How would you redesign them? i, Zoo Database ANIMAL ER
What is wrong with the following set of tables, designed for a small ZOO? How would you redesign them? i, Zoo Database ANIMAL ER CAGE Keeper Name Address Cage No Animal 1 Animal No Species Name Cage No Cage Location Keeper Name Postcode Animal 2 Phone Animal 3 Age Animal 4 Keeper Name ii. Cabin and Tourists CABINS TOURIST Cabin No Tourist No PeopleCatered Ensuite (Y/N) Tourist No Kitchen (Y/N) Tourist Name Tourist Address Tourist Phone Date Booked Date Arriving Cabin_No1 Cabin_No2 Cabin_No3 Cost Date Leaving Type Of Shelter Total Duration of Stay
Step by Step Solution
There are 3 Steps involved in it
Step: 1
What is wrong with the following set of tables designe...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Discovering Advanced Algebra An Investigative Approach
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
1st edition
1559539844, 978-1604400069, 1604400064, 978-1559539845
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App