1 of 232

V-LRN� VIRTUAL LEARNING NETWORK

2 of 232

MCS-014

�System Analysis and Design�

3 of 232

BLOCK – 1��INTRODUCTION TO SYSTEM�DEVELOPMENT

4 of 232

Block -1

Unit -1

Introduction to SAD

5 of 232

Topics to be covered

  • System
  • What is information system
  • Classification of system
  • Characteristics of system
  • Types of users of system
  • Types of real time systems
  • Distributed system
  • Development of a Successful System
  • Information system Approaches
  • Define JAD?

6 of 232

�SYSTEM �

SYSTEM :

It is defined as the orderly grouping of inter – dependent components linked together according to a plan to achieve a specific goal.

Each component is a part of total system and it has to do it’s own share of work for the system to achieve the desired goal.

System word is derived from Greek word ‘Systema’ which means an Organized relationship among components.

7 of 232

What is Information system?

  • Information system – arrangement of people data, processes information presentation and information technology that interacts to support and improve day to day operations in a business as support the problem solving and decision making needs of management and users

8 of 232

Classification of System

  1. Formal or Informal
  2. Physical or Abstract
  3. Open or Closed
  4. Manual or Automated

BOUNDARY : It is the thin line between the firm and it’s environment.

9 of 232

Classification of systems

1.Formal (planed in terms of policies and procedure and scheduled in advance) /informal (need oriented like sales order processing system through telephone calls)

  • 2.Physical (tangible entities like hw /vehicles )/abstract (conceptual )
  • 3.Open system (within its environment example. organization ) or closed (isolated system e.g. feedback or control system )
  • 4.Manual human being involved like in railway stations /automated like traffic control system.
  •  5.    Real time system : used where there are rigid time requirements on the flow of data.

10 of 232

Characteristics of system

  • Organization
  • Interaction
  • Interdependency
  • Centralized objectives

11 of 232

Characteristics of a system

The characteristic of a system are as follows :

  1. Organization : It implies structure and order. It is an arrangement of components that helps to achieve objectives.
  2. Interaction : In which each component functions with other component of the system.
  3. Interdependence : One component depends on the another component.
  4. Integration : Concerned with how a system is tied together.
  5. Central Objective (Main point): Quite common that an organization may set one objective and operate to achieve another.

12 of 232

�Types of users of system �

  • Why do business need system analyst ?

Types of users of system -

  • Internal (within the organization )
  • External (internet access users )

13 of 232

Types of Real time system

1.Hard real time system - that is task guarantee completed on time.

2. Soft real time – less restrictive to time as priority are measured like in scientific experiments /medical imaging system and industrial control system.

14 of 232

Distributed system

  • A distributed system in which data ,process and interface component of information system are distributed to multiple locations in a computers network. Processing workload is also distributed across multiple computers.

15 of 232

Development of a Successful System

SDLC – System Development Life Cycle is a standard methodology for the development of Information Systems. It mainly consist of four phases :

(a) System Analysis

(b) System Design

(c) System Construction

(d) Implementation and System support.

16 of 232

Approaches to Development

  1. PROTOTYPING : Designing and building a scaled down but fundamental version of a desired system is known as prototyping or Construct a Model.
  2. JOINT APPLICATION DEVELOPMENT : The basic idea behind JAD is to bring structure to the requirements determination phase of analysis and to the reviews that occur as part of design.
  3. PARTICIPATORY DESIGN : In this the entire user community gets involved in the development process.

17 of 232

Information system Approaches

Approaches for the development of Information Systems :

  1. Model Driven : It emphasizes the drawing of pictorial system models to document and validate both existing and/or proposed system.
  2. Accelerated Approach : A prototyping approach is used in this.
  3. Joint Application Development : It is also known as the structured approach in which users, managers and analysts work together for several days.

18 of 232

Define JAD?

Joint Application Development – It is defined as a structured approach in which users, managers ,analyst, sponsors and system analyst work together for several days in a series of intensive meetings to specify or review system requirements.

 

  • The important feature of JAD is joint requirements planning ,which is a process whereby highly structured group meetings are conducted to analyse problem and define requirements

19 of 232

Block -1

Unit -2

System Analyst – A Profession

20 of 232

MCS-014

�System Analysis and Design�

21 of 232

Topics to be cover

  • Roles of system analyst
  • Duties of system analyst
  • Qualification of system Analyst
  • Analytical / Technical / Managerial & Interpersonal skills of system analyst.

22 of 232

�SYSTEM ANALYST

System analyst is basically a person that bridges the gap between the person’s belonging to the IT industry who are going to provide the solution to the problem of “industry peoples” or “system user’s” who are also known as “clients” who needs their system to get automated so that they can take decisions in the shortest span of time. (It is required for analysis and design of that system.)

23 of 232

�USER

They are basically defined as the people who use information systems or who are affected by the information system on a regular basis. A common synonym is CLIENT.

There are two types of USER’S :

  1. Internal user. : employee of the organization
  2. External user.: customer of the organization

24 of 232

Role of a system Analyst

  1. Change agent (Agent of change)
  2. Investigator and monitor (System investigate and monitor)
  3. Architect (Design a System)
  4. Psychologist (Analyst play a role of Psychologist in a way to reaches people thoughts)
  5. Motivator (analyst play a role of motivator)
  6. Intermediary (analyst try to deal with people or diplomacy)

25 of 232

Duties of a System Analyst :

  1. Defining requirements
  2. Prioritizing requirements by consensus
  3. Analysis and Evaluation
  4. Solving problems
  5. Functional specifications
  6. Designing systems
  7. Evaluating systems

26 of 232

Skills of system Analyst :

  1. Analytical skills (Analysis problems)
  2. Technical skills (Technical problems)
  3. Mgmt. Skills (Management problems)
  4. Interpersonal skills. (Interpersonal problems (staff), Communication skills, working alone or with group)

27 of 232

Analytical skills

  • System study
  • Organizational knowledge
  • Problem identification
  • Problem analysis and problem solving

