below are several queries and reports that the zoo database must be ab
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. (Each question is worth 5 marks) 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. 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. 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 2019.
*The amount will be in form of wallet points that you can redeem to pay upto 10% of the price for any assignment. **Use of solution provided by us for unfair practice like cheating will result in action from our end which may include permanent termination of the defaulter’s account.Disclaimer:The website contains certain images which are not owned by the company/ website. Such images are used for indicative purposes only and is a third-party content. All credits go to its rightful owner including its copyright owner. It is also clarified that the use of any photograph on the website including the use of any photograph of any educational institute/ university is not intended to suggest any association, relationship, or sponsorship whatsoever between the company and the said educational institute/ university. Any such use is for representative purposes only and all intellectual property rights belong to the respective owners.