FINAL ASSIGNMENT

There is no right or wrong answer to this assignment. The focus is on a systematic analysis that is well documented with an executive summary$/$introduction$,$ section headings, a listing for each requirement and how it was met with an explanatory narrative, and finally, a summary conclusion. Again, documentation is key. Do the best you can!

Case Description

Case Synopsis

Dr$.$ Thomas Waggoner, an information systems professor at the local university, is at the Will Call window at the Medallion Theatre, trying to pick up tickets he had reserved. However, do to an oversight which turns out to be rather frequent, his tickets were sold to another patron. Fortunately for Dr$.$ Waggoner and his wife, who are celebrating their wedding anniversary, the box office manager finds two box seats that had not been claimed. In talking with the box office manager, Dr$.$ Waggoner starts thinking that he could help the theatre avoid this type of problem. His students could design and build a system to help keep track of ticket sales and hopefully help the theatre become more efficient.

Introduction

Dr$.$ Thomas Waggoner waited at the Will Call window for the evening$$s theatre production at the Medallion. He had reserved center orchestra seating tickets for him and his wife for this showing of Les Miz$$ more than two months ago, and for some reason, the box office couldn$$t find his reservation and had sold his tickets to another patron.

$$I am not sure what could have happened to your tickets. But we have already sold the seats you said you reserved $$ D$18$ and D$19,$ said the young lady behind the glass. $$We are sold out for tonight$$s performance.$$

$$That$$s very disappointing, particularly considering we are celebrating our anniversary tonight and have been looking forward to this for a long time,$$ responded Dr$.$ Waggoner. $$Are you very sure there are no seats left?$$

Overhearing the conversation between the ticket clerk and Dr$.$ Waggoner, the Box Office Manager moved over to the window.

$$Dr$.$ Waggoner?$$ she asked. $$Actually$,$ I remember taking your phone reservation. I am so sorry. I wrote down your reservation on the phone list, but evidently, it somehow wasn$$t transferred to our master seating chart. I wish I could say this is the only time this has ever happened, but unfortunately, it happens at least once a week. As it turns out, there are two box seats available tonight. The patrons who have those season tickets are not able to attend tonight $-$ you can have those tickets. And, because it was our mistake, the tickets are on us $$ no charge.$$

$$Fair enough,$$ replied Dr$.$ Waggoner. $$What could have been a lousy evening looks like it will work out even better than planned!$$

$$Thank you for understanding. I hope we can figure out a better process so this doesn$$t happen again.$$

$$Well$,$ if you are interested, I think I could probably help you with that. I teach several systems analysis and development courses at the university, and I think my students could develop a computer system that can automate much of what you are currently doing manually. I can meet with you later this week to start talking about your processes and information needs,$$ offered Dr$.$ Waggoner.

$$That would be wonderful! Thank you so much for your understanding and your offer to help us$.$ Enjoy the show!$$

Later that week Dr$.$ Waggoner met with the Box Office Manager to develop an overall understanding of their business processes, the information they maintain, and the reporting needed. Dr$.$ Waggoner compiled this information and presented it to a group of his students. The detailed requirements are listed below.

Dr$.$ Waggoner explained to his analysis and design students what the Medallion really needed was a database system which would maintain information about each event and tickets sold, and the patron to whom the tickets are sold. The system should also generate reports on the number of tickets sold$/$available per performance, and tickets purchased by a specific patron.

After gathering the detailed requirements for the system, Dr$.$ Waggoner assigned his students the requirements shown below. His SAD students began developing data and process models and designing the user interfaces. As