28 of 232

Communication skills

  • Business writing /speaking
  • Interviewing
  • Listening
  • Technical discussion
  • Technical writing

29 of 232

Management skills

  • Resource mgmt.
  • Project mgmt
  • Risk mgmt
  • Change mgmt.

30 of 232

Interpersonal skills

  • Communication skills
  • Working alone as well as in a team
  • Facilitating (assist) groups
  • Managing expectations

31 of 232

Block -1

Unit -3

Process of System Development

32 of 232

MCS-014

�System Analysis and Design�

33 of 232

Topics to be cover

  • Phases of SDLC

34 of 232

Phases of SDLC

  • Project identification and selection
  • Project initiation and planning
  • Analysis
  • Logical (theoretically )design (concentrates on business aspects of the system)
  • Physical design (Language / DBMS /file structure / technology / tools to be used)
  • Testing
  • Implementation
  • Maintenance

35 of 232

System Development Life cycle

Most organizations find it beneficial to use a set of steps, called a systems development methodology, to develop and support their information system.

The SDLC is a common methodology for system development in many organizations, featuring various phases that mark the progress of the system analysis and design effort.

36 of 232

�Phases of Life Cycle

  1. Project identification and selection
  2. Project initiation and Planning
  3. Analysis
  4. Logical Design
  5. Physical Design
  6. Implementation
  7. Testing

37 of 232

Block -1

Unit -4

Introduction to Documentation of System

38 of 232

MCS-014

�System Analysis and Design�

39 of 232

Topics to be covered

  • Why documentation is required
  • Types of documentation
  • Database design
  • Types of Database
  • System requirement specification and Analysis
  • Data flow Diagram
  • Data Dictionary
  • Decision Table
  • Decision Tree

40 of 232

Why documentation is required�

Documentation may be defined as the process of communication about the system.

The person who is responsible for the communication using documents is known as documenter.(Documentation involves recording of information generated during the process of software development life cycle.)

Documentation is required:

It is a process to help users of software and other people to use and interact with system. Effective and accurate documentation is very necessary for the success of any system.

41 of 232

�Types of Documentation

  1. SYSTEM REQRM. SPECIFICATION
  2. SYSTEM DESIGN SPECIFICATION
  3. TEST DESIGN DOCUMENT
  4. USER MANUAL

42 of 232

Software requirements specification

SYSTEM REQRM. SPECIFICATION

SRS- It is a description of a software system to be developed, laying out functional and non-functional requirements, and may include a set of use cases that describe interactions the users will have with the software.

Software requirements specification establishes the basis for an agreement between customers and contractors or suppliers.

43 of 232

System Design Specification

SYSTEM DESIGN SPECIFICATION

SDS- It defines how the requirements of the system are to be implemented. It consists of final steps of describing the system in detail before the coding starts.

It is a complete document that contains all of the information needed to develop the system.

44 of 232

Test Design Document

TEST DESIGN DOCUMENT

  • Test design is to ensure that all requirements are met through a series of test procedures, increasing the probability of the software being capable of what is needed and wanted by the client.
  • Test design should start the moment the system requirements have been approved and baselined.
  • The test design changes/adapts during the system development lifecycle’s iterations

45 of 232

User Manual

USER MANUAL

user guide or user's guide, also commonly known as a manual, is a technical communication document intended to give assistance to people using a particular system.

This document is complete at the end of the software development process.

46 of 232

Data Dictionary

A data dictionary consists of data about data. The major elements of data dictionary are data flows, data stores and processes.

It doesn’t consist of actual data in the database. Data dictionary is kept hidden from users so that data in it is not tampered.

A data dictionary may consist of description of data elements and definitions of tables.

47 of 232

Data Dictionary

A data Dictionary is a catalogue of all elements in a system. Data dictionary stores details and description of all data used in system .

48 of 232

Block -1

Unit -4

Introduction to Documentation of system

Part-2

49 of 232

Topics to be cover

  • Documentation
  • Types of Documentation
  • Quality Assurance in Software Life Cycle
  • Levels of Quality Assurance

50 of 232

Documentation

A System cannot be completed effective unless it is adequately documented. Preparation of documentation is quite important as it depicts what the system is supposed be and how it should perform its functions.Documentation improves overall operation in addition to management and audit control.

Characteristics:

Objectivity:-It Must be clearly defined in a language that is easily understood..

Cross-referable:- It should be possible to refer to other documents.

Easy to maintain

Completeness:- It should contain everything needed.

51 of 232

Types of Documentation

Program Documentation:-

Before a program is developed, the system analyst should provide the programmer with the required documentation.Flowchart, Decision Tables are most appropriate for explaining the logic of a program.

Operations Documentation:-

For smooth running of the system, the console operator must have complete knowledge about the job.The instructions must be in a form which is easily readable and understandable.

52 of 232

User Documentation:-

System requires two general types of information:

1. Complete details to handle each case the system process.

2. Overall picture of the system so that they can see their role in the total operation of the company.

Types of Documentation

53 of 232

Management Documentation:-

The documentation required by corporate management.The System designer must know the requirements of the management and provide the documentation to enable management to perform functions:-

Evaluate progress on system development

Monitor existing systems.

Understand the objectives and method of new and existing systems.

Types of Documentation

54 of 232

System Documentation:-

The documentation of this plan must be thorough enough so that system designers could produce a complete and effective system.

Types of Documentation

55 of 232

Quality Assurance in Software Life Cycle

Quality Factors Specifications

  • Correctness:-The extent to which a program meets system specifications and user objective.
  • Accuracy:-The required precision in input, editing, computations and output.
  • Reliability:-The degree to which the system performs its intended functions over a time
  • Expandability:- Ease of expanding the existing database.
  • Efficient:- Computer resources required by a program to perform a particular function

56 of 232

Usability:- The efforts required to understand and operate a system.

Maintainability:- The ease with which the program errors are detected and removed.

Testability:- The effort required to test a program to ensure its correct performance.

