Read the question below and write your answers for questions 1 in the space prov

Question

Read the question below and write your answers for questions 1 in the space provided. 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 and associated data. Each animal has a unique animal number and each enclosure has a unique enclosure number. The zoo wants to track an animal's species, name, gender, origin country and weight. An animal can live in only one enclosure. An enclosure can have several animals in it or it can be currently empty. The enclosure information includes type, location, size and date built. A zookeeper has a unique employee number. Other information includes first name, last name, title and year hired. 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, who could be an individual or an organization, is assigned a sponsor id. For an individual sponsor. Central Zoo tracks his/her name (first name and last name) and birth date. For a sponsoring organization, the zoo tracks its name and size. Other important sponsor information includes address and contact phone number. A sponsor sponsors at least one and possibly several animals. An animal may have several sponsors or none. For each animal that a particular sponsor sponsors, the zoo wants to track the annual sponsorship contribution and renewal date. Identify entity- types in this case and list its attributes.

Explanation / Answer

ENCLOSURE
   Enclosure Number (Primary Key)
   Type
   Location
   Size
   Date Built  

--------------------------------------------------------------------------------------------------
ANIMAL
   Animal Number (Primary Key)
   Species
   Animal Name
   Gender
   Country of Birth
   Weight
  
   Lives In [Foreign Key referring Enclosure(Enclosure Number)]

--------------------------------------------------------------------------------------------------

SPONSOR
   Sponsor Number (Primary Key)
   Sponsor Name
   Address
   Telephone

--------------------------------------------------------------------------------------------------

DEPENDENT
   Sponsor Number, Dependent Name(Primary Key)
   Relation Ship
   Date of Birth
--------------------------------------------------------------------------------------------------

CARE
   ANIMAL Number, Employee Number, Date(Primary Key)
   Service Type
   Time

--------------------------------------------------------------------------------------------------

ZOOKEEPER
   Employee Number (Primary key)
   Employee Name
   Title
   Year Hired

--------------------------------------------------------------------------------------------------

SPONSORING
   ANIMAL Number, Sponsor Number (Primary Key)
   Annual Contribution
   Renewal Date
   Supported By

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.