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.