1. A machine shop produces many parts. It employs many technicians to design and produce these parts. A record is maintained to keep the inventory of materials needed for designing each part. The production of each part is tracked by giving a job number, start time, end time and technician's identification. Perform the following tasks

Draw the use case diagram and define all the classes and draw the 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 the 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 new company which is going to start manufacturing different parts of a machine and prepare the journal, ledger and trial balance.

March 2015 Transaction Amount
5th Started the business with cash 70,000
10th Deposited in the bank. 30,000
15th Purchased inventory for the shop on credit 50,000
20th Purchased computers and s/w· on credit 60,000
22nd Purchased furniture through cash 20,000
25th Sold parts 30,000
29th Paid electricity bill 3,000
30th Paid salary 20,000