Unique employee number-employee name

Assignment Help Basic Computer Science
Reference no: EM131223273

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

Questions Cloud

User computer by a web server-contains information : A cookie-a simple text file that is placed on a user's computer by a Web server-contains information about the user's visit to that website. It might also contain personal information a user provides to a website, such as a user name and preferenc..
Describe the cah system and the disease topic : Define the disease/condition from the perspective of the conventional model and describe in detail how the disease/condition is diagnosed and statistical (epidemiological) data for the disease/condition (i.e., incidence/prevalence, trends, morbidi..
Loop through the array to determine : Loop through the array to determine if the first name entered exists in the array. If a match is found, display a message that includes the name and a message indicating that there was a match found. If no match is found, display a message so indi..
Which is an anthropogenic source of nitrogen oxides : Which of the following is an anthropogenic source of nitrogen oxides? Which of the following pollutants bonds with hemoglobin, thereby interfering with O2 transport in the blood stream?
Unique employee number-employee name : 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.
Your system was running fine : Scenario: Your system was running fine, but you occasionally notice the sound output was "glitchy" and you decide to add a sound card. As luck would have it, a friend gave you his old sound card from a system he threw away.
The economy is in short run equilibrium : Suppose the economy is in short-run equilibrium at a level of output that exceeds potential output.  - How would the economy self-adjust to return to long-run equilibrium?
Description of the meetings market : A description of the meetings market including a detailed description of their target market/buyers such as Corporate, Association, Incentive and SMERF business, the size of the industry etc
Arduino program for an led connected : Write an Arduino program for an LED connected to pin 3 to blink 7 times with a delay of 0.75 sec, then stays off. Use the FOR loop, and an increment of one.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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