How do I do this??
1) ERD
2) CONCEPTUAL DATA MODEL
3) CONCEPTUAL PROCESS MODEL
4) LOGICAL DATA MODEL, LOGICAL PROCESS MODEL
• Theatre X demands an information system in order to sell tickets for the shows.
• The theatre owns four chambers.
• Each chamber has a unique name and a certain number of seats which explains its capacity.
• The seats from each chamber are nominally distributed into four areas ( area A, B, C and D), taking into account the distance from the stage.
• For the extremely popular and demanded shows,it is allowed for tickets to be sold even though all seats are taken(tickets for people standing up) within a 5% limit of the capacity of the chamber. Those tickets are charged with 60% of the price available for area D, for that particular show.
• For each season, the theatre establishes a repertory which is going to contain all the shows that are going to be played.
• Each show has a title, an author, a premiere, a duration, a director and a distribution ( the list of actors)
• The repertory includes not only shows from other seasons, but also new shows, that are going to have the premiere during the current season.
• Each show in the repertory is presented one or multiple times. A representation has a date, a starting time, and a chamber where it takes place.
• The management of the theatre establishes for each representation the price of a ticket from area A taking into account the complexity of the preparations, the chamber where it takes place and other marketing issues.
• The price of the tickets from areas B, C and D are 80%, 60% and 40% from the price established for area A at that particular show.
• Tickets for a representation can be sold starting two weeks before the date it is scheduled. Each ticket mentions explicitly the seat and the area of the chamber.
• There cannot be more than one ticket sold for the same seat at the same representation. Also, the capacity of a chamber cannot be exceeded, excepting the 5% mentioned earlier for standing viewers, the ones with no seats.
• A client can buy one or more tickets to the same representation. The buyer can pay cash or using a credit card. The system has to memorise the date of the transaction, the chosen seats and the chosen type of payment.
• The tickets can be returned until the day before the show and the newly available seats can be purchased by someone else interested. For a representation, tickets can be sold until all the seats are taken but no later than the date and time that particular representation begins.