1. Problems unsolved by seatadvisor:
1.1. Payment problems with the processing of credit cards and cash, providing receipts
1.1.1. This can't solved by Seatadvisor since they don't reference any solutions involving this problem, but it could be solved by buying new equipment, such as receipts printers and magnetic strip readers
1.2. Most of the ticket and membership information is manually processed.
1.2.1. This can be solved by making a new table including membership , that enables the database to manage the membership it self
2. Problems solved by seatadvisor:
2.1. The problems with the current system are:
2.2. Double-booking issues
2.2.1. Sophisticated database management
2.2.1.1. This can help because the sophisticate database can prevents this from happening due the relationships in the database which can them out and remove any double booking.
2.3. The lack of integration of the various ways of recording and processing the data which is currently performed using a mixture of spreadsheet, database, desktop publishing and word processing software.
2.3.1. A complete Internet-based ticketing solution including box office, telephone and Internet ticket sales, subscriptions, web presence and marketing. Works from an Oracle database with unified inventory across all channels.Sophisticated database management
2.4. The lack of detailed analysis of the ticket sales and income.
2.4.1. Patron preference tracking for marketing Detailed sales and financial reporting
2.4.1.1. The two solutions can solve this problem because analyses the ticket sales and income, and the marketing can affect the sales and income.