Central Zoo wants to maintain information about its animals, the enclosures in w

Question

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. For each entity type, list its attributes.

Explanation / Answer

Here entities are Animal, Enclosure, Zoo Keeper, Sponsor.

Above mentioned entities has below attributes:

Animal - animal number(animal_id), species, name, gender, origin_country, weight, annual_sponsorship, renewal_date

Enclosure - Enclosure number(enclosure_id), type, location, size, date_built

Zoo Keeper - Employee number(employee_id), first_name, last_name, title, year_hired, service_tyepe, date, time

Sponsor - sponsor_id, sponsor_type, first_name, last_name, birth_date, organization_name, size, address, phone_number

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---