Using the following narrative to design a database by drawing an Entity-Relationship Diagram. Include the maximum...
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Expert Answer:
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
Related Book For
Principles of Information Systems
ISBN: 978-0324665284
9th edition
Authors: Ralph M. Stair, George W. Reynolds
Posted Date:
Students also viewed these databases questions
-
You are going to design a database for your cooking club to track its recipes. Identify the database characteristics most important to you in choosing a DBMS. Which of the database management systems...
-
You are going to design a database for your schools outdoors club to track its activities. Would cloud computing be a useful strategy to set up the database? Describe your reasoning. If not, what...
-
Read the scenario and design an entity relationship diagram with the following components: A local university is starting an internship program for its seniors to gain real world experience in local...
-
elow is selected financial information for SunRise Company. Selected Balance Sheet Data - As of Dec. 31, 2018 Dec. 31, 2017 Cash and short-term investments $ 958,245 $ 745,800 Accounts Receivable...
-
Praveen Co. manufactures and markets a number of rope products. Management is considering the future of Product XT, a special rope for hang gliding that has not been as profitable as planned. Since...
-
Wealth inequality is _____ related to the ratio of mean to median wealth. a. Positively b. Negatively c. Not
-
We are extracting pyridine from \(500 \mathrm{~kg} / \mathrm{h}\) of a feed that is \(15.0 \mathrm{wt} \%\) pyridine and \(85.0 \mathrm{wt} \%\) water using \(225 \mathrm{~kg} / \mathrm{h}\) of pure...
-
Tri-County Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. In addition to the expenses listed above, the...
-
As an investor, how would you characterize riskiness of Woolworths? If the risk- free rate is 4.1% and the expected return on market portfolio (i.e., the ASX index) is 6.1%, using the CAPM, what will...
-
Suppose there is an urn containing 300 balls, of those 100 balls are red, while the remaining 200 balls are either black or white with unknown proportions. The balls are well-mixed that any...
-
Maximize : Max Z= 3002,+50022 ST 2X1+8x260 221 211+25 30 2,+22515 X220 A
-
11. (a) Briefly explain the significance of the firm's cost of capital. What are the factors determining that cost of capital, and how can that cost be estimated? (b) Given that debt finance is...
-
Successful mergers or acquisitions require a deep understanding of the target company. Discuss the importance of due diligence in a merger and some of what can go wrong without effective due...
-
What is the political difference between Malcolm X and Bayard Rustin?
-
How was Blackstone able to realize a 150 percent return on the Pactera Technology International Ltd. (Pactera) deal? 2. What are the characteristics of a good LBO candidate?
-
If you had to pick just one stock to invest in, what company would you choose to invest in and why? Make sure to include the company and the company's stock price in your answer. We will use that...
-
If someone can't do deadlift how do you progress or regress the exercise
-
Data 9.2 on page 540 introduces the dataset Cereal, which includes information on the number of grams of fiber in a serving for 30 different breakfast cereals. The cereals come from three different...
-
What is the difference between efficiency and effectiveness?
-
You have been hired to develop group support software. Describe the features you would include in your new GSS software.
-
Your company wants to increase revenues from its existing customers. How can data mining be used to accomplish this objective?
-
Briefly explain how standard cost variances are reported on financial statements.
-
Deerfield Company manufactures product M in its factory. Production of M requires 2 pounds of material P, costing \($4\) per pound and 0.5 hour of direct labor costing, \($10\) per hour. The variable...
-
The following actual and standard cost data for direct material and direct labor relate to the production of 2,000 units of a product: Determine the following variances: a. Materials price b....
Study smarter with the SolutionInn App