raw an Enhanced Entity-Relationship (EER) diagram that describes the following business environment.The National Association of Zoos (NAZ) wants to develop an information system to keep track of the zoos, animals, and related zoo objects and people associated with zoos in the US

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)
11th Edition
ISBN:9781305494602
Author:Scott Tilley, Harry J. Rosenblatt
Publisher:Scott Tilley, Harry J. Rosenblatt
ChapterTPA: Toolkit Part A
Section: Chapter Questions
Problem 10RQ
icon
Related questions
Question

Draw an Enhanced Entity-Relationship (EER) diagram that describes the following business environment.The National Association of Zoos (NAZ) wants to develop an information system to keep track of the zoos, animals, and related zoo objects and people associated with zoos in the US.

 

Each Zoo in the U.S. has a unique name plus an address and a size in acres. Each state may have several zoos. In addition to the unique state name, the NAZ wants to record the state's governor and capital. Each animal in each zoo has an animal number that is unique across all NAZ zoos. Each animal also has a pet name (King, Rover, Fred, etc.), a species (tiger, eagle, shark, etc.) and a country of origin. 

 

An animal may be a bird, a mammal, a fish, or any of several other broad categories of animal, but a particular animal may be classified in only one of these broad categories. Additional data about birds include their length and wingspan. Additional data about fish include their weight and top swimming speed. Mammals are kept in enclosures that can be of one of several types (cages, fenced fields, glass enclosures, etc.). Each enclosure in a zoo is identified by an enclosure number that is only unique within its zoo. In addition to the enclosure type, the NAZ information system must record the date the enclosure was built. It must also maintain information on the company that built the enclosure, including its unique company name, address, and phone. Of course, a company may be responsible for building several enclosures. Assume that each enclosure is built by only one company. An enclosure may contain one or several mammals. The NAZ also wants to record the date of birth of each mammal.

 

The NAZ wants to keep track of the current employees of each zoo. Each zoo employee has an employee number that is only unique to the zoo that currently employs him or her. The NAZ also records each employee's name and date of birth. There are only three kinds of zoo employees: veterinarians, animal handlers, and maintenance workers. An employee can fall into more than one of these categories. For example, a veterinarian may at times be considered an animal handler, and an animal handler may at times do maintenance work. The NAZ wants to record each animal handler's date of hire and salary. For each maintenance worker, the NAZ wants to record the set of skills that they have and the number of years they have been employed by the zoo. Some maintenance workers supervise other maintenance workers. For veterinarians, the NAZ wants to record their specialties (a veterinarian can have more than one specialty), their license number, and data about their university degrees. In fact, the NAZ wants to store data about each university including its unique name, city, and state. Since a veterinarian may have received degrees from more than one university, the NAZ wants to keep track of the degrees and dates of graduation of each degree of each veterinarian.

 

Each zoo can have donors who help support the zoo. A donor can help support more than one zoo. The NAZ assigns each donor a unique identification number and also records their name and phone number. The NAZ also tracks each donor's contribution history, including the date and amount of each contribution to each zoo.

 

Your answer should look like this example diagram.

COUNTRY
AWARD
PK AwardName
Organization
|Турe
PK CountryName
Population
Area
Date
COACH
ATHLETE
UNIVERSITY
PK CoachNum +
CoachName
CoachAge
(Skill)
K PK AthleteNum
AthleteName
PhoneNum
PK UnivName
City
YearFounded
Degree
Year
Score
Medal
Supervises
JUDGE
EVENT
VENUE
PK VenueNum
VenueName
VenueType
PK EventNum
6+ PK JudgeNum +
JudgeName
JudgeAge
EventName
Date
|Туре
SWIMMING
DIVING
TRACK & FIELD
Running or Other
Distance
Individual or Relay
Platform or Board
Height
Transcribed Image Text:COUNTRY AWARD PK AwardName Organization |Турe PK CountryName Population Area Date COACH ATHLETE UNIVERSITY PK CoachNum + CoachName CoachAge (Skill) K PK AthleteNum AthleteName PhoneNum PK UnivName City YearFounded Degree Year Score Medal Supervises JUDGE EVENT VENUE PK VenueNum VenueName VenueType PK EventNum 6+ PK JudgeNum + JudgeName JudgeAge EventName Date |Туре SWIMMING DIVING TRACK & FIELD Running or Other Distance Individual or Relay Platform or Board Height
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Analysis and Design (Shelly Cashman Serie…
Systems Analysis and Design (Shelly Cashman Serie…
Computer Science
ISBN:
9781305494602
Author:
Scott Tilley, Harry J. Rosenblatt
Publisher:
Cengage Learning