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

Explain the caching of disk blocks

Explain the caching of disk blocks in terms of database recovery. Also explain what a transaction rollback is and a cascading rollback. Remember to give illustrated examples.

Legal issues in information security and incident response

Describe at least 2 cyber crimes (e.g., viruses and hostile codes) and how they can compromise privacy and data. How can encryption be used to ensure integrity and maintain da

Critical thinking what crime in the cyber realm

Kizza (2014) addressed network attacks and intrusions broadly as "cybercrime" and attributed them largely to moral and ethical deficiencies of the perpetrators. Lessig (2006

Database security and government breaches

Database Security and Government Breaches. In criminal justice or public policy related journal articles that have passed a rigorous review process to validate the research c

Create an investment structure

Display the value of the Investment after each year of the term, using a simple compound interest rate of 8 percent. At the end of the program, display all the final field v

Write recursive function that displays an arbitrary element

Your function should take a single integer argument that corresponds to the index of the element in the recursive sequence. The function should return the value of that part

Types of release cycles

Linux distributions generally use two types of release cycles: standard releases and rolling releases. To understand the difference between these cycles, it is important to

The goods are substitutes

(Substitutes and Complements) For each of the following pair of goods, determine whether the goods are substitutes, complements, or unrelated: Peanut butter and jelly, Private

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