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...
-
You see in The Wall Street Journal that the yield spread between Baa corporate bonds and Aaa corporate bonds has gone from 350 basis points (3.5 percent) to 200 basis points (2 percent). Show...
-
Conventional and Dollar-Value LIFO Retail As of January 1, 2010, Aristotle Inc. installed the retail method of accounting for its merchandise inventory. To prepare the store's financial statements at...
-
From the following trial balance and attached notes, prepare an income statement for the year ended 31 December 2008 and a balance sheet as at that date. Patrick Cooper Trial balance as at 31...
-
Reporting an Income Statement, Statement of Stockholders Equity, and Balance Sheet Refer to E4-18. Required: Using the adjusted balances in E4-18, prepare an income statement, statement of...
-
M-Bot Corporation has 10,000 shares of 8%, $100 par value, cumulative preferred stock outstanding at December 31, 2020. No dividends were declared in 2018 or 2019. If M-Bot wants to pay $375,000 of...
-
1.What economic risks are implicit in Halloran's logistics choices? How has the firm endeavored to reduce these? How successful have they been? 2.Evaluate the two strategies using the questions above...
-
Consider the following hypothetical sales scenario.A large community college buys and takes delivery of 50 iMac computers from a local Apple store.The invoiced price is $2,800 per unit and includes...
-
The issue of quality of earnings has taken on increasing importance because of recent accounting scandals and financial crisis. Explain THREE (3) factors affecting the quality of earnings of a...
-
Consider a random experiment in which two dice are rolled, and the two values are multiplied together to give the outcome. Outcomes Second roll: First roll: 1 2 3 4 5 6 1 2 3 4 5 6 2 4 3 4 6802 12 10...
-
It is May 1. The quoted price of a bond with an Actual/Actual (in period) day count and 12% per annum coupon (paid semiannually) in the United States is 105. It has a face value of 100 and pays...
-
Define what is a leading economic indicator? - List one leading economic indicator, one coincident and one lagging. - Explain why leading indicators are not useful for investment policy? (for example...
-
Riverfront Properties Ltd. Total Revenue: $180 million Cost of Goods Sold: $95 million Operating Expenses: $60 million Interest Expense: $8 million Tax Rate: 25% Calculate the gross profit, operating...
-
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?
-
United Limited, a company that manufactures sporting equipment and accessories, owns a number of properties, which are listed below: 1. Trafford Lane: a freehold factory and office block used...
-
Helix Limited (Helix) purchased three identical properties (Right, Left and Up), and leased a fourth (Down), which has been classified as a right-of-use asset in accordance with IFRS 16 Leases,...
-
What are the principal accounting and disclosure differences between IAS 40 and FRS 102, Section 16?
Study smarter with the SolutionInn App