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.
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
Related questions
Concept explainers
OOPs
In today's technology-driven world, computer programming skills are in high demand. The object-oriented programming (OOP) approach is very much useful while designing and maintaining software programs. Object-oriented programming (OOP) is a basic programming paradigm that almost every developer has used at some stage in their career.
Constructor
The easiest way to think of a constructor in object-oriented programming (OOP) languages is:
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education