Using the following narrative to design a database by drawing an Entity-Relationship Diagram. Include the maximum...

 

Transcribed Image Text:

Using the following narrative to design a database by drawing an Entity-Relationship Diagram. Include the maximum and minimum cardinalities for each relationship you identify. Draw the ERD using Visio or the MS Word flowcharting functionality. PUT YOUR NAME AND SECTION DAY ON THE DOCUMENT, name it YourLastName.ERD2.docx, and submit it via the Assignment link on the course Blackboard site. Six Flags entertainment park is reconfiguring its operations and you will design the new database. This is how the new park will operate and what their information needs are: Admission to the park involves an employee collecting cash and distributing membership cards. Every customer who attends the park is given a swipe card as they first enter the park. An admission usually involves more than one person, i.e. a family of six will pay once and receive 6 cards. This swipe card will be used to identify each customer, and the owners would like to store information about each customer, such as their name, address, age, and the time the card is assigned. Assume that a new card is issued each time a customer comes to the park (customers cannot be relied upon to keep their cards and bring them back) but only one customer record is maintained for each customer. The cash collected from daily admissions will go into one of 4 company bank accounts. Daily cash collections are never split between accounts, i.e. they all go in the same account on the same day. Similar to other parks, the customers will pay a flat fee for the day and will be able to ride all of the attractions (the double-looping roller coaster, the merry-go-round, etc.) for no extra charge. The owners, however, want to track the number of rides each customer takes, and the attractions that each uses. One employee runs each attraction. This employee asks each customer to swipe their card through a computerized card reader, automatically entering information into the computer system. Then the employee seats each customer and then operates the attraction (the attraction is not operated without riders). At the end of the ride all customers exit the attraction. If a customer wants to ride the same attraction a second time, they must reenter and swipe their card again. This new computerized systems should allow Six Flags to query the database to answer many operational questions, such as: The number of customers who ride each attraction (How many customers rode the Ferris wheel today?) How many times each attraction is operated daily? a What times of day each attraction is busy or slow? (When was the carousel the busiest?) a The number of attractions each customer uses (How many attractions did customer # 1122 ride?) Which attractions required repairs and for how many hours or days were they closed for repair? Using the following narrative to design a database by drawing an Entity-Relationship Diagram. Include the maximum and minimum cardinalities for each relationship you identify. Draw the ERD using Visio or the MS Word flowcharting functionality. PUT YOUR NAME AND SECTION DAY ON THE DOCUMENT, name it YourLastName.ERD2.docx, and submit it via the Assignment link on the course Blackboard site. Six Flags entertainment park is reconfiguring its operations and you will design the new database. This is how the new park will operate and what their information needs are: Admission to the park involves an employee collecting cash and distributing membership cards. Every customer who attends the park is given a swipe card as they first enter the park. An admission usually involves more than one person, i.e. a family of six will pay once and receive 6 cards. This swipe card will be used to identify each customer, and the owners would like to store information about each customer, such as their name, address, age, and the time the card is assigned. Assume that a new card is issued each time a customer comes to the park (customers cannot be relied upon to keep their cards and bring them back) but only one customer record is maintained for each customer. The cash collected from daily admissions will go into one of 4 company bank accounts. Daily cash collections are never split between accounts, i.e. they all go in the same account on the same day. Similar to other parks, the customers will pay a flat fee for the day and will be able to ride all of the attractions (the double-looping roller coaster, the merry-go-round, etc.) for no extra charge. The owners, however, want to track the number of rides each customer takes, and the attractions that each uses. One employee runs each attraction. This employee asks each customer to swipe their card through a computerized card reader, automatically entering information into the computer system. Then the employee seats each customer and then operates the attraction (the attraction is not operated without riders). At the end of the ride all customers exit the attraction. If a customer wants to ride the same attraction a second time, they must reenter and swipe their card again. This new computerized systems should allow Six Flags to query the database to answer many operational questions, such as: The number of customers who ride each attraction (How many customers rode the Ferris wheel today?) How many times each attraction is operated daily? a What times of day each attraction is busy or slow? (When was the carousel the busiest?) a The number of attractions each customer uses (How many attractions did customer # 1122 ride?) Which attractions required repairs and for how many hours or days were they closed for repair?

Answer rating: 100% (QA)

To design a database for Six Flags entertainment park based on the provided information we can create an EntityRelationship Diagram ERD In this ERD we... View the full answer