Portability:- The ease of transporting a program from one hardware configuration to another.

Quality Assurance in Software Life Cycle

57 of 232

Software Requirement Specification:- This stage is to generate the requirement document for developing the software.

Software Design Specification:-The Software design document defines the overall architecture of the software

Quality Assurance in Software Life Cycle

58 of 232

Software Testing and Implementation:-The testing Phase is to ensure that completeness and accuracy of the system. Implementation phase provide a logical order for the creation of the modules.

Maintenance and Support:-This Phase provides the necessary software development for the system.

Quality Assurance in Software Life Cycle

59 of 232

Levels of Quality Assurance

Testing:-

System testing is expensive and time consuming process. Testing held by users is that it is performed to prove that program is error free.

Verification with Validation:-

Verification is also intended to find errors. It is performed by executing a program in a simulated environment. Validation refers to the process of using software in a live environment to find errors.

60 of 232

Certification:-

The last level of Quality assurance is to certify that the software package developed conforms to standard.Certification is issued only if the package is successful in all the tests.

Levels of Quality Assurance

61 of 232

BLOCK – 2��PLANNING AND DESIGNING�SYSTEMS

62 of 232

Block -2

Unit -5

Process of System Planning

63 of 232

MCS-014

�System Analysis and Design�

64 of 232

Topics to be covered

  • Fact finding techniques
  • Feasibility studies
  • Cost benefit analysis

65 of 232

Fact finding Techniques

To learn the functions of the existing system, systems analyst needs to collect data related to the existing system. Usually, the data related to organization, staff, documents used, formats used in the input and output processes is collected.

  1. INTERVIEWS
  2. GROUP DISCUSSIONS
  3. SITE VISITS
  4. PRESENTATIONS
  5. QUESTIONNAIRES

66 of 232

Interviews

Personal Interview is a recognized and most important fact Finding technique, where the system analyst gathers information from individual through face to face interaction.

67 of 232

Group Discussion

A group of staff members are invited who are expected to be well versed in their own wings of the organization.

68 of 232

Site Visits

The engineers of the development organization visit the sites. Usually, the systems analysts visit sites to get first hand information of the working of the system.

69 of 232

Presentation

It is another way of finding the facts and collecting data. Presentation is the way by which the system analyst find hand knowledge of the project.

70 of 232

Questionnaires

These are special purpose documents that allow the analyst to collect information and opinion from

Respondents.

It is possible to collect responses or opinion from a large number of people.

71 of 232

�Feasibility Study

Feasibility(Possibility) study consists of activities which determine the existence of scope of developing an information system to the organization. This study should be done throughout the life cycle.

In feasibility analysis, we have to study the fol. :

  1. Technical feasibility
  2. Operational feasibility
  3. Economic feasibility
  4. Legal feasibility

72 of 232

Technical Feasibility

Technical feasibility is concerned with the availability of hardware and software required for the development of the system, to see compatibility and maturity of the technology.

73 of 232

Operational Feasibility

Operational feasibility is all about problem that may arise during operations.

74 of 232

Economic Feasibility

It is the measure of cost effectiveness of the project. The Economic feasibility is nothing but judging whether the possible benefit of solving the problems is worthwhile or not.

75 of 232

Legal Feasibility

Legal feasibility studies issues arising out of the need to the development of the system. The Possible consideration might include copyright law, labour law, antitrust, foreign trade, regulation etc.

76 of 232

Block -2

Unit – 6

Modular and Structured Design

77 of 232

MCS-014

�System Analysis and Design�

78 of 232

Topics to be covered

  • System Design
  • Design principles (Top down and bottom up )
  • Structure chart
  • Modularity
  • Modules in Modularity

79 of 232

�System Design

It is the specification or construction of a technical, computer based solution for the business requirements identified in system analysis phase.

During design, system analysts convert the description of the recommended alternative solution into logical and then physical system specifications.

80 of 232

�Design Principles

There are certain principles that can be used for the development of the system. The principles are :

  1. Problem Partitioning
  2. Abstraction
  3. TOP DOWN Design
  4. BOTTOM UP Design

81 of 232

Problem Partitioning

It is concerned with partitioning the large problems. Divide and Conquer is the best policy adopted here.

82 of 232

Abstraction

Abstraction is a technique for managing complexity of computer systems.

It is a tool that permits the designer to consider a component at an abstract level(outer view) without worrying about details of implementation of the component.

It is necessary when the problem is divided into smaller parts so that one can proceed with one design process effectively and efficiently.

83 of 232

Top Down Design

This method often result in some form of stepwise refinement, starting from an abstract design, in each step, the design is refined to a more concrete level until we reach a level where no more refinement is required and the design can be implemented directly.

84 of 232

Bottom Up Design

In this strategy, we start from the bottom and move upwards towards the top of the software.

85 of 232

Structure Charts

A structure chart depicts the modular organization of an information system. The organization is hierarchical.

A structure chart graphically shows the way the components of a program or a system are related.

The structure chart depicts various modules across different levels of the hierarchical organization. Always it has one coordinating module at the top.

A system consists of components called modules.

86 of 232

Structure Charts

Structure Chart

The organization of modules within a system is usually shown on a module / structure chart.

87 of 232

Structure Charts

88 of 232

�Modularity

Modularity is a single attribute of software that allows a program to be intellectually manageable. It increases the design clarity that results in easy implementation, testing, debugging, documentation and maintenance of the software.

MODULARITY means decomposing a system into smaller components that can be coded separately.

89 of 232

Modules in Modularity

  1. Goals of Design:-The system which can be read easily, code easily and maintain easily, then we can come to a conclusion that the design is fine.

(2) Coupling:-Coupling is a measure of the relationship (i.e., dependency) between two modules.

(1) Data Coupling

(2) Stamp Coupling

(3) Control Coupling

(4) Common Coupling

(5) Content Coupling

(3) Cohesion:-It is a degree to which a module conforms (adjust) itself to the performance of a single task.

(1) Procedural Cohesion

(2) Temporal Cohesion

