1. A tourist company provides many services booking of hotel rooms, resorts, booking of railway and air tickets, cancellation of tickets, pick and drop cab facility from the airport. Payment can be accepted through credit card, cheque and cash. The company gives 20% discount in case the booking is done in a group (not less than 10). Perform the following tasks

2. Perform the following activities for the problem description given in Q. No. 1 (Section

Draw the DFDs at level 0 and level 1.

Write pseudocodes for any two processes defined at level 1 of the DFD.

Draw an E-R diagram, convert the E-R diagram into relational tables showing the integrity constraints.

3. Post the following transactions for a tourist company and prepare the journal, ledger and trial balance.

April 2015 Transaction Amount
5th Started the business with cash 5,00,000
10th Deposited in the bank 2,00,000
12th Purchased computers, S/W and peripheral devices on credit 1,00,000
15th Purchased furniture on credit basis 50,000
20th Earned by booking tickets (in cash) 20,000
25th Earned by booking hotel rooms and cab services . (in cash) 30,000
27th Paid rent 30,000
30th Paid salary 40,000