UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN
BIT 1205 SYSTEMS ANALYSIS AND DESIGN
DATE: DECEMBER, 2017 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions.
QUESTION ONE [30 MARKS]
a) Differentiate between Physical and Abstract System. (2 Marks)
b) What are the advantages and disadvantages of prototyping? (8 Marks)
c) A supermarket has the policy for cashing customer’s cheques as per the given rule. If the
cheque is a personal cheque, for 7500, or less the cheque can be cashed. If the cheque is a
customer’s pay cheque, it can be cashed over 7500, provided it is a company accredited by the
supermarket. Find out various conditions and values for each condition. Decide corresponding
actions and draw a decision table for the above logic. (10 Marks)
(c) Describe the following: (4 Marks)
(i) Black-box testing.
(ii) White-box testing.
(iii) Alpha testing
(iv) beta testing
d) Describe the role and responsibilities of the System Analyst. (6 Marks)
a) State FIVE structured methodologies used in systems analysis and design (5 Marks)
b) Describe any four advantages of prototyping techniques [4 Marks]
c) Distinguish between logical design and physical design [2Marks]
d) State the role of the data dictionary in systems development [4Marks]
e) List the skills necessary for a system analyst [5Marks]
A college library holds books for its members to borrow. Each book may be attributed to one or
more authors, and any one author may have written several books. Up to 10 copies of popular
titles are held. A member may borrow up to 6 books at a time. If books are not returned on time a
fine is levied.
If the books are not returned by a week after a third reminder and fines are not paid the member
may put onto a blacklist until the position is rectified. If the copies of a wanted book are
currently in stock a member may make a reservation until it is available
a) Draw an entity relationship diagram for the scenario (8 Marks)
b) List the main sections that you would expect to find in a feasibility report (8 Marks)
c) Distinguish between verification and validation (4 Marks)
a) Explain four main weaknesses of the traditional waterfall SDLC. (8 Marks)
b) Distinguish between alpha and beta testing (3 Marks)
c) Describe these changeover methods, give a situation or an example where they can be
iii) Direct (9 Marks)
The pharmacy at the General Hospital receives medical prescriptions from doctors for all
hospital patients. These medications are meant to be distributed to the nurse stations, responsible
for the patients’ care. A pharmacy technician reviews each prescription and sends it to the
appropriate pharmacy station.
Prescriptions for drugs that must be formulated (made on-site) are sent to the shelving station,
and prescriptions for narcotics are sent to the secure station. At each station, a pharmacist
reviews the order, checks the patient’s file to determine the appropriateness of the prescription,
and fills the order if the dosage is at a safe level and it will not negatively interact with the other
medications or allergies indicated to the patient’s file. If the pharmacist does not fill the order, the
prescribing doctor is contacted to discuss the situation. In this case, the order may ultimately be
filled, or the doctor may write another prescription depending on the outcome of the discussion.
Once filled, a prescription label is generated listing the patient’s name, the drug type and dosage,
and expiration date, and any special instructions. The label is placed on the drug container, and
the order is sent to the appropriate nurse station. The patient’s admission number, the drug type
and amount dispensed, and the cost of the prescription are then sent to the billing department.
In case the patients left the hospital, the medications allocated to them are sent back to the
pharmacy and they are put back in the respective stock.
a) Develop a data flow diagram for the pharmacy system described in the
Given case study (8Marks)
b) Draw a use case diagram for capturing the requirements of the system to be developed.
c) Draw a sequence diagram for General Hospital Pharmacy. (4 Marks)