(3) Logical Cohesion

(4) Coincidental Cohesion

90 of 232

Data Coupling

Data Coupling:-Data coupling occurs between two modules when data are passed by parameters using a simple argument list and every item in the list is used.

91 of 232

Stamp Coupling

Two modules are stamp coupled if they communicate via a passed data structure that contains more information than necessary for them to perform their functions.

92 of 232

Control Coupling

Control coupling is one module controlling the flow of another, by passing it information on what to do (e.g., passing a what-to-do flag).

93 of 232

Common Coupling

Common coupling (also known as Global coupling) occurs when two modules share the same global data (e.g., a global variable). Changing the shared resource implies changing all the modules using it.

94 of 232

Content Coupling

Content coupling (also known as Pathological coupling) occurs when one module modifies or relies on the internal workings of another module (e.g., accessing local data of another module).

Therefore changing the way the second module produces data (location, type, timing) will lead to changing the dependent module.

95 of 232

Content Coupling

A Content Coupling with D

96 of 232

Cohesion

It is a degree to which a module conforms (adjust) itself to the performance of a single task.

Procedural Cohesion:- : A procedurally cohesive module contains elements that belong to a common procedural limit.

97 of 232

Temporal and Coincidental Cohesion

Temporal Cohesion:- operations related only by general time performed (i.e. initialization() or FatalErrorShutdown?()).

Coincidental Cohesion:- (Worst) Module elements are unrelated. There is no relationship between the instruction.

98 of 232

Cohesion

Logical Cohesion:- Elements perform similar activities as selected from outside module.

99 of 232

Block -2

Unit - 7

System Design and Modeling

100 of 232

MCS-014

�System Analysis and Design�

101 of 232

Topics to be covered

  • Logical and physical design
  • Form design (Text box / Radio button/ Listbox / Combobox / Checkbox )
  • Process specification tools (Policy, decision table / Tree / Structure English)

102 of 232

System Design

There are two level of process of design:

  • Logical design :The process of logical design involves arranging data into a series of logical relationships called entities and attributes.
    • Describe the structure and characteristics of features likes output ,inputs ,databases and procedures(plan, strategy).
    • Produce a specification of the major feature of the new system which meet the system objective.
    • It is a blue print(design, diagram) of the new system.

103 of 232

System Design

