1. An airlines ticket booking company wants a computerized system to manage booking, cancellation and delivery of tickets to passengers. When a passenger calls for booking/cancellation of a ticket, the dealing clerk verifies the request of a passenger and books an economical ticket by comparing the cost of a ticket of different airlines. The ticket is delivered within 24 hours to a passenger through a courier. If the ticket is not available on that day, the passenger is informed through an e-mail. The system should answer all queries related to booking/cancellation of tickets of passenger by the passenger's name and date of booking/cancellation. It should also generate different kinds of daily reports about the number of tickets sold, cancelled and pending payment. Perform the following tasks:

Draw the use case diagram.
Define all the classes and draw the class diagram.
Draw the sequence and collaboration diagram.

2. Perform the following tasks for the problem stated in Section

Draw the DFDs at level 0 and level 1.

Write pseudocodes for two processes defined at DFD level 2.

Draw an E-R diagram and related tables showing the integrity constraints.

3. Post the following transactions of an airlines ticket booking company to prepare the Journal, Ledger and Trial Balance:

<img src='./qimages/10176-3.jpg'>