Sparky's Fun Park is an entertainment park run by recent ASU graduates. It caters to young people and others who are just young at heart. The owners are very interested in applying what they have learned in their Information Systems and Marketing classes so that Sparky's will be the best amusement park in the area. Therefore, they have asked you to help them develop an REA model of their business. To draw the REA diagram, you interview the owners and also observe the activities that occur at the park. As a result of these activities, you have compiled the following description of Sparky's business operations. Customers pay an entrance fee that covers unlimited rides for that day. Upon payment of the entrance fee, customers receive a smart card. An attendant mans each attraction (e.g., the roller coaster, Ferris wheel, etc.). The card is swiped by the attendant at any attraction that the customer wants to ride to verify that the customer has a valid admission to the park. Each card has a unique identifying number assigned to it. Sparky's computer system is set up to track the number of rides, and which rides, a given customer uses during their stay. Sparky's management wants their information system to be able to answer the following questions: How many people entered the park each day? How many people rode a given attraction (e.g., the roller coaster) on a given day? During a given week? How many times each piece of equipment was operated each day? How many attractions (rides) were used by each customer? How many times did a given customer ride a specific attraction? What was the total dollar sales of all admissions each day? What times of the day are the busiest for each attraction? Required: Draw an REA diagram of the portion of Sparky's business described above. Provide the cardinalities for all the relationships. Build a conceptual database using the REA diagram.
Sparky's Fun Park is an entertainment park run by recent ASU graduates. It caters to young people and others who are just young at heart. The owners are very interested in applying what they have learned in their Information Systems and Marketing classes so that Sparky's will be the best amusement park in the area. Therefore, they have asked you to help them develop an REA model of their business.
To draw the REA diagram, you interview the owners and also observe the activities that occur at the park. As a result of these activities, you have compiled the following description of Sparky's business operations.
Customers pay an entrance fee that covers unlimited rides for that day. Upon payment of the entrance fee, customers receive a smart card. An attendant mans each attraction (e.g., the roller coaster, Ferris wheel, etc.). The card is swiped by the attendant at any attraction that the customer wants to ride to verify that the customer has a valid admission to the park. Each card has a unique identifying number assigned to it. Sparky's computer system is set up to track the number of rides, and which rides, a given customer uses during their stay.
Sparky's management wants their
How many people entered the park each day?
How many people rode a given attraction (e.g., the roller coaster) on a given day? During a given week?
How many times each piece of equipment was operated each day?
How many attractions (rides) were used by each customer?
How many times did a given customer ride a specific attraction?
What was the total dollar sales of all admissions each day?
What times of the day are the busiest for each attraction?
Required:
Draw an REA diagram of the portion of Sparky's business described above.
Provide the cardinalities for all the relationships.
Build a conceptual
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
