UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY/DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY
DIT203 DBIT205 SYSTEMS ANALYSIS AND DESIGN
FULLTIME/PARTTIME
DATE: MARCH/APRIL 2018 TIME: 2 HOURS
INSTRUCTIONS: ATTEMPT QUESTION ONE AND ANY OTHER TWO QUESTIONS.
QUESTION ONE
a) Explain the role of a system analyst [2 Marks]
b) Any business endeavor has various stakeholders, who are the key stakeholders in the information
systems game. Explain the systems project development team. [5 Marks]
c) Describe the various motivations for Information Systems Development? [3Marks]
d) Differentiate between systems analysis and systems design. [4 Marks]
e) Information systems development activities are usually supported. Such support includes CASE
tools. Describe what CASE is, explaining the various types of support it provides. [3 Marks
f) A feasibility study is a short focused study aimed at establishing the practicability of
Information Systems development projects. Describe FOUR such feasibility tests that must be
Undertaken before the initiation of the project. [8 Marks]
g) Outline the phases of SDLC. [5 Marks]
QUESTION TWO
a) Define the term prototype [2 Marks]
b) What are the key benefits of prototyping? [3 Marks]
c) The purpose of the TEXTBOOK INVENTORY SYSTEM at a campus bookstore is to supply
textbooks to students for classes at the local university. The university’s academic departments
submit initial data about courses, instructors, textbooks and project enrollments to the bookstore on a
TEXTBOOK MASTER LIST. The bookstore generates a PURCHASE ORDER, which is sent to the
publishing companies supplying textbooks. Book orders arrive at the bookstore accompanied by a
PACKING SLIP, which is checked and verified by the receiving department. Students fill out a BOOK
REQUEST that includes course information. When they pay for their books, the students are given a
SALES RECEIPT.
Required: Draw a DFD for the above narrative. [7Marks]
d) Barclays Bank Members’ Club sells products to its members. The club wants to develop an
inventory system to track the goods sold to the members. Members usually order for the product.
Using the knowledge you have acquired in data modeling answer the following questions
i. List the number of entities in this narrative [2 Marks]
ii. Draw the Entity Relationship Diagram (ERD) to capture the narrative [6 Marks]
QUESTION THREE
a) Discuss the following requirements elicitation techniques citing two advantages and two
Disadvantages for each. [9 Marks]
i. Observation of the work environment.
ii. Questionnaires.
iii. Interviews
b) Discuss any three categories of information systems [3 Marks]
c) Using diagrams illustrate four task inter-dependencies. [4 Marks]
d) Describe the Capability Maturity Model (CMM) [4 Marks]
QUESTION FOUR
a) A product is passed as fit for sale if it passes a mechanical test and an electrical test and has the
correct dimensions. If it has the correct dimensions and fails the mechanical test or the electrical test
(but not both), it is sent back to the workshop for repair. In all other cases, the product is rejected
Write the structured English for the scenario [3 Marks]
Draw a decision table [3 Marks]
Draw a decision tree [3 Marks]
b) Explain reasons as why the employees always resist the new system [3 Marks]
c) Describe the difference between hard system thinking and soft system thinking [1Marks]
d) State three software implementation techniques [3Marks]
e) Make brief notes on
i. JAD
ii. RAD [4 Marks]
QUESTION FIVE
a) When a patient arrives at Moss park Surgery with a repeat prescription request, the receptionist
checks the prescription file and writes out a prescription. This has to be authorized by the doctor
before being passed to the resident chemist for dispensing. The chemist then gives the prescription to
the patient. If the patient is entitled to free prescriptions, the chemist verifies this and fills in the
appropriate details on a form, which is filed in the free prescriptions file. Otherwise the chemist
takes the appropriate amount of money from the patient and gives them a receipt.
Required: Draw a DFD diagram. [5 Marks]
b) A publishing company produces scientific books on various subjects. The books are written by
authors who specialize in one particular subject. The company employs editors who, not necessarily
being specialists in a particular area, each take sole responsibility for editing one or more
publications. A publication covers essentially one of the specialist subjects and is normally written
by a single author. When writing a particular book, each author works with on editor, but may
submit another work for publication to be supervised by other editors. To improve their
competitiveness, the company tries to employ a variety of authors, more than one author being a
specialist in a particular subject.
Required:
i. Identify the entities in the narrative. [4 Marks]
ii. Draw an ERD diagram [5 Marks]
c) Discuss how an organization can physically secure its information system. [6 Marks]