Course Code : MCS-036
Course Code : MCSL-036
Course Title : Lab Course
Assignment Number : MCA (3)/036L/Assign/2012
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 31st October, 2012 (For July 2012 Session)
30th April, 2013 (For January 2013 Session)
This assignment has three sections. Answer all the questions in each section. Section
1 and Section 2 are of 13 marks each. The lab records related to these sections also
carries 13 marks each. Section 3 and lab records related to section 3 carry 14 marks
each. Rest 20 marks are for viva voce. You may use illustrations and diagrams to
enhance the explanations. Please go through the guidelines regarding assignments
given in the Programme Guide for the format of presentation.
SECTION 1: MCS-032
Question 1:
Ram and Shyam are starting a breakfast in a small town. They will have three bedrooms
for guests. They want to develop software service to manage the reservations and to
monitor expenses and profits. When a potential customer calls for a reservation, they will
check the calendar, and if there is a vacancy, they will enter the customer name, address,
phone number, dates, agreed upon price, credit card number, and room number(s).
Reservations must be guaranteed by 1 day’s payment.
Reservations will be held without guarantee for an agreed upon time. If not guaranteed by
that date, the reservation will be dropped.
i) Draw at least two use case diagrams and define all the classes. (2 marks)
ii) Draw the Sequence and Collaboration Diagrams. (3 marks)
iii) Draw the Class Diagrams. (3 marks)
iv) Draw the State Transition Diagram. (3 marks)
v) Draw the Component Deployment Model. (2 marks)
SECTION 2: MCS-034
Question 1:
An automobile dealer wants to automate its inventory. It can record all of the cars that a
customer purchases. It records all repairs. It records all arriving shipments of repair parts.
The dealer wants daily reports on total daily repairs, daily sales, and total inventory. This
report is called “dailyreport.” The dealer also keeps track of all customers and potential
customers that visit the dealership. The dealer also wants a monthly report showing all
visits and purchases by customers listed by day of the month. The dealer also wants the
ability to query about any customer or potential customer. 12
i) Develop the SRS by performing requirements study. (2 marks)
ii) Identify various processes of the system and generate the DFD’s for
the system. You may use any software to develop the DFD. (2 marks)
iii) Design the ER diagram for the company and do the database design
giving all the constraints. (2 marks)
iv) Perform the detailed procedural design for any two processes. (2 marks)
v) Create at least four test cases for each of the procedures designed in part (iv)
(2 marks)
vi) Suggest some security mechanism for the usage of the system with
various privileges. (2 marks)
vii) Draw the PERT diagram for the given set of tasks and dependencies.
Complete the table showing the critical path and the slack time. (2 marks)
SECTION 3: MCS-035
Question 1:
Prepare Trading Account and Profit and Loss A/c of Mr. Sanyam and Balance Sheet from
the following balances extracted from books for the year ending 31
st
March 2009:
(14 marks)
Trial Balance of Mr. Sanyam as on 31
st March, 2009
Dr. Cr.
Particulars Amount (Rs.) Amount (Rs.)
Cash Account 1,520
Bank Account 17,425
Machinery Account 10,000
Furniture A/c 900
Stock (1-4-2005) 4,000
Purchase A/c 2,750
Discount Allowed 50
Repair A/c 100
Cartage A/c 50
Municipal Taxes 100
Advertising A/c 100
Rent A/c 150
Salaries 300
Bad debts A/c 500
Capital 18,750
Bad debts recovered
A/c
15013
Discount Received 45
Sales 15,000
Loan @ 12% p.a. 2,000
Shyam Bros. 2,000
37,945 37,945
Following adjustment are to be made:
(i) Salaries Outstanding Rs. 200, Prepaid Rent Rs. 50.
(ii) Provide depreciation on machinery at 10%; write off furniture by 20%.
(iii) Interest on loan has been due for one year and remained unpaid.
(iv) Write off Rs. 400 which are not to be paid to Shyam Bros.
(v) Provide interest on capital @6% p.a. for full year.
(vi) Value of closing stock on 31.3.2006 was Rs. 8,000
IGNOU Coaching for BCA, MCA, MBA in Jaipur
BCA Coaching in Jaipur | MCA Coaching in Jaipur
Python Training Institute in Jaipur
python coaching in jaipur
best python coaching in jaipur
IGNOU JAIPUR
Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043
