Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dream Park has several locations throughout the city of Atlanta. You are one of members from DBA staff of Advanced Software Company and your current

image text in transcribed
Dream Park has several locations throughout the city of Atlanta. You are one of members from DBA staff of Advanced Software Company and your current project assignment is to work with Dream Park management to create a conceptual design for their database. Following are the requirements. o Each location is recorded with a location id, address and a maximum capacity. o Each location has different areas (Ex: picnic, party, etc). Each area has an area id, a description and a size. o Each location is managed by one of its areas. o Only for each picnic area, there are multiple sites. o Each site is identified by the size number which is unique within each picnic area. o Events are held at the areas and Dream Park tracks event id, event name, description as well as the area where the event is being held. o One event can be held across multiple areas. o There are three different types of events namely sporting events, performances and conferences. Sporting events have the name of the team. Conferences have a sponsoring organization. o Dream Park also wishes to track information about visitors who visit different locations. They assign each visitor an id, store their name, date of birth, and registration date. o They also record information about the location visited by each visitor and the date of each visit. o Dream Park rents out Bikes, Boats and Sport items for the visitors. Bikes have a bike id and boats have number of seats, boat id, color and sports items have item id and item type. Above all equipments are not rental equipments. Some of them are to be used by the employees of Dream Park. Rentals are rented by visitors. Each time the equipment is rented, Park records the date and time for the rent. Draw an EER diagram for the conceptual design for the above scenario. Indicate all key and cardinality constraints, specialization or generalizations, and any assumptions that you make

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

Database Management With Website Development Applications

Authors: Greg Riccardi

1st Edition

0201743876, 978-0201743876

More Books

Students also viewed these Databases questions

Question

i need 2 0 7 .

Answered: 1 week ago

Question

Describe the factors influencing of performance appraisal.

Answered: 1 week ago

Question

8. Explain the difference between translation and interpretation.

Answered: 1 week ago

Question

10. Discuss the complexities of language policies.

Answered: 1 week ago

Question

1. Understand how verbal and nonverbal communication differ.

Answered: 1 week ago