UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY/DIPLOMA IN INFORMATION TECHNOLOGY
DBIT/DIT 203: SYSTEMS ANALYSIS AND DESIGN
DATE: NOVEMER, 2017 TIME: 1 ½ HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions.
QUESTION ONE (30 MARKS) (compulsory)
a) Differentiate systems analysis and systems design. [4 Marks]
b) Explain the characteristics of a good user interface. [6 Marks]
c) Explain the problems that a system analyst faces. [4 Marks]
d) Give the characteristics of information used at operational, tactical and strategic levels in an
organization. [6 Marks]
e) Feasibility, studies the viability and the ability to successfully complete a proposed project.
Feasibility studies often provide justification for the business case. Discuss five categories of
feasibility. [10 Marks]
a) List advantages of using questionnaires as a tool of data collection. [5 Marks]
b) The degree of a relationship specifies the number of relationships in which an entity can
appear. With the help of example explain the three main types of cardinalities.
c) A purchasing department receives a purchase requisition from the stores. The requisition is
checked, and an invalid requisition is returned to the stores for correction. An order is made
out using a file of approved suppliers, and sent to the appropriate supplier. A copy order is
filed. The requisition is filed. When the goods are received, the invoice is compared with the
filed order copy, and an invalid invoice is returned to the supplier. Valid invoices are passed
to the accounts department for payment and fulfilled orders are filed.
i. Draw a DFD for the above scenario. [5 Marks]
ii. Briefly discuss the disadvantages of CASE TOOLS. [4 Marks]
a) To be a quality product, a system must conform to the customer’s requirements, and to be
delivered in a way that meets their expectations. Explain the objectives that must be
considered if a good design is to be produced. [10 Marks]
b) A CASE (Computer Aided Software Engineering) tool is a software package that
supports the construction and maintenance of logical system specification models. The
aim is to ensure the automation of some of the analysis and design operation. Explain
advantages of CASE tools.
a) AZ Machine Tools is a medium sized engineering company. The sales director proposes to
purchase a stand-alone computer and automate the sales department’s quotation and
customer order processes. You believe that there may be further advantages to be gained by
linking the new software to the existing stock control and accounting software.
You have a choice of purchasing standard application packages and adapting them for use,
or by commissioning a software company to write a dedicated suite of programs for your
company. Compare and contrast the two approaches. [10 Marks]
b) Explain the types of documentation associated with system implementation:
c) Explain any FOUR factors that should be considered when designing DFDs.
a) Define the term prototype. [2 Marks]
b) What are the key benefits of prototyping? [3 Marks]
c) 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
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]
d) Explain reasons as why the employees always resist the new system. [3 Marks]
e) Describe the difference between hard system thinking and soft system thinking. [1Marks]
f) State three software implementation techniques. [3Marks]