A small community zoo in your area are asking you to create a simple system for them to track the information about animals, cages, staff and vaccination of the animals. The scenario shown below describes more details about the zoo. The zoo has a quite a number of animals. These animal can be categorized into many types such as mammals, reptiles, birds, etc. The animal details are animal name, weight, date when the animal came to the zoo and also the animals diet information. One category can be for many animals but one animal belongs to only one category. Each animal will be given a cage to stay in. The animals will be located in different cages throughout their stay in the zoo. So they do not have a permanent cage for themselves. They will be rotated to other cages on a monthly basis. So one cage can be allocated for many animals and one animal can stay in many cages. It is important to remember that not all cages are used for animals to stay. A few cages are there to accommodate temporary stay while the current cage of the animal is being cleaned up. Cage information are cage number, size and description. The start date and end date of an animal's stay in a cage must be recorded. Sometimes during a stay in a cage, an animal might need some special needs, so this detail must be recorded as well. The location of the cage must also be recorded. In each location there will be a minimum of 1 and a maximum of 4 cages. Location details are name and description. Staff will be in charge of guarding the cages. Not all staff have this guarding duty. The guarding duty is rotational on a weekly basis. So one staff can guard many cages and one cage can be guarded by many guards. Cages that are used for temporary stay of animals do not require guarding. The start date and end date of the guarding duty must be recorded. The staff details are staff number, name, contact number and email address. Each animal will require a minimum of 2 and a maximum of 5 vaccinations. These vaccinations are given by authorized staff only. Not all staff can give vaccination to animals. There is no limit in how many animals a staff can give vaccination to. The vaccination details are date, name and remarks. Based on the above description. Draw a Crow's Foot ERD. Clearly show: 1. The entities, attributes, relationships, primary keys and foreign keys. 2. The cardinality, connectivity and participation constraints.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
A small community zoo in your area are asking you to create a simple system for them to track
the information about animals, cages, staff and vaccination of the animals. The scenario
shown below describes more details about the zoo.
The zoo has a quite a number of animals. These animal can be categorized into many types
such as mammals, reptiles, birds, etc. The animal details are animal name, weight, date when
the animal came to the zoo and also the animals diet information. One category can be for
many animals but one animal belongs to only one category.
Each animal will be given a cage to stay in. The animals will be located in different cages
throughout their stay in the zoo. So they do not have a permanent cage for themselves. They
will be rotated to other cages on a monthly basis. So one cage can be allocated for many
animals and one animal can stay in many cages. It is important to remember that not all cages
are used for animals to stay. A few cages are there to accommodate temporary stay while the
current cage of the animal is being cleaned up. Cage information are cage number, size and
description. The start date and end date of an animal's stay in a cage must be recorded.
Sometimes during a stay in a cage, an animal might need some special needs, so this detail
must be recorded as well. The location of the cage must also be recorded. In each location
there will be a minimum of 1 and a maximum of 4 cages. Location details are name and
description.
Staff will be in charge of guarding the cages. Not all staff have this guarding duty. The guarding
duty is rotational on a weekly basis. So one staff can guard many cages and one cage can be
guarded by many guards. Cages that are used for temporary stay of animals do not require
guarding. The start date and end date of the guarding duty must be recorded. The staff details
are staff number, name, contact number and email address.
Each animal will require a minimum of 2 and a maximum of 5 vaccinations. These vaccinations
are given by authorized staff only. Not all staff can give vaccination to animals. There is no
limit in how many animals a staff can give vaccination to. The vaccination details are date,
name and remarks.
Based on the above description. Draw a Crow's Foot ERD. Clearly show:
1. The entities, attributes, relationships, primary keys and foreign keys.
2. The cardinality, connectivity and participation constraints.
Transcribed Image Text:A small community zoo in your area are asking you to create a simple system for them to track the information about animals, cages, staff and vaccination of the animals. The scenario shown below describes more details about the zoo. The zoo has a quite a number of animals. These animal can be categorized into many types such as mammals, reptiles, birds, etc. The animal details are animal name, weight, date when the animal came to the zoo and also the animals diet information. One category can be for many animals but one animal belongs to only one category. Each animal will be given a cage to stay in. The animals will be located in different cages throughout their stay in the zoo. So they do not have a permanent cage for themselves. They will be rotated to other cages on a monthly basis. So one cage can be allocated for many animals and one animal can stay in many cages. It is important to remember that not all cages are used for animals to stay. A few cages are there to accommodate temporary stay while the current cage of the animal is being cleaned up. Cage information are cage number, size and description. The start date and end date of an animal's stay in a cage must be recorded. Sometimes during a stay in a cage, an animal might need some special needs, so this detail must be recorded as well. The location of the cage must also be recorded. In each location there will be a minimum of 1 and a maximum of 4 cages. Location details are name and description. Staff will be in charge of guarding the cages. Not all staff have this guarding duty. The guarding duty is rotational on a weekly basis. So one staff can guard many cages and one cage can be guarded by many guards. Cages that are used for temporary stay of animals do not require guarding. The start date and end date of the guarding duty must be recorded. The staff details are staff number, name, contact number and email address. Each animal will require a minimum of 2 and a maximum of 5 vaccinations. These vaccinations are given by authorized staff only. Not all staff can give vaccination to animals. There is no limit in how many animals a staff can give vaccination to. The vaccination details are date, name and remarks. Based on the above description. Draw a Crow's Foot ERD. Clearly show: 1. The entities, attributes, relationships, primary keys and foreign keys. 2. The cardinality, connectivity and participation constraints.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Class
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education