UNIVERSITY EXAMINATIONS: 2020/2021
EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN
APPLIED COMPUTING/ BACHELOR OF BUSINESS INFORMATION
TECHNOLOGY/BACHELOR OF INFORMATION SECURITYAND
FORENSICS/BACHELOR OF SCIENCE IN INFORMATION
TECHNOLOGY/BACHELOR OF SOFTWARE DEVELOPMENT
BIT 1205/BISF/BAC 1205/BSD 1201/BBIT 104: SYSTEM ANALYSIS AND DESIGN
FULLTIME/ PART TIME/DISTANCE LEARNING
DATE: DECEMBER, 2021 TIME: 2 HOURS
INSTRUCTIONS: QUESTION ONE IS COMPULSORY, CHOOSE TWO OTHER
QUESTION ONE (20 marks) Compulsory
A SYSTEM FOR ROOM BOOKING IN LAX HOTEL:
The project addresses the information required by LAX hotel to book rooms and clears the bills of
customers. The hotel has decided to computerize room booking and customer checkout formalities.
The hotel has various types of rooms. It wants to allow booking online through the internet besides
normal booking by phone, letter and also spot booking on arrival of the customer. The hotel
management is willing to invest in a PC with internet connection. It is also willing to train the staff
at the reception desk to handle computerized booking. It is unwilling to invest in a local network
in the hotel, which would allow on-line updating of customer charges. Customer bills are sent from
restaurant, laundry etc to the reception desk accountant for manual updating of accounts. Since the
hotel is small with only 177 rooms, this is feasible.
Use your knowledge of Analysis and design of Information Systems to answer the following
a) As the Systems Analyst on this project, why would it be necessary to conduct a feasibility
analysis? [1 Mark]
b) Briefly describe the major components of the Terms of Reference (TOR) document you
would share with the management of LAX hotel as you plan for implementation.
c) Which 3 key persons at the hotel would be relevant respondents during requirements
elicitation and why? [3 Marks]
d) Identify 2 requirements you would consider as functional for the booking system.
e) At the design phase, write down any two key objectives that would guide your choice of
system design? [2 Marks]
f) How would an Entity Relationship Diagram help to represent business rules for the
system in operation? [2 Marks]
g) Describe any three approaches you would have to choose from, for a conversion
strategy to aid the transition to the automated hotel booking system for LAX? [3 Marks]
h) Why would it be important for the development team to conduct system testing?
i) Give any 2 reasons as to why maintenance of the booking system would be necessary.
QUESTION TW0 (15 marks)
a) Describe the various stakeholders in a Payroll System. [6 Marks]
b) Describe the three structured methodologies in a systems analysis and design [6 Marks]
c) State and explain the four feasibility studies undertaken before undertaking the
development of an information system. [8 Marks]
QESTION THREE (15 marks)
Assume that a new Mololine Bus Company has approached you for computerizing their bus
reservation system for various destinations originating from the City center. The Company
currently has about 1000 buses spread over 60 routes operating from the city center to various
places. Of them, 700 are regular, 200 are semi-luxury, and the remaining are super deluxe buses.
The seating capacity is 48, 42 and 36, respectively.
The Company would like to have at least one week advance reservation. The passenger details
required for the reservation are: be date of journey, starting point, destination, number of seats
(half or full), concession required if any, route number and departure time of the service. If seats
are available, your system should be able to provide enquiry services in a variety of ways to help
the passenger make a decision.
a) What would be your role as the Systems Analyst assigned on this project? [5 Marks]
b) As a system analyst, advise the Mololine Bus Company on the approach you
would adopt to implement a successful system. [5 Marks]
c) How would identification of the boundary of the bus reservation system help the:
i) System Analyst [1 Mark]
ii) System Designer [1 Mark]
iii) System Developer. [1 Mark]
d) What would be the purpose of carrying out the following tasks for the development of the
bus reservation system?
i) Preliminary Investigation [1 Marks]
ii) Technical feasibility [1 Marks]
QUESTION FOUR (15 marks)
a) When a customer places an order, the order is fast verified, then appropriate stock levels are
established. In certain cases the customer is notified of inadequate stocks other the necessary
stock adjustments are made then a delivery note is generated to accompany the goods when
dispatched to the customer. A copy of the delivery note is given to the accounts department to
generate an invoice which is also given to the customer. On receiving the goods the customer
makes payments which automatically adjusts the outstanding debt.
i) Explain FOUR components of dataflow flow diagram. (4 Marks)
ii) Draw a Level 1 Logical DFD. (11 Marks)