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

  Provide code that adds the three buttons to the window

Provide code that adds the three buttons to the window shown below. Only provide the code for the layout manager and the buttons. No additional code is required. (4 points: 1 Layout; 1 each button)

  A computer connected to the internet

A computer connected to the internet that asks for data is a ________

  How is it different from other projects

If the actual termination of a project becomes a project in itself, what are the characteristics of this project? How is it different from other projects?

  How many runs will be required in this design

How many runs will be required in this design? How does this compare with the design in Table 12.2?

  Create a schematic of the crankshaft

Figure 22.65. Create a schematic of the crankshaft, which rotates clockwise, and use a phantom line to show its path of motion. Use phantom lines to show the piston in its extreme right and left positions, and dimension the stroke.

  Collaboration

Collaboration

  Write a simple atm program in python

Write a simple atm program in Python. Ask the user to enter their account number, and then print the beginning balance.

  Health and safety requirements

What are five consequences of non-compliance with health and safety requirements?

  Compare and contrast the major microeconomic failures

Essay Topic: Compare and contrast the major microeconomic failures and macroeconomic failures that you learned this semester.To get you started concentrate on two distinct chapters in the Schiller textbook. See chapter 4 for an analysis of the prob..

  Pointers to pointers is a term used to describe

Pointers whose contents are the address of another pointer.

  Html code for nested table with colors

Write HTML code which output the following nested table. Each entry of the table has a color as indicated by its text. Borders need not be shown.

  Time evolution of a closed circular string

At t = 0, a closed string forms a circle of radi us R on the (x , y) plane and has zero veloci ty. The ti me development of this string can be studied usi ng the action (6.88).

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