Get premium membership and access revision papers, questions with answers as well as video lessons.

Bit 2112 Systems Analysis &Amp; Design Question Paper

Bit 2112 Systems Analysis &Amp; Design

Course:Bachelor Of Science In Computer Science

Institution: Dedan Kimathi University Of Technology question papers

Exam Year:2014

DEDAN KIMATHI UNIVERSITY OF TECHNOLOGY
BACHELOR OF SCIENCE IN COMPUTER SCIENCE
FIRST YEAR UNIVERSITY EXAMINATION FOR
BIT 2112 SYSTEMS ANALYSIS & DESIGN
DATE: TIME:2HRS
Instruction: Attempt question 1 and any other two questions Question 1
Question 1 (30 marks)
a. Define the following terms: [4 marks]
i. System analysis
ii. System design
b. Systems development methodology [2marks]
c. List and explain four system changeover strategies [8 marks]
d. Differentiate between logical design and physical design. [4 marks]
e. State four objectives of a preliminary investigation. [4 marks]
f. Describe four types of feasibility study. [8 marks]
The case below is used in the remaining questions. Study it and answer the questions that follow:
Q-Taxi is a small independent taxi company operating in a major city. Q-Taxi owns 25 taxis which it rents out to drivers on an annual basis. Each vehicle is effectively rented out to three drivers to cover three 8 hour shifts in a day: therefore there are 75 taxi drivers contracted to Q-Taxi at any given time. Q-Taxi is a profitable company because it has built up a good reputation locally, and there is always a waiting list of drivers wanting to apply to rent a vehicle.
Each driver pays an annual rental fee in advance to Q-Taxi giving them use of a vehicle for 8 hours a day every day of the year. In addition to the annual rental, Q-Taxi takes 5% of the money a driver earns every week. Q-Taxi is responsible for taxing, insuring and maintaining the vehicles. If a vehicle is due for a service or needs to be repaired Q-Taxi contacts a garage and arranges it. Q-Taxi keeps an account of the repair and service costs for each vehicle.
At the end of each shift drivers give the money they have earned to Q-Taxi. If they needed to refuel the vehicle they also submit an expense claim at the end of the shift. At the end of every week Q-Taxi calculates the amount owing to each driver based on the money earned from fares, the expense claims and the deduction of 5%. The drivers are then paid.
Question 2 (20 marks)
a. System analysis and design are two important steps without which the development process may suffer several setbacks. Elaborate on this statement. [10 marks]
b. Taking the Q-Taxi scenario above as the scope of the system under investigation produce a top level data flow diagram. [10 Marks]
Question 3 (20 marks)
a. Describe the normalization process from 1NF to 3NF. [6 marks]
b. Normalize the Q-Tax business case above to produce a set of relations in the Third Normal Form. [6 Marks]
c. Draw an entity relationship diagram (ERD) based on the relations produced in part (b). [8 Marks]
Question 4 (20 marks)
a. What is fact-finding and how is it accomplished [5 marks]
b. Describe the Waterfall system development model and discuss the disadvantages of developing a system using this approach. [10 marks]
c. Identify five functional requirements of a new system for Q-Tax. [5 marks]
Question 5 (20 marks)
a. State two examples of non-functional requirement. [2 marks]
b. Briefly discuss decision support information system [3 marks]
c. Briefly discuss four reasons for starting up information system projects. [8 marks]
d. Discuss the prototyping approach to system development, citing its advantages and disadvantages. [7 marks]

Bit 2112 Systems Analysis &Amp; Design Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams