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

  Delete an element from the dictionary

Create a dictionary (Using the list of words in the attached file)

  Application patch management

Application Patch Management Select three applications (not operating systems) that you frequently use. How does each of them address patch management? Visit their Web sites to determine facilities they have to alert users to new vulnerabilities

  Write a python programs to solve the following

Write a Python programs to solve the following 1. An electronics company sells circuit boards that cost $21.99. Assume tax is 9%. Print the total price of 3 circuit boards.

  Developed a new variety of corn for farmers

You are in charge of a large firm, Drexanto, which has developed a new variety of corn for farmers that is highly resistant to disease and bugs. Suppose that the production function for this corn is

  Differentiate between classification of data and clustering

Give two examples, apart from those given in the slides, for each of the following: a) Data mining from the commercial viewpoint b) Data mining from the scientific viewpoint. Differentiate between classification of data and clustering of data with th..

  The defining property of an ordered pair is that two

the defining property of an ordered pair is that two ordered pairs are equal if and only if their first elements are

  Create a visual basic

Create a Visual Basic form like the one below that allows the user to press buttons to change the background and foreground colors of the textbox.Your form should have 4buttons, 2labels, and 1textbox.

  Generate a random integer

Explain how to generate a random integer between 1 and M that is already in the tree (so a random deletion can be performed). What is the running time of this operation?

  Enter a number of items and calculating sales tax on a sale

Class PRG/211 Using visual logic number 1 and 2 task must include a conditional step and some form of iteration. Task 1.Enter a number of items and calculating sales tax on a sale including a step offering a warranty for each item. 2. Figuring out..

  Distinguish between traditional and operational bi

Distinguish between traditional and operational BI.

  Explain remote batch-processing operation

A band is always equal to? In signal power as light travels down fiber is called. what does remote batch-processing operation in which data is only input to central computer would need?

  How to get value of column f

How to get value of column F (EA), G, H from EC sheet and How to get column I, J, K valuesto show in C,D ,E

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