Help

02. Consider the following relational database for the Greenzoo. Each animal has a unique animal number and each enclosure has a unique enclosure number. An animal can live in only one enclosure. An enclosure can have several animals in it or it can be currently empty. A l zookeeper has a unique employee sumber. Every animal has been cared for by one and generally many zookeepers; each zookeeper has cared for at least one and generally many animals. Each time a zookeeper performs a speciflc, significant service for an animal the service type, date, and time are recorded. A zookeeper may perform a particular service a given day. ENCLOSURE EnclosureNumber Ty Location S NIMAL Animal Number Species AnimalName GenderCountryOf Birth We EnclosureNumber ZOOKEEPER Employee Number EmployeeName Tale Yeartired CARESFOR AnimalNumber Employee Number Service Lype Date I-Time Write SQL to answer the following queries. (10 points) a. Find the size of enclosure number 2582 b. List the names and numbers of the female tigers who live in enclosure number 4627