UNIVERSITY EXAMINATION 2020/2021
YEAR I SEMESTER II EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
SPI 2108 System Analysis and Design Year I Semester II
Date: Monday, 24th May 2021 Time: 8.30am – 10.30am
INSTRUCTIONS
Attempt Question one and any other two questions
QUESTION ONE (30 MARKS)
a) State the purpose of each of the following phases in system development
(2 marks)
i) Systems Analysis
ii) Systems Design
b) State with a suitable reason whether each of the data flow shown below is correct or
not. (3 Marks)
c) You have been tasked with interviewing a suitable candidate to work as a system
analyst in a software development company. Explain five key things you will be
looking for in the interviewees (5 marks)
d) As the C.E.O of a certain organization you have rejected the proposal from the
systems Administrator to fund a system development project. Justify your decision
(5 marks)
Page 1 of 4
e) "A requirement of a film company needs a custom system for equipment tracking,
costumes, and props. The business section included finds it a challenge in defining
specifications for technology-based projects." Discuss the most suitable system
development methodology applicable in the above scenario. (5 marks)
f) Study the Victorian Creations scenario in Case I below and answer the questions
that follow
CASE 1: Victorian Creations
Victorian Creations is a growing business that specializes in the reproduction of
furniture from the Victorian era. Since 2006, sales have increased steadily. The
original accounting system was a package from Peachtree Software, which initially
ran on a stand-alone PC and later on a LAN. Now, the firm is preparing to install a
powerful, scalable accounting package that can support the company's current and
future operations. You have been asked to develop a training plan for users.
i) Who should receive training on the new software? (2 marks)
ii) what topics should the training of the person(s)in i) above cover? (2 marks)
iii) What changeover strategy would you suggest for the new accounting system?
(2 marks)
iv) Explain your answer in iii) above. (2 marks)
v) Explain When a post-implementation review should be scheduled (2 marks)
QUESTION TWO (20 MARKS)
a) Study the scenario below and answer the questions that follow
The VERIFY ORDER business process describes the logical rules ofaccepting an Order as
follows-: An order will be accepted only if the product is in stock and the customer's credit
status is OK. The credit manager can waive the credit status requirement. All other orders
will be rejected
Design the decision table showing all possibilities (6 marks)
b) Simplify the table explaining your action (4 marks)
c) You have completed developing a system that you intend to take to the user.
i) Describe four ways of doing this (8 marks)
ii) Explain the importance of user involvement in this process (2 marks)
QUESTION THREE (20 MARKS)
a) Study the scenario below and answer the questions that follow
Page 2 of 4
Sales Promotion Policy gives the conditions for getting discount as follows
Preferred customers who order $1,000 or more are entitled to a 5% discount, and an
additional 5% discount if they use our charge card.
Preferred customers who do not order $1,000 or more will receive a $25 bonus coupon.
All other customers will receive a $5 bonus coupon..
i) Draw a decision tree that will show all possibilities in the case above
( 7 marks)
ii) Write a pseudocode that documents the above sales promotion policy
(4 marks)
b) Users have a vital stake in an information system and they should participate fully."
Justify this with four reasons (4 marks)
c) Explain five factors why Eliciting and understanding requirements from system
stakeholders is a difficult process (5 marks)
QUESTION FOUR (20 MARKS)
a) You are part of Analysis and design team of a database system in your organization.
Justify Why you feel a Data dictionary is essential (5 marks)
b) Study the walkthrough below for the basic requirements of an Order System
A customer submits an order. Depending on the processing logic, the fill order process either
sends an order reject notice back to the customer or sends a picking list to the warehouse.
A completed order from the warehouse is input to the create invoice process, which outputs
an invoice to both the customer process and the accounts receivable data store.
A customer makes a payment that is processed by apply payment.
Apply payment requires invoice detail input from the accounts receivable data store along
with the payment. Apply payment also outputs payment detail back to the accounts
receivable data store and outputs commission to the sales dept, bank deposit to the bank, and
cash receipts entry to accounting.
Draw a level I Data Flow Diagram for the order system described in the walkthrough
above (10 marks)
c) Outline the information you would need to gather in order to perform domain
analysis for the airline reservation system. (5 marks)
Page 3 of 4
QUESTION FIVE (20 marks)
a) Study the simple text scenario below for Collecting the Medical History of a patient
in the Patient Management System.
"When a new patient attends a clinic, a new record is created by a medical receptionist and
personal information (name, age, etc.) is added to it. A nurse then interviews the patient and
collects medical history. The patient then has an initial consultation with a doctor who makes
a diagnosis and, if appropriate, recommends a course of treatment.
i) Identify the primary actors in the scenario above (2 marks)
ii) Draw a Use Case to represent the scenario above. (8 marks)
b) Analyze the diagram given below (6 marks)
c) Explain the importance of System Analysis and Design in the industry (4 marks)
Page 4 of 4
