Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EER Model - use the MS Visio We want to analyze, design, and implement a web-based ticket reservation system for stadiums. Using this system, spectators

EER Model - use the MS Visio We want to analyze, design, and implement a web-based ticket reservation system for stadiums. Using this system, spectators can choose and buy tickets for their favorite matches online. The spectator first registers in the system with her information including her first name and last name, contact number, gender, and email address. The spectators registration is confirmed by sending a code to her email. Also, if a user forgets her password, by entering the email she used to register in the system, she will receive an email containing a link to create a new password, which she can use to restore her account. Stadium information is stored in this system and updated regularly. Information such as the location and the name of the stadium. Furthermore, each stadium has several venues (halls and fields) in which various matches are held. For each match, we store information like the type of competition (e.g., soccer, tennis, hockey, etc.), competition hours, and the number of available seats. Three types of tickets are sold in all venues of this stadium. 1% of the number of seats are allocated to special guests and tickets are not sold for them. 9% of the number of seats are sold as VIP seats, and the price of each VIP seat is two times of a regular seat. All types of stadium tickets can be sold seasonally, annually, or per match. Spectators will receive a 20% discount for seasonal purchases and a 40% discount for annual passes. The desired seat number of the spectator is specified for the seasonal or annual passes and cannot be changed later. All stadium tickets can be returned up to 24 hours before each competition, and depending on the return time, a percentage of the ticket price is deducted, and the rest is refunded to the user account in the system. The percentage of the return penalty is 10% up to one week before the match and 20% after that up to 24 hours before the match. Also, by prepaying 10% of the price of each ticket, users can reserve that ticket. The deadline for paying the remaining ticket fee is 24 hours before the match, otherwise, the reservation fee will be returned to the spectator's user account and that reservation is canceled. Reservations and purchases of this stadium can be searched based on different parameters such as sections (special or regular seats) and seat numbers of different halls and fields. Users should be able to find their desired seat for a match on a given date by searching through the available seats. All purchases, reservations, and returns are logged in the system and the stadium officials can see and search among them based on various parameters such as game date, ticket price, type of sport, and so on.Top of Form

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 Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions

Question

In Problems 3542, evaluate each integral. S X - 16 = dx

Answered: 1 week ago

Question

5. Provide opportunities for retesting when the stakes are high.

Answered: 1 week ago

Question

What conflicts of interest had to be resolved?

Answered: 1 week ago