Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer in erd diagram The KIDZOOMANIA Park is a zoom housing over 2,000 animals or more than 250 species. The park offers the concept of

image text in transcribed

Answer in erd diagram

The KIDZOOMANIA Park is a zoom housing over 2,000 animals or more than 250 species. The park offers the concept of an open zoo, cageless exhibits that re-create natural animal habitats. The park management has decided that its paper-based filing cabinet system is no longer fit for keeping the details of all animals in the zoo. As a database designer, you asked to design a database for the zoon based on the following specifications: There are many types of animals. Each animal has an identification number, name, species, birth date, sex, weight, birth origin and type. The death date of the animal will also be recorded, if the animal dies. An animal can live in many habitats. A habitat can be inhabited by one or many animals. Data about the habitat that needs to be stored are the code, description and type. An exhibit may hold one or many habitats. A habitat is present in one or many exhibits. Data that need to be recorded about the exhibit are the code, name, description, location and size. The park also stored information about Zookeepers. Zookeepers are identified by their social security number. The name, gender, address and phone number are stored for each zookeeper. Zookeepers are assigned to exhibits that they have to take care of. A zookeeper can take care of several exhibits. Each exhibit may be kept by many zoo keepers. An animal has one or many feeding schedules. A feeding schedule has exactly one animal. Each feeding schedule is given a unique ID. The feeding time and type of food given to the animal are required to be stored in the database. An animal may have its own medical record. One medical record belongs to each animal, but one animal may have many medical records. The records consist of medical ID, type of disease, treatment given, duration and medication dosage. . Create a complete ERD that shows all entities, attributes, relationships, and connectivities based on the above information

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant B. Navathe

7th Edition Global Edition

1292097612, 978-1292097619

More Books

Students also viewed these Databases questions