Central Zoo wants to maintain information about its animals, the enclosures in w
ID: 3574020 • Letter: C
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. Identity entity types in this case. For each entity type, list its attributes.Explanation / Answer
Here are the possible Entities and their attributes
Entity: Animal
Attriutes: animal_id, enclosure_id, name, gender, country, weight
Entity: Enclosure
Attributes: enclosure_id, enclosure_type, location, size, built_date
Entity: Zookeeper
Attributes: emp_id, fname, lname, title, year_hired
Entity: Zookeeper_Assignment
Attributes: animal_id, emp_id, assgn_date
Entity: Zoo_Service:
Attributes: emp_id, animal_id, service_type, service_date, service_time
//For sponsor we can have a single sponsor table with a type attribute mentioning type of sponsor and irrelevent fields can be empty e:g for indivisual sponsor the size field will be N/A or empty
Entity: Sponsor:
Attributes: sponsor_id, sponsor_type, first_name, last_name, org_name, dob, size, address, phone_number
Entity: Sponsor_services
Attributes: sponsor_id, animal_id, sponsoring_date, contribution, renewal_date