System Analysis and Design
System Analysis and Design
System Analysis and Design
wwee
Haramaya University
College of Business and Economics
Department of Management
Preface
Chapter I
System: An Overview
1.1 Data and Information 1
1.2 Types of information 1
1.3 Functional Allocation of Management 2
1.4 System Concept 6
1.5 System Analysis and Design (SAD) 8
1.5.1 Introduction to Information System 8
1.5.2 Types of Information Systems 9
1.5.3 Some important Systems concepts 11
Chapter II
Information Systems Development Project
2.1 Managing Information System Project 15
2.2 Information Systems Project Phase 16
2.3 Representing and Scheduling Project Plans 19
2.3.1 Gantt Charts 20
2.3.2 PERT Charts 22
Chapter III
The System Development Life Cycle
3.1 Systems Analysis and Design – core concepts 26
3.2 Approaches to Systems Analysis and Design 28
3.3 Role of the System Analyst 30
3.4 System development life cycle (SDLC) 31
3.4.1 Systems Planning and Selection 32
3.4.2 Systems Analysis 34
3.4.3 Systems Design 35
3.4.4 Systems Implementation and operation 35
Chapter V
Systems Analysis
5.1 System Analysis 55
5.2 Requirements Determination 56
5.3 Traditional Methods for gathering requirements 57
5.3.1 Interviewing 57
5.3.2 Questionnaires 59
5.3.3 Direct observation 60
5.3.4 Analysing Documents 61
Chapter VI
Systems Analysis
6.1 Structuring Systems Requirements 67
6.2 Data Flow Diagrams 67
6.3 Conceptual Data Modeling (E-R Diagram) 77
Chapter VII
System Design
7.1 Systems design 83
7.2 Logical design and Physical design 84
7.3 Designing effective input, output, database and user interface 85
7.3.1 Designing Effective Input 85
7.3.2 Designing Effective Output 86
7.3.3 Designing Effective Databases 88
7.3.4 Designing User Interfaces 89
References
System: An Overview
Chapter Objective
Data and Information
Types of information: operational, tactical, strategic and statutory
Management structure – requirements of information at different levels
of management
Functional allocation of management- requirements of information for
various functions
System Concepts , System and its Components , System Analysis and
Design
Why do we need information systems
Tactical Information
1) Identifying and controlling areas of high cost.
2) Identifying critical bottlenecks in production.
3) Identifying alternate production schedules based on tools, machines etc.
4) Performance measures of machines to decide replacement.
Strategic Information:
1) Yearly and monthly production quotas and alternate schedules
2) Policies on machine replacement, augmentation and modernization.
3) Identifying best product mix.
Tactical Information:
1) Advertising techniques and analysis of their impact.
2) Customer preference surveys.
3) Correlation of prices and sales.
4) Sales force deployment and targets.
5) Exploring alternate marketing channels.
6) Timing of special sales campaigns.
Strategic Information:
1) Search for new markets and marketing strategies.
2) Analysis of competitors‘ strategy
3) Technology and demographic forecasts and product changes
Tactical Information:
1) Developing vendor performance measures.
2) Determining optimal reorder levels.
3) Determining issues of items to shops versus
4) Standard needs.
5) Controlling high value of inventory.
6) Determining impact on material cost and
7) Procurement with design changes and new
8) Product introduction.
Strategic Information:
1) Developing vendors for critical items
2) Determining optimal levels of inventory
3) Determining proportion of material needed
4) Reducing varieties of inventory
A Handbook on System Analysis and Design 5
Tactical Information:
1) Variations between budget and expenses.
2) Large outstanding payments/Receipts.
3) Credit and payment status.
4) Cost increases and pricing.
5) Impact of taxation on pricing
Strategic Information:
1) Methods of financing.
2) Pricing policies
3) Tax planning.
Tactical Information:
1) Performance appraisal.
2) Demographic make-up of personnel and its impact on retirement.
3) Production incentives.
4) Morale of personnel.
5) Absentee reduction.
6) Leave and overtime policies.
7) Personnel deployment policies.
Strategic Information:
1) Long range human resource requirements at different levels.
2) Policies on human resource development and training
3) Policies on personnel welfare and facilities
6 A Handbook on System Analysis and Design
Characteristics of a System
A System has nine characteristics
1. Components – A component is either an irreducible part or an
aggregate of parts, also called as a subsystem.
2. Interrelated Components – The function of one component is tied
to the functions of the others. Output from one is input for another,
the dependence of a part on one or more other parts.
3. Boundary – A system has boundary, within which all of its
components are contained and which establishes the limits of a
system, separating it from other systems. Components within the
boundary can be changed whereas systems outside the boundary
cannot be changed.
4. Purpose – All components work together to achieve the overall
purpose of the system.
5. Environment – A system exist within an environment, everything
outside the system‘s boundary that influences and / or interacts the
system.
6. Interfaces – The points at which the system meets its environment
and there are also interfaces between subsystems.
7. Input – System takes input from its environment
8. Output - System returns output to its environment as a result of its
functioning to achieve the purpose. Output from individual
A Handbook on System Analysis and Design 7
What is subsystem?
A subsystem is simply a system within a system. Automobile is a system
composed of subsystems:
• Engine system
• Body system
• Frame system
Why is it important?
Success of information systems depends on good SAD
Widely used in industry - proven techniques
Part of career growth in IT - lots of interesting and well-paying jobs!
Increasing demand for systems analysis skills
Learning Chapter 1
1.1. For taking decisions data must be
(A) Very accurate
(B) Massive
12 A Handbook on System Analysis and Design
Discussion Questions
1.1 Distinguish between data and information. Give two examples of
different types of information obtained by processing data.
1.2 What is the main difference between strategic and tactical information?
If an information system is to be designed for a hospital, what would be
the strategic and tactical information?
1.3 What type of information is provided by MIS?
1.4 What is the difference between MIS and DSS?
1.5 What will an MIS provide in a marketing function?
Chapter II
Chapter Objective
Managing Information System Project
Information Systems Project Phase
Representing and Scheduling Project plans
o Representing Project Plans
o GANTT Chart
o PERT chart
Using Commercial project Management Software
Objective of a project
– Solve a business problem (develop a MIS)
– Take advantage of a business opportunities (develop BIS)
– Other non rational reason: spend existing available resources, training
and enhancing skills of employees
Gantt PERT
Visually shows duration of tasks Visually shows dependencies between
tasks
Visually shows time overlap Visually shows which tasks can be done in
between tasks parallel
Visually shows slack time Shows slack time by data in rectangles
Gantt Charts - Useful for depicting simple projects or parts of large projects,
Show start and completion dates for individual tasks
PERT Charts- Show order of activities, Pert is often used in information system
development because Of lesser emphasis on task direction
The Gantt chart allows the project team, as well as the stakeholders, to visualize
the schedule and to determine the completion date. During the project, the project
manager can determine whether the project is on schedule at any point during the
execution. If changes occur, the project team can utilize the Gantt chart to
determine how the changes will affect the completion date. There are various
software packages that can create Gantt charts, but one that is more widely used
is Microsoft Project (see Figure 2.3). Microsoft Project is a powerful tool that
can create sophisticated Gantt charts as well as other planning diagrams.
A Handbook on System Analysis and Design 21
The first step in creating a Gantt chart is to list all of the tasks that are required
for the project. This is commonly referred to as a Work Breakdown Structure or
WBS. For each task, a time to completion needs to be estimated. Finally, the
order of tasks needs to be determined. As an example, consider purchasing a new
television set as a project. In Figure2.3, nine tasks are listed for this project. For
each task an estimated duration is listed. Finally, for every task after the first one,
a predecessor for that task is selected. For example, the predecessor for task 2 is
task 1. Changing task 2's predecessor causes it to shift to the right of task 1.
A Gantt chart is a graphical tool that is easy to understand. Gantt charts are
frequently used in presentations and to communicate with stakeholders. The
disadvantage of Gantt charts is that they may not contain all of the information
needed by the project manager to make decisions during the project. The PERT
chart contains more information than is found on a basic Gantt chart.
22 A Handbook on System Analysis and Design
Critical path scheduling is a scheduling plan where the order and duration of the
sequence of activities directly affect the completion date of a project.
– Critical path is represented by the sequence of connected
activities that produces the longest overall time period
– It represents the shortest time to complete a project
Slack time refers to the amount of time that an activity can be delayed without
delaying the project duration.
Learning Chapter
2.1 An individual with a diverse set of skills who is responsible for managing
the project process when the project is accepted is known as.
A. Project Developer
B. Project Analyst
C. Project Manager
D. System Manager
2.3 Which one of the following is the third activity of project initiation
phase?
A. Establishing the project initiation team
B. Establishing management procedures
A Handbook on System Analysis and Design 25
2.4 Which one of the following is not the phase of project management?
A. Initiation
B. Planning
C. Close down
D. Analysis
2.6 Which of the following is not the activity related to execution phase of
the project?
A. Managing change to the baseline project plan
B. Monitoring the project progress against the actual progress work
C. Establishing management procedure
D. Executing the base line project plan
2.7 It consists to define clear discrete activities and identify time, input and
output for the project.
A. Project Initiation
B. Project Planning
C. Project Execution
D. Close Down
2.10 It is a great tool for anyone who oversees a team, plans a budget,
juggles schedules, or has deadlines to meet.
A. Microsoft Office
B, Microsoft Project
C. Microsoft ViSIO
D. All
Discussion Questions
1. Who is project manager and what different kinds of skills he required?
2. Discuss the different between the GANTT and PERT chat.
3. Write down the different software which is use for project management.
4 What are different activities which have been done in the first stage of
project management?
5. What are different activities which have been done in the analysis phase?
Chapter III
Chapter Objective
Systems analysis and design – core concepts
Approaches to Systems Analysis and Design
Role of the System Analyst
Systems development Life Cycle (SDLC)
Traditional Waterfall Model
Approaches for Development
Systems Design
Systems Design is the specification or construction of a technical, computer
based solution for the business requirements identified during systems analysis.
Systems Analysis and Design (SAD)
Information systems analysis and design is a method used by companies
to create and maintain information systems that perform basic business
functions.
The main goal of SAD is to improve organizational systems through
developing or acquiring application software that can help employees
accomplish key business tasks more easily and efficiently.
An application software is designed to support a specific organizational
function or process, such as inventory management, payroll. The goal of
application software is to turn data into information.
An Information System is developed by following Software
Engineering Process, which consists of proven methodologies,
techniques and tool. These three process work together to form an
organization approach to SAD
28 A Handbook on System Analysis and Design
Processing Logic describes the steps that transform the data and the events that
trigger these steps. Ex. processing logic in a credit card bill preparation
One of the most difficult decisions in planning is to know when to pull the plug
on a project. This will require an effective control and monitoring system. If you
cannot monitor a system you cannot control it. No organization wants to admit
failure but there may come a point when a project can no longer be salvaged.
This is especially critical with Information Technology projects because of
rapidly changing technologies. Most managers are reluctant to prematurely
terminate a project as careers and egos are at stake. The fallacy of sunk costs may
play a role as well. The result is that projects continue beyond the point of no
return. To avoid this problem, monitor and control systems must be put in place
early during the planning stage. It is critical to define and enforce milestones
where a project will be terminated if necessary. A saving grace is that because a
project is terminated it doesn't make it a complete failure. Excessive cost are
saved for the organization and management can walk away with lessons learned
that can be applied to the next project. In general there are two types of
monitoring "INFORMAL" and "FORMAL". Informal are typically general
meetings, email, and observing. The formal include status reports, scheduled
milestones, audits, reviews, and benchmarks. The formal reviews are generally
more costly and are used during system development processes. Both systems
can be used in combination and involve the questions: "what performance
34 A Handbook on System Analysis and Design
metrics to use" and "how often do reviews occur"? Attention and energy must be
focused on identifying and correcting out-of-control processes.
Once stakeholders have been recognized, the gathering and analysis of the
requirements can begin. Requirement gathering must be related to business needs
or opportunities. Requirement analysis involves capturing requirements and
analyzing requirements. Capturing requirements is communicating with
stakeholders to agree on what the requirements are. Analyzing requirements is
using standard tools to produce a baseline of the requirements. Once the
stakeholders concur on the requirements, the baseline is created and becomes the
formal requirement source. Within this analysis phase, the analyst is discovering
and fact finding. Along with meeting with stakeholders, the analyst must meet
with end users to understand what the user's needs are and to learn about
problems that affect the current system in order to assist with designing a new
and more efficient system. There are several activities that must occur within the
analysis phase:
Gather Information
Define the new system's requirements
Build prototypes for the new system
Prioritize requirements
Evaluate alternatives
Meet with management to discuss new options
The design phase is concerned with the physical construction of the system.
Included are the design or configuration of the network (hardware, operating
system, programming, etc.), design of user interfaces (forms, reports, etc.),
design of system interfaces (for communication with other systems), and security
issues. It is important that the proposed design be tested for performance, and to
ensure that it meets the requirements outlined during the analysis phase. In other
words, the main objective of this phase is to transform the previously defined
requirements into a complete and detailed set of specifications which will be
used during the next phase. Some of the activities that need to take place during
the design phase are:
Design the application
Design and integrate the network
Design and integrate the database
Create a contingency plan
Start a Maintenance, Training and Operations plan
Review the design
Articulate the business processes and procedures
Establish a transition strategy
Deliver the System Design Document
Review final design
Maintenance and support covers all activities that are required once the system is
in place. Activities include, but are not limited to:
Phone support for users
Physical onsite user support
Resolving any issues that may arise with the new system
Providing support materials/tools for users
may be needed for a longer time. If is a smaller system, maintenance and support
may only be needed for a short time.
concept stage. This pure waterfall model makes it very difficult because there is
no room for error and that is virtually impossible when dealing with humans.
Waterfall approach – each phase falls into next phase:-
Freeze planning specifications before analysis, Freeze analysis specifications
before design
Once go over the waterfall for each phase, do not go back. One phase begins
when another completes, little backtracking and looping
Learning Chapter
3.1 The third phase of SDLC (system development life cycle) is.
A. Design
B. Analysis
C. Planning and selection
D. Implementation
3.2 Which of the following is not true about traditional water fall model?
A. Freeze analysis specifications before planning
B, Freeze analysis specifications before design
40 A Handbook on System Analysis and Design
3.5 Which phase of SDLC functional and technical detailed are specified for
every elements of system?
A. Design
B. Analysis
C. Planning and selection
D. Implementation
3.6 Which of the following is treated as alternative for traditional water fall
model?
A. Prototyping
B. Rapid Application Development (RAD)
C. Joint Application Design (JAD)
D. Participatory design (PD)
E. All
3.7 Which of the following method user has the equal voice in determining
system requirements and in approving system design?
A. Prototyping
B. Rapid Application Development (RAD)
C. Joint Application Design (JAD)
D. Participatory design (PD)
E. All
B. Analysis
C. Planning and selection
D. Implementation
3.9 Which of the one methodology perform the analysis, design, and
implementation phases concurrently, and all three phases are performed
repeatedly in a cycle until the system is completed.
A. Prototyping
B. Rapid Application Development (RAD)
C. Joint Application Design (JAD)
D. Participatory design (PD)
E. All
3.10 Defining scope of the project, feasibility study and constraints are done
in
A. Planning and Selection
B. Analysis
C. Design
D. Implementation
Discussion Questions
1. Discuss the important and skills of the system analyst in developing the
system.
2. Discuss the three major approaches to System Development?
3. What do you understand by traditional waterfall model of SDLC? Write
its advantages and limitation.
4. Write down some major activities which has been done in
implementation and operation phase of SDLC.
5. What are different approaches for developing System? Discuss any two
of them.
Chapter IV
Chapter Objective
Project Identification and Selection
Project Initiation and Planning
Feasibility Study
Building the Baseline Project Plan
Reviewing the Baseline Project Plan
Electronic Commerce Application: Internet Basics
The requests for developing information system can come from three key sources
Managers and business units who want to replace or extend and
existing system in order to gain needed information or to provide
a new service to customers.
Information Systems managers who want to make a system more
efficient, less costly to operate or want to move a system to a
new operating environment.
Formal planning group that want to improve an existing system
in order to help the organization meet its corporate objectives,
such as providing better customer service.
The Selection Process may vary in different organizations, but the general
process is discussed below.
focus. The development group identifies projects based on the ease with
existing hardware and systems. Hence, projects may be identified by
both top-down and bottom-up initiatives. The systems analyst should
support these groups, to describe their information needs.
Classifying and ranking IS development projects: Done by top
managers, a steering committee, business units or the IS development
group. The criteria commonly used to evaluate projects are
Value chain analysis: Extent to which activities add greatest
benefits
Strategic alignment: Extent the projects achieves the long term
goals
Potential benefits: Extent to which the project helps to improve
profits, Customer service, etc and the duration of the benefits
Resource availability: Amount and type of resources required for
the project
Project size / duration: Number of individuals and duration to
complete
Technical difficulty / risk: Level of technical difficult to
complete.
Project Planning focuses on defining clear, discrete tasks and the work needed
to complete each task. The objective of the project planning is to produce two
documents: a Baseline Project Plan (BPP) and the Statement of Work (SOW).
The BPP is an internal document used by the development team but not shared
with customers. The BPP contains all information collected and analyzed during
the project initiation and planning activity. The BPP reflects the best estimate of
the project‘s scope, benefits, costs, risks and resource requirements. The BPP
specifies detailed project activities for the next life cycle phase- Systems analysis
and less detail for subsequent phases.
The SOW is a short document prepared for the customers that describe what the
project will deliver and outlines all work required to complete the project. The
SOW is a useful communication tool that assures that both system analysts and
customers have a common understanding of the project.
2. Operational Feasibility- This process examines whether the new project will
attain its desired objectives. The goal of this study is to understand the degree to
which the proposed system will likely solve the business problems or take
advantage of the opportunities specified in the Systems requirement documents.
An operational Feasibility concern is to does the proposed system solve problems
or take advantage of opportunities?
A Handbook on System Analysis and Design 49
In addition to reviewing the BPP, the walkthrough can be used for the following
activities
- System specifications
- Logical and physical designs
- Code or program segments
- Test procedures and results
- Manuals and documentation
The key advantage of using a structured review process is to ensure that found
review points occur during the project. At each phase of the project, a formal
review should be conducted to make sure that all aspects of the projects are
satisfactory accomplished before assigning additional resources to project. This
conservative approach of reviewing each major activity with continuation
contingent on successful completion of the prior phase is called incremental
commitment.
A Handbook on System Analysis and Design 51
E-Commerce is one of the most important facets of the Internet to have emerged
in the recent times. E-commerce or electronic commerce involves carrying out
business over the Internet with the assistance of computers, which are linked to
each other forming a network. To be specific e-commerce would be buying and
selling of goods and services and transfer of funds through digital
communications i.e. the internet especially the World Wide Web. Electronic
commerce or e-commerce refers to a wide range of online business activities for
products and services. It also pertains to ―any form of business transaction in
which the parties interact electronically rather than by physical exchanges or
direct physical contact.‖
E-commerce is the use of electronic communications and digital information
processing technology in business transactions to create, transform, and redefine
relationships for value creation between or among organizations, and between
organizations and individuals. It is usually associated with buying and selling
over the Internet, or conducting any transaction involving the transfer of
ownership or rights to use goods or services through a computer-mediated
network.
• Distributing, buying, selling and marketing products and services over
electronic systems
• E-business for commercial transactions
• Involves supply chain management, e-marketing, online marketing, EDI
2. Intranet-based
Supports business activities within a single organization
3. Extranet-based
Supports business-to-business activities
52 A Handbook on System Analysis and Design
Internet Basics
The Internet is a global network connecting millions of computers. More than
100 countries are linked into exchanges of data, news and opinions. According to
Internet World Stats, as of December 31, 2011 there was an estimated
2,267,233,742 Internet users worldwide. This represents 32.7% of the world's
population.
Unlike online services, which are centrally controlled, the Internet is
decentralized by design. Each Internet computer, called a host, is independent. Its
operators can choose which Internet services to use and which local services to
make available to the global Internet community. Remarkably, this anarchy by
design works exceedingly well. There are a variety of ways to access the
Internet. Most online services offer access to some Internet services. It is also
possible to gain access through a commercial Internet Service Provider (ISP).
Web Browsers
Web browsers are computer programs that can:
- Display Web documents
- Follow links
- Execute other programs
- Enhance applications such as real-time audio or video
Learning Chapter 4
4.1 The process of evaluating how key stakeholders within the organization
view the proposed system is part of
A. Schedule Feasibility
B. Legal Feasibility
C. Political Feasibility
D. Technical Feasibility
A Handbook on System Analysis and Design 53
4.4 Which feasibility study concern that the proposed system solves
problems or take advantage of opportunities?
A. Operational Feasibility
B. Technical Feasibility
C. Schedule Feasibility
D. Legal Feasibility
E. All
4.5 Which one is the third stage of system planning and selection?
A. Reviewing the Baseline Project Plan
B. Feasibility Study
C. Project Identification and Selection
D. Project Initiation and Planning
E. Building the Baseline Project Plan
4.7 Two documents a Baseline Project Plan (BPP) and the Statement of
Work (SOW) is produced in which stage?
A. Project Initiation and Planning
B. Project Identification and Selection
C. Feasibility Study
D. Building the Baseline Project Plan
54 A Handbook on System Analysis and Design
Discussion Questions
1. Write the two major differences between BPP and SOW?
2. What are the different types of feasibility study done in planning and
selection stage of SDLC?
3. Write the two major differences between fourth and fifth stage of
planning and selection phase?
4. What are the five stages or steps in the phase of Planning and selection
phase of SDLC?
5. Define E-commerce and write its few advantages.
Chapter V
Systems Analysis
Chapter Objective
System Analysis and its parts
Requirements Determination
Traditional Methods for gathering requirements
(Interviewing, Questionnaire, Observation and Analysing Documents)
Modern methods for gathering requirements
(Joint Application Design, Business Process Re engineering &
Prototyping)
5. 2 Requirements Determination
Requirement determination means gathering information on what the system
should do from as many sources as possible. An analyst use system requirements
determination to understand current problems and opportunities as well as what
is needed and desired in future systems. The sources can be the users of the
current system, reports, forms and procedures. All the system requirements are
carefully documented and made ready for structuring.
The characteristics of a good systems analyst in determining the requirements are
o Impertinence: You should question about each and every
aspects involved in the system.
o Impartiality: The role of a SA is to find the best solution to a
business problem or opportunity. Not to justify the purchase of
new hardware or to insist some requirements. The issues raised
by all parties must be considered and to find the best
organizational solution.
o Relaxing of Constraints: Assume that anything is possible and
eliminate the infeasible and traditions. Traditions are different
from rules and policies, it may be good but as the organization
and its environments changes, the traditions not to be
appreciated.
o Attention to details: Every fact must fit with every other fact.
One element out of place means that the ultimate system will fail
at some time.
A Handbook on System Analysis and Design 57
5.3.1 Interviewing
The SA (System Analyst) has to spend a large amount of time in interviewing the
people about their work, the information they use to do it and the types of
information processing that might supplement their work. Other people are too
58 A Handbook on System Analysis and Design
Interview Guidelines
1. Plan the interview.
A Handbook on System Analysis and Design 59
Each question in an interview guide can include both verbal and non-verbal
information.
Individual Interviews: - Interview one person at a time.
Advantages: Easier to schedule than group interviews
Disadvantages: Contradictions and inconsistencies between interviewees.
Follow-up discussions are time consuming
Group Interviews:-Interview several key people together.
Advantages: More effective use of time, Can hear agreements and
disagreements at once, Opportunity for synergies
Disadvantages: More difficult to schedule than individual interviews
5.3.2 Questionnaires
Questionnaires have the advantage of gathering information from many people in
a relatively short time. Interviews are quite expensive and time-consuming
process, but the questionnaires are not expensive. Questionnaires are passive and
often yield less rich information than interviews. Questionnaires are most useful
in the requirements determination process when used for very specific purposes
rather than for more general information gathering.
Designing Questionnaires
Questionnaires are less expensive means that the people can complete
the questionnaire without help. Also answers can be provided at the
convenience of the respondent.
60 A Handbook on System Analysis and Design
The purpose of on-site observation is to get as close as possible to the real system
being studied. It is the process of recognizing and noting people, objects and
occurrences to obtain information. As an observer the analyst must follow a set
of rules. He/she must listen than talk and not give advice or pass a moral
judgment, must not argue or show friendliness towards others. The following
questions can serve as a guide for on-site observations:
What kind of system is it? What does it do?
Who runs the system? Who are the important people in it?
What is the history of the system?
2. Informal
a. The way a system actually works in practice
b. Interviews and observation reveal informal system
JAD sessions are held in a special room equipped with white boards, audiovisual
tools, overhead projector, flip charts and computer generated displays.
5.4.3 Prototyping
Prototyping allows to quickly converting basic requirements into a working,
though limited, version of the desired information system. The user can view and
test the prototype. The goal of prototyping is to support requirements
determination to develop concrete specifications for the ultimate system, not to
build the ultimate system.
Prototyping is most useful in the following circumstances
o User requirements are not clear or well understood
o Only one or a few users involved
o Possible designs are complex
o Communication problems have existed in the past, between
users and analysts
Learning Chapter 5
5.1 The overall process by which current methods are replaced with
radically new methods is referred as.
A. JAD (Joint Application Design)
B. RAD (Rapid Application Development)
C. Prototyping
A Handbook on System Analysis and Design 65
5.4 A person responsible to take notes during the sessions and record the
outcomes of the JAD meeting is known as
A. User
B. Scribe
C. User Manager
D. System Analyst
5.7 It is a good tool for collecting rich, detailed information and its allowed
exploration and follow-ups but quite time intensive and expensive.
A. Questionnaires
B. Interview
C. Observation
D. Analysis of Documents
66 A Handbook on System Analysis and Design
5.8 Which method is treated appropriate when user requirements are not
clear and design is complex?
A. Prototyping
B. JAD (Joint Application Design)
C. BPR (Business Process Reengineering)
D. RAD (Rapid Application Development)
E. All
Discussion Questions
1. What are the characteristics of a good systems analyst in determining the
requirements for system?
2. Explain the different sources for analysing of documents in the
organisation for gathering requirements.
3. Write some major characteristics of three main modern method of data
collection.
4. Explain some situation for choosing between interview or questionnaire
method of data collection.
Chapter VI
Systems Analysis
Chapter Objective
Structuring Systems Requirements
Process Modeling (DFD Diagrams)
Conceptual Data Modeling (ER Diagrams)
Data flow-
It is the directional movement of data to and from external entities, the process
and data stores. If it flows into a data store, means a write, update, delete, etc. if
flows out of data stores, mean read, query, display, select types of transaction.
Symbol: Solid line with arrow. Each data flow is identified with a
descriptive name that represents the information on the data flow.
Example.
Registration data
Process -
It is a work or actions performed on data so that they are transformed, stored, or
distributed. When modeling the data processing of a system, it doesn‘t matter
whether process is performed manually or by a computer.
Depending on the level of the diagram it may represent the whole system
as in a Context (level 0) diagram or a business area, process (activity),
function, etc. in lower levels.
Symbol: Circle or a Rounded Rectangle. Example.
Data Store:
It is repository of information. In the physical model, this represents a file, table.
Symbol: Two parallel lines or open ended rectangle. Example.
External Entity
It is a source/sink (the origin and /or destination of the data). It is a person or
group which interacts with the system and something from outside the system.
E.g. Customer, supplier, government agency, accounting dept, etc. usually
external to the business or system but may be internal
Data must be originated outside a system from one or more sources, and
A Handbook on System Analysis and Design 69
Developing DFD’s
The DFD for Hoosier burger food ordering system - An example
A context diagram is a DFD that provides a general overview of a system, other
DFD‘s can be used to focus the details of a context diagram. This context
diagram contains only one process, no data stores, four data flows, and three
external entities. The single process labeled ―0‖, represents the entire system. All
context diagrams have only one process labeled ―0‖. No data stores appear on a
context diagram, since the data stores of the system are conceptually inside the
one process.
After drawing the context diagram, the next step is to analyze the
processes are represented by the single process. There are four main
processes are identified, the processes represent the major functions of
the system, the major functions are
o Capturing data from different sources (process 1)
o Maintaining data stores (process 2 and 3)
70 A Handbook on System Analysis and Design
The flow from first process 1. are 1) the food order is transmitted to the
kitchen, 2) the customer order is transformed into a list of goods sold, 3)
the customer order is transformed into inventory data, and 4) the process
generates a receipt for the customer.
Two of the data flows generated by the process, receive and transform
customer food order, go to external entities, not to concern about what
happens outside of our system..
The data labeled Goods Sold go to process 2, update Goods Sold file.
The output for this process is labeled Formatted Goods Sold Data. The
output updates a data store labeled Goods Sold File. Daily Goods Sold
amounts are then used as input to process 4, Produce Management
reports. Similarly the data flow generated by process 1 called Inventory
Data, serves as input for process 3, Update Inventory File. The Daily
Inventory Depletion amounts are then used as input to process 4.
The DFD hides the physical characteristics of the system it describes.
Process 1 and 3 are coupled to each other, since the data flow from
process 1 must be readily accepted by process 3.
Process 2 and 4 are decoupled by placing a buffer, a data store.
B. No process can have only inputs. If an object has only inputs, then it
must be a sink
Data Store
D. Data cannot move directly from one data source to another data
source. Data must be moved by a process
F. Data cannot move directly to an outside sink from a data store. Data
must be moved by a process.
Data Flow
J. A data flow has only one direction of flow between symbols. It may
flow in both directions between a process and a data store to show a
read before an update. The latter is usually indicated, however by
two separate arrows because these happen at different times.
K. A fork in a data flow means that exactly the same data go from a
common location to two or more different processes, data stores, or
sources/sinks.
A Handbook on System Analysis and Design 73
L. A join in a data flow means that exactly the same data come from
any of two or more different processes , data stores, or sources/sinks
to a common location
Decomposition of DFD’s
The act of going from a single system to more component processes is called
decomposition. The functional decomposition is a repetitive process of breaking
the system into finer and finer detail. Each of the processes (or subsystem) is also
candidate for decomposition. Each process may consist of several sub processes.
Each sub process may also be broken down into smaller units.
Decomposition continues until no sub process can logically be broken down any
further. The lowest level of DFD is called primitive DFD. The first process in the
figure-2 can be decomposed into four different outputs. 1) Receive a customer
order, 2) transform the entered order into a printed receipt for the customer, 3)
transform the order into a form meaningful to the kitchens system 4) transform
the order into goods sold data, and 5) transform the order into inventory data.
The decomposition of Process 1 is given below
74 A Handbook on System Analysis and Design
The context and level-0 diagram will show the sources and sinks. No sources or
sinks are represented in figure-3. We can decompose processes 2, 3, or 4 in a
similar manner. In general, a level-n diagram is a DFD that is generated is form n
nested decompositions from a level-0 diagram. As a rule of thumb, no DFD
should have more than about seven processes in it.
The labels for the processes and numbering rules for clear communication,
process names should be clear and concise; it may begin with an action verb,
such as receive, calculate, transform, generate or produce. Process 4 can be
further decomposed into level-1, level-2 as given below.
A Handbook on System Analysis and Design 75
Balancing DFDs
The conservation of inputs and outputs to a data flow diagram process
when that process is decomposed to a lower level.
For Ex. Process 1, which appears in a level-0 diagram, must have the
same inputs and outputs when decomposed into a level-1 diagram is
called balancing.
The principle of balancing and goal of keeping a DFD as simple as
possible lead to four additional, advanced rules for drawing DFDs.
o A composite data flow on one level can be split into component
data flows at the next level, but no new data can be added and all
data in the composite must be accounted for in one or more sub
flows.
o The input to a process must be sufficient to produce the outputs
from the process. Thus all outputs can be produced, and all data
in inputs move somewhere, either to another process or to a data
store outside the process or on a more detailed DFD showing a
decomposition of that process.
o At the lowest level of DFDs, new data flows may be added to
represent data that are transmitted under exceptional conditions,
these data flows typically represent error messages or
76 A Handbook on System Analysis and Design
confirmation notices.
o To avoid having data flow lines cross each other, you may repeat
data store or entities on a DFD. Use an additional symbol, like a
double line on the middle vertical line of a data store symbol, or
a diagonal line in a corner of a entity square, to indicate a
repeated symbol.
INFORMATION
Entity
£ A data entity is anything real or abstract about which we want to store
data.
£ Entity types fall into five classes: roles, events, locations, tangible things
or concepts. E.g. employee, payment, campus, book. Specific examples
of an entity are called instances. E.g. the employee John Jones, Mary
Smith's payment, etc.
Relationship
£ A data relationship is a natural association that exists between one or
more entities. E.g. Employees process payments.
£ Cardinality defines the number of occurrences of one entity for a single
occurrence of the related entity. E.g. an employee may process many
payments but might not process any payments depending on the nature
of her job.
Attribute
£ A data attribute is a characteristic common to all or most instances of a
particular entity. Synonyms include property, data element, field. E.g.
Name, address, Employee Number, pay rate are all attributes of the
entity employee.
£ An attribute or combination of attributes that uniquely identifies one and
only one instance of an entity is called a primary key or identifier. E.g.
Employee Number is a primary key for Employee.
A Handbook on System Analysis and Design 79
A SIMPLE EXAMPLE
A company has several departments. Each department has a supervisor and at
least one employee. Employees must be assigned to at least one, but possibly
more departments. At least one employee is assigned to a project, but an
employee may be on vacation and not assigned to any projects. The important
data fields are the names of the departments, projects, supervisors and
employees, as well as the supervisor and employee number and a unique project
number.
1. Identify Entities
The entities in this system are Department, Employee, Supervisor and Project.
One is tempted to make Company an entity, but it is a false entity because it has
only one instance in this problem. True entities must have more than one
instance.
2. Find Relationships
We construct the following Entity Relationship Matrix:
80 A Handbook on System Analysis and Design
6.4 Which data models are commonly used diagrams that show how data is
organized in a system?
A. DFD (Data Flow Diagram)
B. ER (Entity Relationship) Diagram
C. Both
D. None
6.6 The act of going from a single system to more component processes is
called..........................
6.8 There are two stages in the structuring process ................................. and
..................................
6.9 One rule is to stop drawing DFD is when the lowest logical level is
reached. This lowest level is known as...........................
Discussion Questions
1. Draw a simple Data Flow Diagram (DFD) of your choice which shows
its entire symbol.
2. Draw a level1 DFD diagram for banking process.
3. Draw a rough Entity Relationship diagram for a college.
Chapter VII
System Design
Chapter Objective
System Design and its goal
Logical design and Physical design
Designing effective input, output, database and user interface
Steps of Design Phase
The design phase is concerned with the physical construction of the system.
Included are the design or configuration of the network (hardware, operating
system, programming, etc.), design of user interfaces (forms, reports, etc.),
design of system interfaces (for communication with other systems), and security
issues. It is important that the proposed design be tested for performance, and to
ensure that it meets the requirements outlined during the analysis phase. In other
words, the main objective of this phase is to transform the previously defined
requirements into a complete and detailed set of specifications which will be
used during the next phase. Some of the activities that need to take place during
the design phase are:
Design the application
Design and integrate the network
Design and integrate the database
Create a contingency plan
Start a Maintenance, Training and Operations plan
Review the design
Articulate the business processes and procedures
Establish a transition strategy
Deliver the System Design Document
Review final design
In the design phase, all inputs, computations and outputs of the system should be
converted into a software model so that it can be coded by programmers. The
hardware requirements are also determined at this stage along with a picture of
the overall system architecture.
Physical design relates to the actual input and output processes of the system.
A Handbook on System Analysis and Design 85
This is laid down in terms of how data is input into a system, how it is verified /
authenticated, how it is processed, and how it is displayed as In Physical design;
the following requirements about the system are decided. The physical design of
an information system is a plan for the actual implementation of the system
1. Input requirement,
2. Output requirements,
3. Storage requirements,
4. Processing Requirements,
5. System control and backup or recovery.
Example – Application form for college admission, Attendance data for the
employees
Reservation form for ticket booking
Input Media:
Source Document Conversion Devices: These devices convert the input to a
computer acceptable form ex. Punch Card Reader, Key to tape, key to disk, key
to cassette devices.
By- Product Data Capture devices: Capture data in a computer acceptable form
as a byproduct of some essential operation. e.g. Billing machines, Cash register,
Accounting machines.
Direct Data Capture Devices: These devices capture data without any
conversion, for example, Optical mark reader, Magnetic Ink Character Reader,
and so on.
Online Data Entry Devices: Teletype writers, Visual Display Units, Audio
response terminals, light pens, and so on.
Output Characteristics
An output layout is the arrangement of items on the output medium. A layout is
used as a mockup of the actual report or document as it would appear after the
A Handbook on System Analysis and Design 87
Types of Output
Tabular: It is recommended to present details when only a few narrative
comments or explanations are needed, when details can be described in discrete
categories or when total and subtotals are appropriate. Certain information in the
tabular formats should visibly stand out:-
Exceptions to normal expectations,
Major categories or groups of activities or entities
Summaries
Unique identification information
Time dependent entities
Types of Graphs
Pie charts describe portions of a whole associated with a particular
development or activity.
Area charts show change in performance along a scale over multiple
time periods. A horizontal scale indicates time and the vertical scale
measures the units of interest. Several items overlaid on the same chart
enable the reader to compare different items.
88 A Handbook on System Analysis and Design
Icons: They are the pictorial representation of entities described by the data.
Properly selected icons communicate information immediately as they duplicate
images that users are already familiar with. They eliminate the necessity for users
to learn abbreviations, notation or special nomenclature. In contrast taking time
to read labels or footnotes usually contributes to complexity. It can also
substitute for tabular report and are especially useful in showing proportions or
comparisons. Icons are commonly used in computer interfaces to represent
documents, printers etc. One must use the same icon to represent identical
concepts. One must avoid labeling the icons. One should use a layout that
maintains space and avoids overcrowding between icons. Also one should
maintain a common size among different types of symbols.
Types of Reports
Detailed reports (Contain detailed information on business transactions.
A report may be for a single transaction or contain information about e.g.
a particular account)
Summary reports (Often used by middle management to track
departmental or division performance)
Exception reports (Conveys information about any extraordinary event)
Executive reports (Normally used for strategic decisions by top
management)
Structuring the data into stable structures, called normalized tables with
minimum of redundancy
_ Developing logical database design that reflects the actual data
requirements
_ Translate logical design into physical design
Interface Types
Menu driven: It presents the system with various alternatives.
Menu Alternatives – The menu choices are presented in single word in keyword
dialogue approach. In some systems pull down menu is used. In pull down
menus, the drop down alternatives are displayed, when the keyword is pointed at
by using the mouse. Nested menu are used when there are extensive set of
alternatives to choose from. A selection from a set of choice leads to a
subsequent decision about other alternatives. Decisions are made in top down
fashion.
Menu Interfaces - Menu dialogues can be designed using many interface devices
such as keyboard, mouse, light pen, touch screens etc.
Menu Placement Strategies -The menu of options can be positioned on the
display screen in several ways. It can be a single column or double column
display as used in transaction processing systems and reporting systems. On the
other hand to facilitate retention of information on the display and at the same
time to offer menu selections to users - the menu can be shown horizontally at
the top or bottom of the screen
Question Answer based: It relies on the presentation of the question to the user.
The answer guides the resultant processing. It has two formats
_ Yes / No answers
_ Narrative responses: This strategy allows for presentations of more
elaborate questions and alternatives than do the other strategies. It
requires the analyst to anticipate every possible answer a user may
provide for a difficult task. The analyst should take care to minimize the
number of words used to speed user-system interaction and to avoid
possible errors.
Based on the design specifications, the software and hardware selection and
acquisition is made and eventually actual program development takes place.
A Handbook on System Analysis and Design 91
7.2 Which type of Design is usually done into the analysis part of System
Development?
A. Physical Design
B. Logical Design
C. Both
92 A Handbook on System Analysis and Design
D. None
7.3 Which design defines the functions and features of the system and the
relationships among its components?
A. Physical Design
B. Logical Design
C. Both
D. None
7.4 Which one is the part of physical design for the system?
A. Input requirement,
B. Output requirements,
C. Storage requirements,
D. Processing Requirements,
E. System control and backup or recovery.
F. All
7.5 Which one of the following is not the example of Input Media?
A. Optical mark reader
B. Magnetic Ink Character Reader,
C. Light Pens
D. All
E. None
7.7 The person who is coding the design into computer understandable
language is...........................
7.1 B 7.2 B 7.3 B 7.4 F 7.5 E 7.6 Logical and Physical design 7.7
Programmer 7.8 Outsourcing
Discussion Questions
1. What are the different objectives and goals of the design phase of System
Development Life Cycle?
2. Write down about the major consideration for user interface design.
3. Discuss the four major steps of Design phase.
Chapter VIII
Systems Implementation
Chapter objective
The Processes of Coding
System Testing
System Installation
Post implementation review
Systems maintenance
Bug-fixing, Enhancements
Performance testing
Performance has always been a great concern and a driving force of computer
evolution. Performance evaluation of a software system usually includes:
resource usage, throughput, and stimulus-response time and queue lengths
detailing the average or maximum number of tasks waiting to be serviced by
A Handbook on System Analysis and Design 95
Reliability testing
Software reliability refers to the probability of failure-free operation of a system.
It is related to many aspects of software, including the testing process. Directly
estimating software reliability by quantifying its related factors can be difficult.
Testing is an effective sampling method to measure software reliability. The
robustness of a software component is the degree to which it can function
correctly in the presence of exceptional inputs or stressful environmental
conditions.
Stress testing, or load testing, is often used to test the whole system
rather than the software alone. In such tests the software or system are
exercised with or beyond the specified limits. Typical stress includes
resource exhaustion, bursts of activities, and sustained high loads.
Security testing
Software quality, reliability and security are tightly coupled. Flaws in software
can be exploited by intruders to open security holes. With the development of the
Internet, software security problems are becoming even more severe. Many
critical software applications and services have integrated security measures
against malicious attacks. The purpose of security testing of these systems
include identifying and removing software flaws that may potentially lead to
security violations, and validating the effectiveness of security measures.
Simulated security attacks can be performed to find vulnerabilities.
Integration Tests
The process of bringing together all of the modules that a program comprises for
testing purposes. Modules are typically integrated in a top-down, incremental
fashion.
Subsystem/System Testing
It is the bringing together of all the programs that a system comprises for testing
purposes. All results should be documented on the Test Analysis Report, Test
Problem Report and on the Test Analysis Approval Determination. Any failed
components should be migrated back to the development phase for rework, and
96 A Handbook on System Analysis and Design
Acceptance Testing
It is the process whereby actual users test a completed information system. The
end result of which is the users acceptance of it.
8.3 Installation
After having the user acceptance of the new system developed, the
implementation phase begins. Implementation is the stage of a project during
which theory is turned into practice. The major steps involved in this phase are:
1. Acquisition and Installation of Hardware and Software
2. Conversion
3. User Training
4. Documentation
2. Conversion
The conversion is also one of the most critical and expensive activities in the
system development life cycle. The data from the old system needs to be
converted to operate in the new format of the new system. The database needs to
be setup with security and recovery procedures fully defined. With the
implementation of any system, typically there is old data which is to be included
A Handbook on System Analysis and Design 97
3. User Training
During this phase, all the programs of the system are loaded onto the user‘s
computer. After loading the system, training of the user starts. Main topics of
such type of training are:
How to execute the package
How to enter the data
How to process the data (processing details)
How to take out the reports
It is always a good business practice to provide training before the end user uses
the new system. Because there has been a previously designed training plan
established, complete with the system user manual, the execution of the plan
should be relatively simple. Typically what prevents a plan from being
implemented is lack of funding. Good budgeting should prevent this from
happening.
After the users are trained about the computerized system, working has to shift
from manual to computerized working. The process is called ‗Changeover‘. The
following strategies are followed for changeover of the system.
(i) Direct Changeover: This is the complete replacement of the old system
by the new system. It is a risky approach and requires comprehensive
system testing and training.
(ii) Parallel run: In parallel run both the systems, i.e., computerized and
manual, are executed simultaneously for certain defined period. The
same data is processed by both the systems. This strategy is less risky but
more expensive because of the following:
Manual results can be compared with the results of the computerized
system.
The operational work is doubled.
98 A Handbook on System Analysis and Design
Failure of the computerized system at the early stage does not affect the
working of the organization, because the manual system continues to
work, as it used to do.
(iii) Pilot run: In this type of run, the new system is run with the data from
one or more of the previous periods for the whole or part of the system. The
results are compared with the old system results. It is less expensive and
risky than parallel run approach. This strategy builds the confidence and the
errors are traced easily without affecting the operations.
The user documentation is a complete description of the system from the users‘
point of view detailing how to use or operate the system. It also includes the
major error messages likely to be encountered by the users. The system
documentation contains the details of system design, programs, their coding,
system flow, data dictionary, process description, etc. This helps to understand
the system and permit changes to be made in the existing system to satisfy new
user needs
System documentation is detailed information about a system‘s design
specifications, its internal workings, and its functionality. It is meant for
maintenance programmers. It is further divided into internal and external
documentation. Internal documentation is part of the program source code or is
generated at compile time. External documentation includes the outcome of all of
the structured diagramming techniques such as DFD and ERD.
User documentation is written or visual information about an application
system, how it works and how to use it. The kinds of user documents are
reference guide, user‘s guide, release description, system administrator‘s guide
and acceptance sign-off. The reference guide consists of exhaustive list of the
system‘s functions and commands usually in alphabetical order. The purpose of
the reference guide is to provide information on how users can use computer
systems to perform specific tasks. The information in user‘s guide is typically
ordered by how often tasks are performed and how complex they are. The release
description contains information about a new system release, including a list of
complete documentation for the new release, features and enhancements, known
problems and how they have been dealt with in the new release and information
about installation. The systems administrator‘s guide is intended to those who
A Handbook on System Analysis and Design 99
will install and administer a new system and contains information about the
network on which the system will run, software interfaces for peripherals such as
printers, trouble shooting, and setting up user accounts. The acceptance sign-off
allows users to test for proper system installation and then signify their
acceptance of the new system and its documentation with their signatures.
Systems Operations
Operations support is an integral part of the day to day operations of a
system. In small systems, all or part of each task may be done by the
same person. But in large systems, each function may be done by
separate individuals or even separate areas. The Operations Manual is
developed in previous SDLC phases. This document defines tasks,
activities and responsible parties and will need to be updated as changes
occur.
Systems operations activities and tasks need to be scheduled, on a
recurring basis, to ensure that the production environment is fully
functional and is performing as specified. The following is a checklist of
systems operations key tasks and activities:
o Ensure that systems and networks are running and available
during the defined hours of Operations;
o Implement non-emergency requests during scheduled Outages,
as prescribed in the Operations Manual;
o Acquisition and storage of supplies (i.e. paper, toner, tapes,
removable disk);
o Perform backups (day-to-day protection, contingency);
o Perform the physical security functions including ensuring
adequate UPS, Personnel have proper security clearances and
proper access privileges etc.;
o Ensure contingency planning for disaster recovery is current and
tested ;
o Ensure users are trained on current processes and new processes;
o Maintain performance measurements, statistics, and system logs.
Examples of performance measures include volume and
frequency of data to be processed in each mode, order and type
of operations;
than the day-to-day volume backups. The backup and recovery process
of the data bases should be done as a Data / Software Administration
task by a data administrator.
A checklist of Data / Software Administration tasks and activities are:
o Performing a periodic Verification / Validation of data, correct
data related problems
o Installing, configuring, upgrading and maintaining data base(s).
This includes updating processes, data flows, and objects
o Developing and performing data / data base backup and recovery
routines for data integrity and recoverability.
o Developing and maintaining a performance and tuning plan for
online process and data bases.
8.3 This is also called the programming phase in which the programmer
converts the program specifications into computer instructions
A. Coding
B. Maintenance
C. Training
D. Implementation
8.4 White box testing and black box testing is the part of
A. Correctness testing
B. Performance testing
C. Reliability testing
D. Security testing.
8.6. The users are trained about the computerized system; working has to
shift from manual to computerized working. The process is
called.................................
8.7 ........................... means the review of the system from time to time
8.8 There are generally two types of documentation prepared for any
system. These are..................................and...........................................
Discussion Questions
1. Write the major steps involved in implementation.
2. Discuss the different types of software testing.
3. What is post implementation review and why it is so important?