Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following relational database for the Central Zoo. Central Zoo wants to maintain information about its animals, the enclosures in which they live, and

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Consider the following relational database for the Central Zoo. Central Zoo wants to maintain information about its animals, the enclosures in which they live, and its zookeepers and the services they perform for the animals. In addition, Central Zoo has a program by which people can be sponsor of animals. Central Zoo wants to track its sponsors, their dependents, and associated data. Each animal has a unique animal number, species, name (Jumbo, Fred, etc.), gender, country of birth, and weight. Enclosures have a unique enclosure number, type (cage, fenced field, etc.), location, size, and date built. 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, employee name, title, and year hired. Some zookeepers supervise other zookeepers. 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 sponsor sponsors at least one and possibly several animals. An animal may have several sponsors or none. A sponsor has a unique sponsor number, a name, address, and telephone number. For each animal that a particular sponsor sponsors, the zoo wants to track the annual sponsorship contribution and renewal date. In addition, Central Zoo wants to keep track of each sponsor's dependents, keeping their name, relationship to the sponsor, and date of birth. A sponsor may have several dependents or none. A dependent is associated with exactly one sponsor. Central Zoo Entities ENCLOSURE Relation ANIMAL Relation ZOOKEEPER KeIaIION SFUNSUN meIa IUMI QUNIKIBUIIN KeIaUON g. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the record for animal number 58560 . ii. Retrieve the record for the tiger named Stripes. ii. List all of the tigers bom in India. iv. List the name and animal number of every animal borm in China that weighs less than 100 pounds. v. List the name and number of every tiger. vi. What is the country of birth of animal number 74371 ? vii. What is the type and size of the enclosure used for animal number 74371? vii. List the name and address of every sponsor of animal number 74371

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Rules In Database Systems Third International Workshop Rids 97 Sk Vde Sweden June 26 28 1997 Proceedings Lncs 1312

Authors: Andreas Geppert ,Mikael Berndtsson

1997th Edition

3540635165, 978-3540635161

More Books

Students also viewed these Databases questions

Question

=+31-6 Describe our short-term and working memory capacity.

Answered: 1 week ago

Question

Explain the forces that influence how people handle conflict

Answered: 1 week ago