تم الحل ✓
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
🔒
الحل الكامل متاح للمشتركين
اشترك في أرشيف الأسئلة لعرض هذا الحل وآلاف الحلول المفصلة خطوة بخطوة من معلمين معتمدين.