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:
- The entities, attributes, relationships, primary keys and foreign keys. 2. The cardinality, connectivity and participation constraints.