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.
NOTE : PLEASE VARIFY ANSWER
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 days 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)
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 1
NOTE : PLEASE VARIFY ANSWER
ii) Draw the Sequence and Collaboration Diagrams. (3 marks)
iii) Draw the Class Diagrams.
(3 marks)
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 2
NOTE : PLEASE VARIFY ANSWER
iv) Draw the State Transition Diagram.
(3 marks)
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 3
NOTE : PLEASE VARIFY ANSWER
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
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 4
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)
NOTE : PLEASE VARIFY ANSWER
ii) Identify various processes of the system and generate the DFDs for the system. You may use any software to develop the DFD. (2 marks)
Customer
Invoice
Automobile delear
Bank
Retailer
Payment
Product
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 5
NOTE : PLEASE VARIFY ANSWER
iii) Design the ER diagram for the company and do the database design giving all the constraints. (2 marks)
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 6
NOTE : PLEASE VARIFY ANSWER
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)
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 7
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)
NOTE : PLEASE VARIFY ANSWER
VIJAY-THANK TO ME ON 7383921223 BY SMS)
Page 8