Draw an entity-relationship diagram

Assignment Help Basic Computer Science
Reference no: EM131219011

Question:

Draw an entity-relationship diagram that describes the following business environment. Must be done by hand, on paper. Not on the computer and include relationship types, ( i.e. Many to many, one to one represented by crows feet etc. 

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 maintains a program by which people can be sponsors of animals. Central Zoo also has to track the food it feeds to its animals.

Each animal has a unique animal number, species, name (Dumbo, Princess, Fred, etc.), gender, country of birth, and date of birth. 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.

Central Zoo has to manage the different kinds of food it feeds its animals. The name of each kind of food (salmon, hay, etc.) is unique. The Zoo has to keep track of the storage requirements (frozen, refrigerated, etc.) for each type of food as well as each foods' freshness period in days. An animal eats only one kind of food; a particular kind of food is fed to several animals.

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.

Reference no: EM131219011

Estimate the final dbm value for a radio

Estimate the final dBm value for a radio if the radio has .1 Watt of power, if there is a 4:1 amplifier before transmission, and if there is attenuation to 1/8 the original

Modify the binary search tree to support

Suppose we want to add the operation findKth to our repertoire. The opera- tion findKth(k) returns the kth smallest item in the tree. Assume all items are distinct. Explain

Library management system

The paper must concentrate on a topic chosen in Week 3.  The textbook must be used as one of the minimum three references for the paper.APA format should be followed in regard

Quality assurance process of reviewing written code

Also I need a separate document that explains why the factors were chosen and how I feel they would be important to the quality assurance process of reviewing a programmers

Does this site have real documents

Does this site have real documents? Can someone get me this file https://www.coursehero.com/file/6415792/Quiz1Ans/ to prove this site has material. It's a quiz from a previo

Create a world with a right hand holding a toy ball

Create a world with a right hand (People) holding a toy ball (Sports). Have the fingers close to grasp the ball. Then, throw the ball into the air while opening the fingers

A common element of international conflict

Cyber attacks are now a common element of international conflict, both on their own and in conjunction with broader military operations. Targets have included government netwo

Database tables that the it staff

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that t

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd