Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I. {25 points) Draw an Enhanced Enti -Ftelationshi EER dia ram based on the following business environment. The Tennessee Department of Tourism wants to develop

image text in transcribed
I. {25 points) Draw an Enhanced Enti -Ftelationshi EER dia ram based on the following business environment. The Tennessee Department of Tourism wants to develop a database featuring the attractions of every city in the state. Attractions can be zoos. museums. and other major attractions. A particular attraction can fall into only one of these categories. Some cities in the database may not have any such attractions. A city is identified by its name. The database will also store each city's size in square miles and its population. Every attraction has a unique name. an address. and the year it was founded. There are two kinds of museums: art museums and natural history museums. Some museums may be considered to be both kinds. Every museum has a director and the number of displayed items it contains. Additionally. for each art museum. the database must contain certain data about each of its works of art. This data includes the unique name of the work of art. the type of art that it is. and the name of the artist who created it. For the items in each natural history museum. the database must include its unique name and its country of origin. For each zoo. the database must store its size in acres and the number of animals it contains. For each animal in a zoo. the database stores its animal number which is unique across the state. its species and its weight. The database must also store data about the enclosures in each zoo including the unique enclosure number. type. and size. An enclosure may contain several animals or none. The database also must keep track of the current staff members at each zoo. Each staff member has a unique employee number that is unique across the state and the database also stores their names. Some staff members supervise other staff members. Staff members have responsibilities to several animals and each animal can be supported by several staff members. There are two kinds of responsibilities. One is the feeding of the animals for which the database must keep track of the date and time that a particular staff member fed a particular animal. The other kind of responsibility is staff members checking the physical condition of animals. Every time a staff member checks on an animal. the database must record the date. time. and condition found

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management and Competitive Advantage Concepts and Cases

Authors: Jay B. Barney, William Hesterly

5th edition

133129306, 0133127400, 9780133129304, 978-0133127409

More Books

Students also viewed these General Management questions

Question

Locate the centroid of the solid. X - y = a (a-)

Answered: 1 week ago

Question

2 Explain personalisation in an Internet marketing context.

Answered: 1 week ago