Use the case study description and list of requirements below to create an entity-relationship diagram showing the data requirements of the World of...

Use the case study description and list of requirements below to create an entity-relationship diagram showing the data requirements of the World of Animals Zoo database. Your ERD should be able to be implemented in a relational DBMS. The World of Animals Zoo, located somewhere in Australia, contains animals from all over the world and from many different habitat types. It is currently moving from a paper- and spreadsheet-based system to a database. The database needs to record information about the individual animals, types of animals, enclosures, and the zoo keepers. As well as basic record-keeping and reporting, it is anticipated that eventually the database will also be able to be queried to make up customised 'tours' for visitors on particular themes, such as Australian animals, reptiles, etc. Each animal has a unique identification code, and the larger animals also have names (such as Sophie the giraffe). There are usually several different individuals of each animal type. Information held about individuals includes gender, date and place of birth (all the animals have been born in captivity, at this zoo or others). To record the history of each animal, notes, including the date, are made about each animal if a significant life event occurs (such as a health check, visit by the zoo dentist, birth of young, etc). Whether the animal is child-friendly is also noted, as sometimes the smaller animals are taken to schools for demonstrations. There are many different animal types represented in the zoo. Each animal type has a common name, a scientific name, a description, diet, conservation status, distribution, and habitat type. Each animal type belongs to a broad class: these are mammals, reptiles, fish, amphibians, birds and invertebrates. Each animal type comes from one of six regions: these are Europe and Asia, North America, Central and South America, Africa, Southeast Asia, and Australia. It has a conservation status: Critically Endangered, Endangered, Vulnerable, Near Threatened, Least Concern and Unknown. For example: the animal type with the common name Koala has scientific name Phascolarctos cinereus , is a herbivore, and is found in Eastern Australia in Eucalypt forest and woodland habitat. It is a mammal and comes from the region Australia, and its conservation status is Near Threatened. 1 At any given time, some of the animal types may be on display to the public, while others are off display (e.g. if their enclosure is being renovated). The enclosures at the Zoo are uniquely identified and each contains several animals. The enclosures are grouped into broad zones such as tropical rainforest, savannah grassland, Australian bush, etc, that may include several similar habitat types. Some different animal types can be housed together, so an enclosure may contain a mixture of animals. Other animals can only be housed with others of the same type. The Zoo employs many zookeepers. Information recorded about keepers is their name, date of birth, address, contact phone number, next of kin and next of kin's contact number. Each keeper is assigned to one or more animal types within a broad class. Each broad class of animals (mammals, etc) has a different head keeper who supervises the relevant keepers. 1 Data from https://perthzoo.wa.gov.au/animal/koala Below are several queries and reports that the Zoo database must be able to support. There may well be many others as the Zoo analyses their business and plans for the future; therefore, you should design for flexibility as well as ensuring your ERD could answer these questions. 1. All the animal types represented at the zoo, the class they belong to, and their conservation status. 2. The number of individuals of each animal type, ranked from most individuals to least. 3. All the animal types currently off-display. 4. All Australian animal types that are endangered. 5. All the individual animals looked after by a particular keeper, and the enclosures they are in. 6. The number of keepers supervised by each head keeper. 7. All the animal types represented in a particular zone. 8. Enclosures with more than the average number of animals. 9. All the keepers who work in a particular zone. 10. The history notes about Sophie the giraffe for 2016. What you have to do:  Use the case study description and querying requirements to create an entity-relationship diagram (ERD) for the World of Animals Zoo database. Your ERD should be able to be implemented in a relational DBMS.  List and explain any assumptions you have made in creating the data model.  You should use the crow's feet ERD notation we have been using in the lectures, and should include a legend to explain the notation. You should include attributes in the ERD, and indicate primary and foreign keys. The use of a drawing tool such as Visio will make this task easier.  Whichever tool you use, you must copy and paste the ERD into a word-processed document. This is because your tutor might not have access to the tools you have used. Please make sure the labels and symbols in your ERD are readable. Enlarge them from the default if necessary  Please note that hand-drawn ERDs are not acceptable. Some important things to note:  You don't have to create the database or any of the reports/queries at this point. However, Assignment 2 will involve creating the database from your design, so you should be satisfied that it will work with at least the queries shown.  You should make any assumptions that are required, but must state them clearly. Obviously, your assumptions should not contradict any of the information already provided.  Part of understanding a system at sufficient enough detail to model well involves asking questions. If you are not sure about some detail of the case study, you should ask on the Discussion Forum in LMS. You can subscribe to the discussion forums so that you don't miss any messages.