quiz حل الأسئلة الجامعية manage_search الأرشيف

تم الحل ✓
categoryقواعد البيانات وإدارة البيانات schoolبكالوريوس event_available2026-07-13

السؤال

Transcribed Image Text:

Q2. 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 zookeeper has a unique employee number. Every animal has been cared for by at least one and generally many zookeepers; each zookeeper has cared for at least one and generally many animals. Each time a zookeeper performs a specific, significant service for an animal the service type, date, and time are recorded. A zookeeper may perform a particular service on a particular animal more than once on a given day. ENCLOSURE EnclosureNumber Type Location Size DateBuilt ANIMAL "Animal Number Species Animal Name Weight Gender Country Of Birth Enclosure Number ZOOKEEPER EmployeeNumber EmployeeName Title YearHired CARESFOR AnimalNumber Date Time Employee Number ServiceType 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. Dele e. List the animal number, species, gender, and weight of all of the lions, tigers, and leopards that weigh between 700 and 900 pounds, from heaviest to lightest. d. How many monkeys live in cages that are less than 400 square feet in size? e. Find the name and number of the heaviest tiger.

check_circle الجواب — حل مفصل خطوة بخطوة

hourglass_top