Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discovering Advanced Algebra An Investigative Approach

Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke

1st edition

1559539844, 978-1604400069, 1604400064, 978-1559539845

More Books

Students also viewed these Databases questions