It include the following components:

  • Output (report, display)
  • Input (forms, screen, dialogues)
  • Procedures (structure of procedures (plan) to collect, transform and output data)
  • Storage (requirements for data to be stored in the database)
  • Control(requirement for data integrity, security, and procedures for recovery.

(Integrity involves maintaining the consistency(stable), accuracy, and trustworthiness of data over its entire life cycle.)

104 of 232

System Design

  • Physical Design: Moving from Logical to Physical Design.
    • Produce the program specification physical file or database and user interface for a selected target hardware and software .
    • These programs and files will fulfill the logical design requirement but may be subject to some constraint and compromiser.

105 of 232

System Design

  • Design objective
    • Practicality:- Concerned with the actual doing or use of something rather than with theory and ideas.
    • Efficiency:-The state or quality of being efficient(well organization).
    • Cost: The amount of money paid to buy something, or spent in producing something.
    • Flexibility:The ability of software to change easily in  response to different user and system requirements.
    • Security:-The protection of data, networks and computing power.

106 of 232

  • Constraints
  • Hardware: Computer hardware is the collection of physical parts of a computer system.
  • Software:-Software is a generic term for organized collections of computer data and instructions.
  • Budget: A budget is a quantitative expression of a plan for a defined period of time or (a ​plan to show how much ​money a ​person or ​organization will ​earn and how much they will need or be ​able to ​spend).
  • Time-scale: An arrangement of events used as a measure of duration.
  • Interface with other systems (provide a link between two objects, system etc.)

System Design

107 of 232

Structured Design

  • Structured design is a systematic approach of problem solving. It is based on data and logic.
  • It is essentially a top-down consisting of hierarchy of modules having single entry and single exit subroutine.
  • A logical system design is primarily concerned with file and database together with specific interface task such as form and screen design

108 of 232

Structured design is based on data flow. Structured design partitions a program into small, independent modules. They are organized in a top-down manner. Structured design is used to minimize the complexity.

Structured Design

109 of 232

Data Flow Diagram is graphic tool. It is used to describe and analyze the movement of data through a system. They focus on the data flowing into the system, between processes and in and out of data stores.

Notation ‘s of a DFD

DATA FLOW (arrow).

PROCESS (circle).

EXTERNAL ENTITIES (Square box).

DATA STORE (Open box ).

Data Flow Diagram

110 of 232

DFDs only involve four symbols

Process�Transform of incoming data flow(s) to outgoing flow(s)

Data Flow�Movement of data in the system.

Data Store�Data repositories for data that are not moving. It may be as simple as a buffer or a queue or a s sophisticated as a relational database.

External Entity�Sources of destinations outside the specified system boundary.

111 of 232

Context Diagram

Context DFD is the entrance of a data flow model. It contains one and only one process and does not show any data store.

112 of 232

First Level DFD

A Data Flow diagram that represents a system’s major processes, data flows, and data stores at a high level of detail.

113 of 232

Context Level DFD

114 of 232

Ist Level DFD

115 of 232

116 of 232

117 of 232

118 of 232

Functional Decomposition Diagram

Basically, functional decomposition takes something complicated and simplifies it.

The individual elements of the process and their hierarchical relationship to each other are commonly displayed in a diagram called a functional decomposition diagram.

119 of 232

ER Diagram

ER diagram is used to described the data in terms of entities and their relationship.

Components of ER diagram are:-

  • Entity
  • Attribute
  • Relationship
  • Cardinality
  • Degree
  • Recursive Relationship

ip

120 of 232

ER Diagram

Entity-A person, partnership, organization, or business that has a legal and separately identifiable existence.

Student is the name of entity.�

121 of 232

ER Diagram

Attribute- An attribute is a quality or characteristic given to a person, group, or some other thing.

An attribute “Address” is the example.

122 of 232

ER Diagram

Relationship:- A relationship is a natural business association that exists between one or more entities.

The student links with the other entities or attributes.

123 of 232

ER Diagram

Cardinality:-It defines the min and max number of occurrences of one entity that may be related to a single occurrence of the other entity.

124 of 232

ER Diagram

Degree:- The degree of relationship is the number of entities that participate in the relationship.

125 of 232

ER Diagram

Recursive Relationship:- A relationship that exists between different instances (case) of the same entity is called Recursive Relationship.

126 of 232

127 of 232

Data Dictionary

A data dictionary is a collection of descriptions of the data objects or items in a data model for the benefit of programmers and others who need to refer to them.

128 of 232

Form Design

  • Form design plays as important role in data processing. People read from forms, write on forms, and spend many hours in handling forms and filling forms.
  • A Form in computer terminology identifies the data we want to collect. It also allows us to enter data into the database, display it for review and also print it for distribution.

129 of 232

Form Design

130 of 232

Importance of Forms

  1. A form provides an easy way to view data.
  2. Using form, data can be entered easily. This saves time.
  3. Forms present data in an attractive format with special fonts and other graphical effects such as colour and shading.
  4. Forms offer the most convenient layout for entering, changing and viewing records present in the database.

Form Design

131 of 232

Classification of forms

  • Action: Request the user to do something:
    • Order ,instruction, authorizes ( like-application form).
    • Achieves result (purchase order).
    • Goes from one place to another (sales slip).
  • Memory: It is records of historical data
    • Represents historical data (bond register).
    • Stationary and remain in one place ,usually in a file(journal entry).
    • Data generally used for reference(inventory record).
  • Report: Guides supervisors in their activity
    • Summary picture of a project (balance sheet).
    • Used as a basis for decision making(sales analysis).

Form Design

132 of 232

Requirement of form design

  • Identification and wording.
  • Size and shape arrangement.
  • Order of data item.
  • Use of data item.
  • Use of instruction.
  • Ease of data entry.
  • Type of report.

Form Design

133 of 232

Criteria for Form Design

  1. Organization
  2. Consistency (stable)
  3. Completeness
  4. Flexible entry
  5. Economy

Form Design

134 of 232

Decision Tables

A decision tables is a table of rows and columns,that show conditions and actions. Decision Rules included a decision table, state what procedure to follow when certain conditions exists.

The decision table has four section.

  • Condition stub
  • Condition entries.
  • Action stub
  • Action entries.

135 of 232

Decision Tables

A decision table is an excellent tool to use in both testing and requirements management.

136 of 232

Are presentation of decision variables that are graphics and sequential ,showing which condition to consider first ,which second and so, on.

A decision tree is diagram that presents conditions and actions in order.The root is on the left.

decision tree is a decision support tool that uses a tree-like graph or model of decisions and their possible consequences, including chance event outcomes, resource costs, and utility. It is one way to display an algorithm.

Decision Trees:

137 of 232

Decision Trees:�

decision tree is a graph that uses a branching method to illustrate every possible outcome of a decision

138 of 232

BLOCK – 3��MORE DESIGN ISSUES�AND CASE TOOLS

139 of 232

Block -2

Unit - 8

Session – 9

140 of 232

MCS-014

�System Analysis and Design�

141 of 232

Topics to be cover

  • Importance of Forms
  • Importance of Reports
  • Types of information (Internal / External / Turnaround)

142 of 232

Importance of Forms

FORMS and REPORTS deals with the interface of the software with users.

IMPORTANCE OF FORMS :

  1. A form provides an easy way to view data.
  2. Using forms data can be entered easily.
  3. Forms present data in an attractive format.
  4. Forms offer the most convenient layout for entering, changing and viewing records present in the database.

143 of 232

Seminar Form

144 of 232

Forms

145 of 232

Importance of Reports

  1. We can organize and present data in groups.
  2. We can calculate running totals, group totals, grand totals, percentage of totals.
  3. Within the body of reports, we can include sub-forms, sub-reports and graphs.
  4. We can present data in an attractive format with pictures, special fonts and lines.
  5. We can create a design for a report and save it so that we can use it over and over again.

146 of 232

Reports

147 of 232

Reports

148 of 232

Reports

149 of 232

�Types of Information

  1. INTERNAL INFORMATION

  • EXTERNAL INFORMATION

  • TURNAROUND INFORMATION

150 of 232

INTERNAL INFORMATION�

Internal Information is the Information that is collected, generated or consumed within an Organization.

151 of 232

EXTERNAL INFORMATION

External Information refers to the information collected from or created for customers, suppliers, competitors etc. Outside the Organization.

152 of 232

TURNAROUND INFORMATION

When there are several instances (examples) where the information output is again used as input to obtain new information. The document that consists of such information is called Turnaround document.

For example Warranty Card in which customers also adds new information (Ex.: Name, Address, etc.)

153 of 232

Block -2

Unit - 9

Session - 10

154 of 232

MCS-014

�System Analysis and Design�

155 of 232

Topics to be covered

  • Inputs to physical design
  • File Organization

156 of 232

Database Design

database is a collection of information that is organized so that it can easily be accessed, managed, and updated.

Database design is the process of producing a detailed data model of a database

157 of 232

Database Design

Flat File:- In databases a flat file refers to data files that contain records with no structured relationships. Flat files may contain only basic formatting, have a small fixed number of fields, and it may or may not have a file format or a file having no internal hierarchy.

Example:- A flat file which stores pin code of customer’s address. Any change in the size of the field will enforce changes in the entire program which uses the data related to customer’s address.

158 of 232

Steps in Database Design

Analysis- It is the process of creating a conceptual data model for the database system.

Design- It is the process of creating a logical data model for the database system.

Implementation- It is the process of creating a physical model for the database system

159 of 232

Design of Database Fields

Various types of fields in database are:-

Primary Key- Contain one or more columns whose combined values uniquely identify every row in a table. Each table can have only one primary key.

Secondary Key or Alternate Key-  Contain one or more columns whose combined values uniquely identify every row in a table.

Foreign keys - Contain one or more columns whose values match a primary or alternate key in some other table.

Descriptive fields-Attributes that are not used as key but store business data.

160 of 232

Design of Database Fields

Example of Keys:

STUDENT {SID, FNAME, LNAME, COURSEID}

Here in STUDENT table keys are:

Candidate keys are: SID or FNAME+LAME

Primary Key: SID

Foreign Key: COURSEID

Alternate Key:  FNAME+LAME

161 of 232

Types of Physical Files

Once the logical design has been finalized in consultation with the users, the details of physical design of the system can start. Physical database design involves actual implementation of the logical database in the DBMS.

TYPES OF PHYSICAL FILES :

  1. Master File
  2. Transaction File
  3. Archive File
  4. Audit File
  5. Work File

162 of 232

Types of Physical Files

163 of 232

Master File�

A Master File is a permanent file of all the data needed by a business.

Example, a file consisting of information about the customers.

164 of 232

Transaction File�

A Transaction file is a temporary file of all the transactions (items bought, sold, deleted etc.) that have taken place in a given period.

Example, data related to daily sales activity.

The data of these files is used to update the Master File.

165 of 232

Archive File�

An Archive File is a file of data in permanent storage (usually, the data is stored for legal reason or to perform the analysis.)

These files contains Information about Past dealings of the business and other activity.

166 of 232

Audit File

An Audit File that does not store business data but data related to transaction log.

Example, data and time of access, modification etc. Values of fields before and after modification.

Audit (inspection or investigation)- A systematic review or assessment of something.

167 of 232

Work File

A Work File is temporarily created to hold intermediate (middle) result of the data processing.

Example, a stored file of list of customers.

168 of 232

��File Organization��

File Organization is the physical organization of records on the disc.

  1. Serial File organization
  2. Sequential File organization
  3. Indexed Sequential File organization
  4. Hashed File organization

169 of 232

Serial File organization

A serial File is created by placing the record as it is created. It leaves no gap between the records that are stored on the disc.

Examples:- print file, log files, transaction files etc.

170 of 232

Sequential File organization

In this organization, the records are physically ordered by primary key. To locate a particular record, the program starts searching from the beginning of the file till the matching primary key is found.

Alphabetic list of customers is a common

Example of Sequential File organization.

171 of 232

Indexed Sequential File organization

Indexing is a way of sorting a number of records on multiple fields. 

In this organization, the records are not physically ordered. Index is created to facilitate searching of records. Index Records give a physical location of each data record.

172 of 232

Hashed File organization

A hash function, h, is a mapping function that maps all the set of search-keys K to the address where actual records are placed. 

In this organization, the records are physically ordered according to hashing(mixture) algorithm. The address where each record is stored is determined using hashing algorithm.

173 of 232

Design Of Database

The following are various steps in Database design:-

  • Selection of Database architecture
  • Designing database schema
  • Selecting Indexes
  • Estimating capacity of the database.

174 of 232

Design Of Database

Selection of Database architecture-Selecting database architecture is one of the most challenging parts of database design for any information system.

Designing database schema-A database schema defines a database in terms of tables, keys, indexes and constraints.

Selecting Indexes-When an index is created on a table, a separate storage area is allocated to store the index structure. A database table can have one or more indexes associated with it.

175 of 232

Design Of Database

Estimating capacity of the database- Database administrator needs to calculate the amount of disk space required for the database.

176 of 232

DBMS

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.

A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

177 of 232

DBMS

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:

  • CREATE - to create objects in the database
  • ALTER - alters the structure of the database
  • DROP - delete objects from the database
  • TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed

178 of 232

DBMS

Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

  • SELECT - retrieve data from the a database
  • INSERT - insert data into a table
  • UPDATE - updates existing data within a table
  • DELETE - deletes all records from a table, the space for the records remain

179 of 232

BLOCK – 3�CASE TOOLS FOR �SYSTEM DEVELOPMENT

180 of 232

Block -3

Unit - 10

Session - 11

181 of 232

MCS-014

�System Analysis and Design�

182 of 232

Topics to be cover

  • CASE Tools
  • Use of CASE Tools.
  • Types of CASE Tools
  • Classification of CASE Tools
  • Reverse & Forward Engineering

183 of 232

CASE Tools

The normal SDLC process is often seen as inflexible(non adjustable) and time consuming and expensive. Keeping in view of these limitations CASE came into existence.

CASE : Computer Aided Software Engineering

This uses various CASE tools to perform and automate many activities of SDLC.

It means, development and maintenance of software projects with help of various automated software tools.

184 of 232

�CASE Tools

All the software that helps in the process of software engineering can be termed as CASE tools.

Use of CASE Tools :

  • To facilitate single design methodology
  • Rapid Application Development
  • Testing
  • Productivity and Reduction of Cost.

185 of 232

CASE Tools

To facilitate(making easier) single design methodology-CASE tools help organization to standardize the development process. It also facilitates coordinated development.

Rapid Application Development-Organizations use CASE tools to improve the speed and quality of system development.

Testing-CASE tools help to ease and improve testing process through automated checking and simplify program maintenance.

Productivity and Reduction of Cost-Use of CASE tools makes the software easy to maintain and hence reduce the maintenance costs.

186 of 232

Types of CASE Tools

  • Planning and management tool
  • Analysis tool
  • Design toolset
  • Code generator
  • User interface generator
  • Database design toolset.
  • Report generator

187 of 232

Types of CASE Tools

Planning and management tool-Begin the development process with information planning and project management.

Analysis tool-These tools ensure that business requirements are correctly captured during the analysis phase early in the development process.

Design toolset-It provides detailed specification of the system.

Code generator-It automatically generates code specific to a language based on the system specification.

188 of 232

Types of CASE Tools

Database design toolset-It suggests database design and generates system control information.

User interface generator-It generates user interface based on system specification.

Report generator-It generates reports based on specification

189 of 232

Classification of CASE Tools

Development tools : used for design support and code generation

Front end tools : support activities early in the life cycle of software development. Ex : DFD , ERD , prototyping tools

Back end tools : support activities later in the life cycle of software development process. Ex : flow chart , code generator etc.

Horizontal tools : These tools are not specific to a particular life cycle step but are common across a number of life cycle steps, eg – documentation tools

Vertical tools: These tools are specific to a life cycle.

190 of 232

�Reverse & Forward Engineering

Reverse engineering is the process of recreation of model based on the existing code. First the existing code is scanned to generate the model. Then the model can be fine tuned in accordance with requirement.

191 of 232

��Forward Engineering

It is the process of generation of skeleton code out of the models. First step is to create the model for a system, then generate the relevant code for the model and then allow modification of this code.

192 of 232

Object Oriented CASE Tools

Object oriented CASE tools are similar to other CASE tools. These differ from others only in terms of their capability to create class diagrams and text specifications for reports.

The following are some of the features found across most of the Object Oriented CASE tools:

  1. Create graphics, such as class diagrams, message diagrams, state diagrams etc.
  2. Create text specifications such as system specification, class specification and relationship specification.
  3. Generate source code.
  4. Repository(a central location in which data is stored and managed) of models.

193 of 232

BLOCK – 4��IMPLEMENTATION AND �SECURITY OF SYSTEMS�AND MIS

194 of 232

Block -4

Unit - 11

Session – 12

Session – 13

195 of 232

MCS-014

�System Analysis and Design�

196 of 232

Topics to be cover

  • Implementation of system
  • System Testing.
  • Conversion Approaches
  • Types of Maintenance
  • Audit
  • Computer system and Security issues

197 of 232

�Implementation of system�

This unit gives the overview of the actual implementation techniques when the new system is completely designed.

Where maintenance of the system after implementation is a major activity considering the total life of a software product.

198 of 232

System Testing

Conducting system tests :

  • Recovery Testing
  • Security Testing
  • Stress Testing
  • Performance Testing
  • Response Testing

199 of 232

System Testing

Recovery Testing:-Test the ability of the system to recover from errors.

Security Testing:-System used for processing sensitive information are prone (likely) to high security risks.

Stress Testing:-Stress test is designed to test the system as to how the system behaves in abnormal situation.

Performance Testing:-Performance testing is specifically important to embedded and real time systems. It checks the run time performance of the system.

Response Testing:-Testing of response time is of special importance in OLTP (on-line transaction processing systems like railway reservation system, points of sale, etc.). Testing is done to measure the response time.

200 of 232

�Conversion Approaches

The process of conversion from the existing system

(manual or computerized) to the newly developed

system can be performed in several ways depending on

the criticality of the system and other related issues.

Converting to new system :

  • Direct conversion
  • Pilot conversion
  • Parallel conversion
  • Phased conversion

201 of 232

Conversion Approaches

Direct conversion:-This is sudden approach. The old system is shutdown and the new system starts.

Pilot conversion:-This is the middle path approach. Instead of converting all at once throughout the organization, this kind of pilot installation involves conversion/installation of system at a single pre-decided location.

Parallel conversion:- is least risk prone (especially face downwards). Under this kind of conversion, the old system is allowed to run alongside the new system until the management and the end user are satisfied with the result of the new system.

Phased conversion:- is an incremental approach to switch over to the new system.

202 of 232

�Types of Maintenance

Maintenance of the system :

  • Corrective maintenance
  • Adaptive maintenance
  • Perfective maintenance
  • Preventive maintenance

203 of 232

Types of Maintenance

Corrective maintenance:- This maintenance performed to return equipment to proper working order.

Adaptive maintenance:- It includes changes to the functionality of the system developed for specific customer needs.

Perfective maintenance:-This kind of maintenance activity involves adding new functionalities and features to the software to make it more versatile and user oriented.

Preventive maintenance:-Changes are made to software to make it easily maintainable and to prevent any kind of system failure in future. This reduces the need of corrective maintenance.

204 of 232

Block -4

Unit - 12

Session - 13

205 of 232

�Audit�

This is an assessment of an information system performed by an information systems professional of IS auditor to provide recommendations and advice to improve system performance and security.

Audit should be done regularly and the result should be used to refine the system.

An Audit is official inspection of an organization's (Company) accounts, typically by an independent body.

206 of 232

�Audit�

OBJECTIVE OF AUDIT :

  1. To improve the quality of information system prevent failure and minimize the effects of failure, and speed up the process of recovery in the event of a failure. This will help information system to be more reliable.
  2. To make an information system more secure from natural as well as manmade disasters, unauthorized access, and other destructive actions.
  3. To improve the cost performance of an information system by optimum utilization of resources, which leads to increase in efficiency.

207 of 232

�Audit�

Benefits of audit :

  1. Improve system and process controls.
  2. Prevent and detect errors as well as fraud.
  3. Reduce risk and enhance system security.
  4. Plan for possibilities and disaster recovery.
  5. Manage information and developing systems.
  6. Prepare for the independent audit.
  7. Evaluating the effectiveness and efficiency related to the use of resources.
  8. Improve business efficiency.

208 of 232

Computer System & Security Issues

Security is an important issue for modern IT systems. Even though technology provides immense possibilities to safeguard organizations computing infrastructure, there has been security lapses and security breaches which have cost the organization heavily.

209 of 232

Computer System & Security Issues

210 of 232

Block -4

Unit - 13

211 of 232

MCS-014

�System Analysis and Design�

212 of 232

Topics to be cover

  • MIS
  • Computer system and MIS
  • 7-M of Management
  • Examples of Mgmt. system
  • Types of Information System
  • Types of computer supported in MIS
  • Emerging technologies used in MIS
  • Decision mgmt. with IS
  • DSS
  • Components of MIS
  • Expert system

213 of 232

Management Information System

The Three sub- components:-

Management, Information and System

Management:- focusing on the ultimate use of such information system for managerial decision making technology.

Information:- Means Processing data that have some meaning. Which it is used by end users.

System:-A system is defined as a set of related components, activities, processes and human being interacting together to achieve some common objective.

214 of 232

Management Information System

MIS helps the organization to produce information that organizations need to improve decision making, problem solving, control operations and creating new products or services.

Roles of MIS :

  1. Support day to day business operations.
  2. Support managerial decision making.
  3. Supports strategic decision making and competitive advantage.
  4. Optimizing operational cost.
  5. Provide timely and accurate information.

215 of 232

What is MIS?

Management Information system (MIS) generate information for Monitoring Performance (e.g Productivity information) and maintaining coordination (e.g between purchasing and accounts payable)

  • MIS extract process and summarise data from the TPS and provide periodic (weekly / monthly / quaterly ) reports to managers.
  • MIS = study of Information systems in business

and Mgmt.

216 of 232

Management Information System

  • MIS summarize and report on the company’s basic operations.
  • The basic transaction data from TPS are compressed and are usually presented in long reports that are produced on a regular schedule.
  • MIS serve the management level of the organization ,providing managers with reports and in some cases ,with on-line access to the organization current performance and historical records
  • MIS serve the functions of planning / controlling and decision making at mgmt. Level.

217 of 232

  • The widespread availability of computer explains to a large extent the extensive use of computers to implement any meaning MIS today.
  • However, computer systems provide only the technology component and successful MIS calls for understanding of the organizational systems and procedures.

Computer Systems and MIS

218 of 232

7- M’s of Management

  1. Man - HR Mgmt
  2. Machine – Production & R / D
  3. Material – Inventory / stock mgmt
  4. Money – Finance Dept.
  5. Marketing – strategies applied
  6. Method – Alternative Procedures Applied
  7. Maintenance- Preventive and Planned

219 of 232

What is management system?

  • Management system are the formal , observable ways in which an organization administers its operation.

A mgmt. System provides the framework of processes and procedures used to ensure that an organization can fulfill all tasks required to achieve its objectives

“PLAN--->DO-🡪CHECK-🡪ACT”

Information system provides assistance to the manager for efficiently discharging his responsibilities.

220 of 232

Continue…

  • A manager has to carry out the role of a functional expert, carry out decisions, plan and co-ordinate for which he / she has to perform the role of communicator and control all the activities under his / her responsibility.

  • Efficient and effective operation of a business requires a management system, which can support business processes and operation, decision – making and competitive strategies.

221 of 232

Examples of Mgmt. System

Some of the mgmt. System that have been computerized in various organization are :

1. Administrative mgmt. system

2. Human resource mgmt. System

3. A/c mgmt. System

4. Customer relationship mgmt. System

5. Knowledge mgmt. System

6. Logistics mgmt. System

7. Marketing mgmt. System

8. Operations mgmt. System

9. Project mgmt. System

10. Process mgmt. system

222 of 232

Continue…

11. Personal mgmt. System

12. Product mgmt. System

13. Quality mgmt. System

14. Resource mgmt. System

15. Risk mgmt. System

16. Supply chain mgmt. system

17. Time mgmt. system

223 of 232

�Types of Information Systems

  1. Transaction Processing System

  • Management Information System

  • Decision Support System

  • Expert System

224 of 232

Types of Information Systems

Transaction Processing System:-It is an information system that supports business in the delivery of various business transactions.

Management Information System:- Management Information System (MIS) is a special kind of information system that helps managers to take decisions.

Decision Support System:-Decision Support Systems provide information to managers which will be helpful for them to make decisions. A manager at a higher level needs information for strategic planning and control.

Expert System:- An Expert System is a computer program that simulates the judgment and behavior of a human expert or an organization that has expert knowledge and experience in a particular field. Typically, such a system contains a knowledge base containing accumulated experience and a set of rules for applying the knowledge base to each particular situation that is described to the program.

225 of 232

Types of Computers supported in MIS�

1.   Network servers

2.   Mainframe computers

3.   Minicomputers

4.   super computer

 

226 of 232

Continue…

Data processing means checking the character, structure, presentation, data design, data value checking, range/ limits checking, error correction or in other words data processing is handling raw material in a systematic manner to confirm to the data quality standards as determined by the designer of the information system.

 

227 of 232

Continue…

  • Transaction processing: A transaction is processed with reference to business rules, i.e. a transaction is scrutinized for conformance to the rules, policy or guidelines before it is taken up for further processing

228 of 232

Information system processing involves following functions

1.   Nature of business (Trading or

Manufacturing)

2.   The type of business (Product or Service)

3.   The complexity of business (Multiple

locations , divisions, products)

4.   Management style (autocratic,

participative)

229 of 232

Emerging Technologies used in MIS

  1. Internet / Intranet
  2. EDI (Electronic Data Interchange)
  3. E-Mail
  4. Groupware
  5. Client server for application processing
  6. Multimedia for voice, video, image
  7. Processing, imaging system for image creation
  8. KBS (Knowledge base system) for expert,
  9. AI system and CASE for a systematic application development

230 of 232

Decision mgmt. with IS

  • Decision –making is the process of selecting a course of actions among multiple alternatives.
  • Exam : shopping, medical decision making (based on diagnosis) deciding what to eat and deciding whom or what to vote for in an election.
  • Decision making is said to be a psychological construct that is we can never “see” a decision, we can get from observable behavior that a decision has been made.
  • Experts use intuitive decision making rather than structured approaches.
  • Politics is one approach to making decisions in groups

231 of 232

Decision making based on� 4-Dimensions

  1. Thinking and feeling
  2. Extroversion and introversion
  3. Judgment and perception
  4. Sensing and intuition

These dimensions would tend to have a logical, analytical , objective, critical and empirical decision making style.

232 of 232

Types of Decision in the organization

 

1.   The decisions affecting the operations

mgmt.

2.   The decisions affecting the execution and

control of the business

3.   The strategic business decisions