Draw an entity-relationship diagram

Assignment Help Basic Computer Science
Reference no: EM131218032

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: EM131218032

Pseudocode for a program to ask the user

Write a pseudocode for a program to ask the user for a measurement in feet. Convert the measurement in feet to meters and display the result. Look up theconversion from feet

Car sale data and try to apply there learning skills

Choose any topic of your interest and create a power point presentation, you should utilize all features were taken in all finished class works. The slide show should presen

Question-conceptual design

Perform conceptual design for the TCI. You are required to generate an ER diagram. And you also need to write the specification that includes additional constraints not show

What is the sum for this number of terms

Use a while loop to determine how many terms in the series 2k, k = 1, 2, 3, . . . , are required for the sum of the terms to exceed 2000. What is the sum for this number of

Describe the backup plan in case of rain

Assume that you are involved in planning a wedding. What are three risks that might affect the ceremony or reception, and how would you mitigate the impact of those risks? F

What is the vertical distance h

A vertical jet of water leaves a nozzle at a velocity of 10 m/s and a diameter of 20 mm. It suspends a plate having a mass of 1.5 kg as indicated in Fig. P12.15. What is the

Domain registration information and dns records

Research one of these domains: microsoft.com, cnn.com, icann.org, wikipedia.org, google.com. Your goal is to find out publicly available information about each domain incl

Devise an algorithm for determining interior regions

Devise an algorithm for determining interior regions for any input set of verbs using the nonzero winding-number rule and dot-product calculations to identify the direction

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