1. A library has on-line subscription of journals and e-books. Payments for subscription are done yearly in the month of March. Reminders have to be sent to the publishers if the subscribed journals and e-books are not available on-line. Requests have to be sent to different schools of studies for renewal of journals and e-books as well as new subscriptions. Records have to be maintained for the number of users for these subscriptions on a monthly basis. Perform the following tasks:

Draw the use case diagram.

Design all the classes and draw a class diagram.

Draw the sequence and collaboration diagram.

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 at least two processes defined at level 1 of DFD.

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

3. Post the following transactions of a library to prepare the journal, ledger and trial balance.

May 2015 Transaction Amount(RS)
5th Started the services with cash 5,00,000
10th Deposited in the bank 1,00,000
15th Subscribed e-journals on credit 1,50,000
17th Subscribed e-books on credit 1,00,000
20th Purchased furniture 1,50,000
25th Purchased computers 80,000
27th Paid electricity bill 10,000
28th Paid newspaper bill 25,000
30th Paid salary 1,00,000