Posted by Suresh Khanal | Posted on 3:01 PM
Systems are created to solve problems. One can think of the systems approach as an organized way of dealing with a problem. In this dynamic world, The subject System Analysis and Design, mainly deals with the software development activities. After going through this lesson, you should be able to: A collection of components that work together to realize some objective forms a system. Basically there are three major components in every system, namely input, processing and output. In a system the different components are connected with each other and they are interdependent. For example, Human body represents a complete natural system. We are also bound by many national systems such as political system, economic system, educational system and so forth. The objective of the system demand that some output is produced as a result of processing the suitable inputs. System life cycle is an organisational process of developing and maintaining systems. It helps in establishing a system project plan, because it gives overall list of processes and sub-processes required developing a system. System development life cycle means combination of various activities. In other words we can say that various activities put together are referred as system development life cycle. In the System Analysis and Design terminology, the system development life cycle means software development life cycle. Following are the different phases of software development cycle: Let us now describe the different phases and the related activities of system development life cycle in detail. System study is the first stage of system development life cycle. This gives a clear picture of what actually the physical system is? In practice, the system study is done in two phases. In the first phase, the preliminary survey of the system is done which helps in identifying the scope of the system. The second phase of the system study is more detailed and in-depth study in which the identification of user's requirement and the limitations and problems of the present system are studied. After completing the system study, a system proposal is prepared by the System Analyst (who studies the system) and placed before the user. The proposed system contains the findings of the present system and recommendations to overcome the limitations and problems of the present system in the light of the user's requirements. To describe the system study phase more analytically, we would say that system study phase passes through the following steps: On the basis of result of the initial study, feasibility study takes place. The feasibility study is basically the test of the proposed system in the light of its workability, meeting user's requirements, effective use of resources and .of course, the cost effectiveness. The main goal of feasibility study is not to solve the problem but to achieve the scope. In the process of feasibility study, the cost and benefits are estimated with greater accuracy. Assuming that a new system is to be developed, the next phase is system analysis. Analysis involved a detailed study of the current system, leading to specifications of a new system. Analysis is a detailed study of various operations performed by a system and their relationships within and outside the system. During analysis, data are collected on the available files, decision points and transactions handled by the present system. Interviews, on-site observation and questionnaire are the tools used for system analysis. Using the following steps it becomes easy to draw the exact boundary of the new system under consideration: All procedures, requirements must be analysed and documented in the form of detailed data flow diagrams (DFDs), data dictionary, logical data structures and miniature specifications. System Analysis also includes sub-dividing of complex process involving the entire system, identification of data store and manual processes. The main points to be discussed in system analysis are: Based on the user requirements and the detailed analysis of a new system, the new system must be designed. This is the phase of system designing. It is a most crucial phase in the development of a system. Normally, the design proceeds in two stages : Preliminary or general design: In the preliminary or general design, the features of the new system are specified. The costs of implementing these features and the benefits to be derived are estimated. If the project is still considered to be feasible, we move to the detailed design stage. Structure or Detailed design: In the detailed design stage, computer oriented work begins in earnest. At this stage, the design of the system becomes more structured. Structure design is a blue print of a computer system solution to a given problem having the same components and inter-relationship among the same components as the original problem. Input, output and processing specifications are drawn up in detail. In the design stage, the programming language and the platform in which the new system will run are also decided. There are several tools and techniques used for designing. These tools and techniques are: Each of the above tools for designing will be discussed in detailed in the next lesson. After designing the new system, the whole system is required to be converted into computer understanding language. Coding the new system into computer programming language does this. It is an important stage where the defined procedure are transformed into control specifications by the help of a computer language. This is also called the programming phase in which the programmer converts the program specifications into computer instructions, which we refer as programs. The programs coordinate the data movements and control the entire process in a system. It is generally felt that the programs must be modular in nature. This helps in fast development, maintenance and future change, if required. Before actually implementing the new system into operations, a test run of the system is done removing all the bugs, if any. It is an important phase of a successful system. After codifying the whole programs of the system, a test plan should be developed and run on a given set of test data. The output of the test run should match the expected results. Using the test data following test run are carried out: Unit test: When the programs have been coded and compiled and brought to working conditions, they must be individually tested with the prepared test data. Any undesirable happening must be noted and debugged (error corrections). System Test: After carrying out the unit test for each of the programs of the system and when errors are removed, then system test is done. At this stage the test is done on actual data. The complete system is executed on the actual data. At each stage of the execution, the results or output of the system is analysed. During the result analysis, it may be found that the outputs are not matching the expected out of the system. In such case, the errors in the particular programs are identified and are fixed and further tested for the expected output. When it is ensured that the system is running error-free, the users are called with their own actual data so that the system could be shown running as per their requirements. 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. During this phase, all the programs of the system are loaded onto the user's computer. After loading the system, training of the users starts. Main topics of such type of training are: After the users are trained about the computerised system, manual working has to shift from manual to computerised working. The following two strategies are followed for running the system: Maintenance is necessary to eliminate errors in the system during its working life and to tune the system to any variations in its working environment. It has been seen that there are always some errors found in the system that must be noted and corrected. It also means the review of the system from time to time. The review of the system is done for: If a major change to a system is needed, a new project may have to be set up to carry out the change. The new project will then proceed through all the above life cycle phases. 29.6 What You Have Learnt In this lesson systematic approach of any given problem is explained. Computer based systems are defined. System development life cycle is discussed in detail. The different phases of the development of system life cycle are explained in detail. Graphical representation of any process is always better and more meaningful than its representation in words. Moreover, it is very difficult to arrange and organise the large amount of data into meaningful interpretation of the whole. System Analysis and Design makes use of the various tools for representing and facilitating comprehension of the complex processes and procedure involved. In this lesson, we present some details about Flowcharts, data flow diagram (DFD), Decision Tables and Decision Trees. After going through this lesson you should be able to The pictorial representation of the programs or the algorithm is known as flowcharts. It is nothing but a diagrammatic representation of the various steps involved in designing a system. Some of the boxes which are used in flowcharts are: A flowchart consists of a set of 'flowchart symbols' connected by arrows. Each symbol contains information about what must be done at that point & the arrow shows the 'flow of execution' of the algorithm i.e. they show the order in which the instructions must be executed. The purpose of using flowcharts is to graphically present the logical flow of data in the system and defining major phases of processing along with the various media to be used. Flowcharts are of three types: System flowchart describes the data flow for a data processing system. It provides a logical diagram of how the system operates. It represents the flow of documents, the operations performed in data processing system. It also reflects the relationship between inputs, processing and outputs. Following are the features of system flowcharts: Run flowcharts are used to represent the logical relationship of computer routines along with inputs, master files, transaction files and outputs. Figure30. 2 illustrates a run flowchart. A program flowchart represents, in detail, the various steps to be performed within the system for transforming the input into output. The various steps are logical/ arithmetic operations, algorithms etc. It serves as the basis for discussions and communication between the system analysts and the programmers. Program flowcharts are quite helpful to programmers in organising their programming efforts. These flowcharts constitute an important component of documentation for an application. Figure 30.3 represents a program flowchart for finding the sum of first five natural numbers ( i.e. 1,2,3,4,5). Data flow diagrams are the most commonly used way of documenting the process of current & required systems. As their name suggests they are a pictorial way of showing the flow of data into, around & out of a system. Graphical representation of a system's data and how the processes transform the data is known as Data Flow Diagram (or DFD). Unlike, flowcharts, DFDs do not give detailed descriptions of modules but graphically describe a system's data and how the data interact with the system. DFDs are constructed using four major components External entities represent the source of data as input to the system. They are also the destination of system data. External entities can be called data stores out side the system. These are represented by squares. Data stores represent stores of data within the system. Examples, computer files or databases. An open-ended box represents a data/store – data at rest or a temporary repository of data. Process represents activities in which data is manipulated by being stored or retrieved or transferred in some way. In other words we can say that process transforms the input data into output data. Circles stand for a process that converts data into information. Data flows represents the movement of data from one component to the other. An arrow identifies data flow – data in motion. It is a pipeline through which information flows... Data flows are generally shown as one-way only. Data Flows between external entities are shown as dotted lines. Consider the figure30.4. It is clear from the figure that orders are placed, It does not however tell us how these things are done or who does them. Are they done by computers or manually and if manually who does them ? A logical DFD of any information system is one that models what occurs without showing how it occurs. A physical DFD shows, how the various functions are performed? Who does them? Consider the following figure: The figure 30.5 is opposite, it shows the actual devices that perform the functions. Thus there is an "order processing clerk", an "entry into computer file" process and a "run locate program" process to locate the parts ordered. DFD(s) that shows how things happen, or the physical components are called physical DFD(s). Typical processes that appear in physical DFDs are methods of data entry, specific data transfer or processing methods. The program flowchart describes boxes that describe computations, decisions, interactions & loops. It is an important to keep in mind that data flow diagrams are not program flowcharts and should not include control elements . A good DFD should Decision tables and trees were developed long before the widespread use of computers. They not only isolate many conditions and possible actions but they help ensure that nothing has been overlooked. The decision table is a chart with four sections listing all the logical conditions and actions. In addition the top section allows space for title, date, author, system and comment as shown in the fig.30.6 Five sections of a decision table: TITLE : DATE : Condition Stub Condition Entry Action Stub Action Entry Figure 30.6 Decision Table The condition stub contains a list of all the necessary tests in a decision table. In the lower left-hand corner of the decision table we find the action stub where one may note all the processes desired in a given module. Thus Action Stub contains a list of all the processes involved in a decision table. The upper right corner provides the space for the condition entry - all possible permutations of yes and no responses related to the condition stub. The yes and no possibilities are arranged as a vertical column called rules. Rules are numbered 1,2,3 and so on. We can determine the rules in a decision table by the formula: Number of rules = 2^N = 2N where N represents the number of condition and ^ means exponentiate. Thus a decision table with four conditions has 16 (24 = 2 x 2 x 2 x 2 = 16) rules one with six conditions has 64 rules and eight conditions yield 256 rules. The Condition entry contains a list of all the yes/no permutations in a decision table. The lower right corner holds the action entry. X's or dots indicate whether an action should occur as a consequence of the yes/no entries under condition entry. X's indicate action; dots indicate no action. Thus Action entry indicates via dot or X whether something should happen in a decision table. Let us consider the following example of book order illustrated by figure 30.7 If order is from book store And if order is for 6 copies Then discount is 25% Else (if order is for less then 6 copies) No discount is allowed Else (if order is from libraries) If order is for 50 copies or more Then discount is 15% Else if order is for 20 to 49 copies Then discount is 10% Else if order is for 6 to 19 copies Then discount is 5% Else (order is for less then 6 copies) No discount is allowed A decision table for the above process is illustrated below The decision tree defines the conditions as a sequence of left to right tests. A decision tree helps to show the paths that are possible in a design following an action or decision by the user. Figure 30.8 illustrates the concept of decision tree. Decision tree turns a decision table into a diagram. This tool is read from left to right, decision results in a fork, and all branches end with an outcome. Figure 6 illustrates the decision tree for the book order decision table we saw earlier.Introduction to System Analysis and Design
29.1 INTRODUCTION
29.2 OBJECTIVES
29.3 Defining A System

29.4 SYSTEM LIFE CYCLE
The different phases of software development life cycle is shown in Fig.29.1

Fig. 29.1 Different phases of Software development Life Cycle
29.5 PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE
(a) System Study
(b) Feasibility Study
(c) System Analysis
(d) System Design
(e) Coding
(f) Testing
(g) Implementation
(h) Maintenance

29.7 Terminal Question
System Description Techniques
30.1 INTRODUCTION
30.2 OBJECTIVES
30.3 FLOWCHARTS

(a) System Flowcharts

Figure: 30.1 System Flowchart
(b) Run flowcharts

Figure: 30.2 Run Flowchart
(c) Program flowcharts

Fig 30.3 Program Flowchart
(d) Data flow diagram
(e) Defining DFD
(f) Components of DFD
(i) External Entities
(ii) Data Stores
(iii) Process
(iv) Data Flows
(g) Physical & Logical DFD
orders are received, the location of ordered parts is determined and delivery notes are dispatched along with the order.
Fig 30.4

Fig 30.5
(h) Difference between flowcharts & DFD
30.4 DECISION TABLES AND DECISION TREES
(a) Decision Tables
Author :
Comments :
System :

Figure 30.7: Decision Table
(b) Decision Tree

Figure 30.8: Decision Tree

Figure 30.9: Decision Tree for Book Order
30.5 What You Have Learnt
Various specification tools and techniques of system analysis and designing were discussed in detailed. The various tools such as flowcharts, data flow diagrams, decision tables & decision trees were explained. These tools and techniques are used when the system under study involves the development of computer based information system.
30.6 Terminal Questions
- What is flow chart ?
- Explain different types of flow charts.
- Define DFD. Explain different components of DFD.
- Explain decision table and decision tree.
Describing Data
31.1 Introduction
An important aspect of system analysis is analysis of system data. For describing the data in its meaningful form data dictionary is developed. Data dictionary also contains the different types of data as well as their meanings. It serves as a powerful tool of system analysis and designing.
31.2 Objectives
After completing this lesson the you should be able to :
- describe data into its meaningful form
- understand different types of data
- prepare data dictionary for given system
- normalize the relations up to third normal form
31.3 Data definition
Most people use the terms data & information interchangeably. But data & information are not the same.
31.4 Data and Information
Data are raw facts and figures in isolation. These isolated facts and figures convey meanings but generally are not useful by them. For example, A, H, ,34, 26, 56.68,VISHAL, SCHOOL etc.
Data are processed to form information. Data are processed in various meaningful ways to form information. For example, 'Prasad, whose enrolment no. is 270173002, has been certified in Sr.Secondary examination of National Open School' is an information as it conveys some meaning.
31.5 Types of data
Data are of various types, among them major ones are-
- Character type
- Numeric type
- Alphanumeric type
Character type are those data which is consisting of only the alphabets i.e. from A to Z
For example Name, Age, Thing etc.
Numeric data types are those data types which is consisting only of numbers or integers & the combination of digits from 0 to9.
Example 254, 67, 2, 7, etc.
Alphanumeric are those types of data which is constructed by the combinations of characters &Numeric data types.
Example- A79, DD56, 4G6 etc.
31.6 Data Dictionary
A data dictionary defines each term encountered during the analysis and design of a new system. Data dictionary is the place where we keep the details of the contents of data flows, data stores & processes.
Data dictionary is an analysis tool, that primarily records the information content of data.
Without a data dictionary the development of large systems becomes difficult. The data dictionary is an effective solution to the problem of complicated nature. The main purpose of a data dictionary is to provide a source of reference in which the analyst , the user, the designer can look up & find out it's content and any other relevant information.
Examples of Data dictionary –
Student Record = Enrolment Number +
Name +
Address +
Sex +
Date of Birth +
Subject +
31.7 Levels of Data Dictionary
We can define the data dictionary in three different levels.
- Data Elements
- Data Structure
- Data flows and Data Stores
(a) Data Elements
Data elements are pieces of data, which need not be broken further. Data elements can describe files, data flows, or processes. Often a data element is self defining such as Student name, enrolment no.
(b) Data structure
Data structure comprises of data elements. It is defined as collection of data elements. For example let us consider the following "Student Information Record".
Student Information
Enrolment Number
Student name
First name
Second name
Last name
Sex
Student Address
Address 1
Address 2
Address 3
Pin code
Subject Details
Subject1
Subject2
Subject3
Subject4
Subject5
Subject6
Background details
Family background
Father's education
Mother's education
Family Income
Urban/rural
House hold items
TV (Y?N)
Radio (Y?N)
Cycle(Y?N)
Here "STUDENT INFORMATION" is a data structure, made up of data elements student name, enrolment number. "Subject details" is a data structure made up of six data elements subject1 to subject6.
(c) Data flows & Data stores
Data flows are paths along which data travels & Data stores are places where data is stored until needed. So we can say that Data flows are Data structures in motion & Data
stores are Data structures at rest. Data description Hierarchy is illustrated in figure 31.1

Figure 31.1 : Data description Hierarchy
A data dictionary as we have seen, contains Data elements, Data structures and Data flows and data stores along with this processes, external entities & glossary of user terms.
Processes are defined with number of the tools, such as Decision trees &Decision tables, which have already been discussed in previous lesson. In number of applications the users have their own vocabulary & this can be confusing to the analysts and the programmers. In that case data dictionary is a convenient place to keep these glossary items for reference purpose.
31.8 Normalization
Normalization is a process by which the contents of the data store is simplified by removing redundant data elements. It is done by removing repeating groups and reorganizing the contents of data store.
Let us consider the following data structure:
Name
Personnel-No.
Address
Salary-Slip-History*
Date-of-change
Job-title
Salary
Now, how can we get rid of the repeating group, Salary-Slip-History? The only way is, to split the main structure into two structures, both of which are simpler. After doing this normalization process, we end up with a structure containing name and address (occurring only once for each employee) and a structure containing change of title or salary (several for each employee). Each structure must contain Personnel-No., the only data element, which specifies each employee uniquely.
In normalization the following vocabulary are used . In place of "data structure", relation is used. In place of "data element", the term domain is used. Each individual record is called a tuple.
There are three types of normalized relations, called in increasing order of simplicity; first normal form, second normal form, and third normal form.
(a) First Normal Form
Any normalized relation is automatically 1st normal form. Relations in first normal form may suffer from two kinds of complexity.
- If the primary key is concatenated (chained together), some of the non-key domains may depend on only part of the key, not the whole key.
- Some of the non-key domains may be interrelated.
Suppose we are trying to produce a normalized version of the data structure, "Orders", describing book purchases. We define an order than consists of the customer-name, order-date, ISBN for the book ordered, title, author, quantity of title that has been ordered and total cost of the order for a given book.
We can create a normalized relation:
Book-order (Customer-Name, Order-Date, ISBN, Author, Title, Quantity, Price, Order-Total)
Here the underline shows that we have chosen the concatenated key: Customer Name/Order-Date/ISBN to uniquely identify each order. As we have noted, this relation is in 1st NF, by virtue of the fact that, it contains no repeating groups.
The first complexity we would like to remove is the fact the several of the non-key, domains (Title, Author and Price) can be identified with only part of the key-the ISBN. In other words, if you are given the ISBN, you can know the Title, Author and Price not taking into account the "Customer-Name" or the "Order-Date". This is a different situation from that "Quantity". To know the quantity in any particular order, you have to know all of the three domains, which are concatenated, to make the key.
In the vocabulary of normalization, "Quantity" is fully functionally dependent on the whole concatenated key. On the other hand, "Title" is not fully functionally dependent. Since, you only need to know part of the key (ISBN) to find the "Title", a domain is fully functionally dependent, but not fully so, if the value of the domains can be determined from only part of the key. This concept allows us to define second normal form.
(b) Second Normal Form
A normalized relation is in 2nd normal form if all the non-key domains are fully functionally dependent on the primary key "Book Order". To get "Book Order" into 2nd formal form, we must get rid of the partial functional dependence. This can be done by taking out the domains which describe the book and putting them in a separate relation:-
Order (Customer-Name, Order-Date, ISBN, Quantity Order-Total)
Book (ISBN), Title, Author, Price)
Order is now in 2nd normal form : each of the non-key domains (Quantity, Order-Total) can only be specified by knowing the fully concatenated key, i.e., all the non-key domains are fully functionally dependent on the primary key.
We can simplify the situation even further, because "Order" has a complexity, still working in it. "Quantity" and "Order-total" are not mutually independent. For only given "Price" the "Quantity" determines the "Order-total". Therefore, "Order-Total" is functionally dependent on quantity.
(c) Third Normal Form
A normalized relation is in 3rd normal form if :
- All the non-key domains are "fully" functionally dependent on the primary key.
- No non-key domain is functionally dependent on any other non-key domains.
So to transform a 2nd normal form relation into a 3rd normal form, we examine each of the non-key domains to see that they are independent of the other non-key domains and remove any such mutual independence. In the case of "Order", we see that "Order-Total" is, in fact, a redundant data element, because it can be completed. So, we can remove it altogether and express each "Order" by means of two relations, both in 3rd normal form.
Book-Order (Customer-Name, Order-Date, ISBN, Quantity)
Book (ISBN, Title, Author, Price)

31.8 What You Have Learnt
In this lesson data and types of data are explained. Data dictionary as analysis tool has been discussed in detail. The three levels of data dictionary are discussed. Normalization as techniques for simplifying the data structure is also explained. The three different normalized relations are explained.
31.9 Terminal Question
- Define data and explain different types of data.
- What is data dictionary.
- Explain different levels of data dictionary.
- What is normalization.
- Explain different forms of normalization.
System Development Methodologies
32.1 INTRODUCTION
Different types of system development methodologies are used in designing information system. Depending upon the actual requirement of the system, different approaches for data processing are adopted. However, some system groups recommends the Centralised data processing system while others may go in for distributed data processing system. In a Centralised data processing, one or more centralized computers are used for processing and the retrieval of information is done from them. The distributed processing systems involve number of computers located remotely in the branches/departments of the organisation. The client/server technologies are also gaining popularity these days.
32.2 OBJECTIVES
After going through this lesson you should be able to
- know the advantages and disadvantages of centralised/distributed data processing system.
- understand the meaning of various approaches to the information system
- understand the networking environment
- understand the meaning of client/server technology
32.3 DATA PROCESSING SYSTEM
Data processing techniques are very much dependent on the kind of applications and the working environment. The activities involved in the data processing are along departmental lines and are application based such as Store Management, Production Planning & Control, Sales Accounting, Financial accounting, Student Information System, and so forth. The basic input data are the real resource of the data processing. With the increase of the technologies the concept of the integrated data processing also came into being where the output data of one application can be used as the input of another application. Depending upon the application area, working environment and the needs of the management there are basically two approaches of data processing:
- Centralised data processing
- Decentralised data processing
32.4 CENTRALISED DATA PROCESSING SYSTEM
With the increasing use of computer based data processing, there has been a growing tendency in the minds of management to centralise the data processing activities. A separate department EDP (Electronic Data Processing) department is established to carry out the data processing work of different department in the organisation. Many a times the data processing is also done by hiring the services of the out side agencies and with the passage of time and experience in-house set is developed for data-processing.
The centralised data processing system provides the following benefits:
- The emergence of data takes place only at one place.
- The loss of data is minimised.
- The methods and machines can be standardised.
- Services of more competent and technical personnel can be taken.
- It is also very cost-effective particularly in the case of large operations.
- Duplication of work can be avoided.
The disadvantages, however, are:
- Lack of cooperation from managers, who do not like to be under control of centralised Data Processing department.
- Resistance from managers for mechanising the data processing activities relating to their various functions.
- It is difficult to provide equitable services to various departments.
- The data security is also questioned.
32.5 DECENTRALISED DATA PROCESSING SYSTEM
In the decentralized data processing system, there is really a divisional breakdown of computing services. Each division, unit or department handles its own computer needs and does not like to interact with any other division, unit or department. It is well suited to a decentralized management scheme in which organizational autonomy is important. For example, research divisions of large organisation may adopt the decentralized data processing approach to provide data security of their work
Arguments in the support of decentralized data processing include the following:
- Familiarity with local problems.
- Rapid response to local processing needs
- Profit-and-loss responsibility can be easily fixed
The drawbacks of the decentralized data processing system are:
- There is duplication of activities and redundancy in the maintenance of files.
- It is difficult to maintain uniformity in the procedures throughout the organisation.
- The overall cost of the data processing for the organisation is more.
32.6 INFORMATION SYSTEM
The information system aims at providing detailed information on a timely basis throughout the organisation so that the top management can take proper and effective decisions. The information system cuts across departmental lines and help achieving overall optimization for the organisation.
The organisation is viewed as a network of inter-related sub-systems rather than as a hierarchy of manager-subordinate relationship. The information system can be of two types:
- Integrated information system
- Distributed information system
(a) Integrated Information System
The integrated information system is based on the presumption that the data and information are used by more than one system in the organisation and accordingly, the data and information are channeled into a reservoir or database. All the data processing and provision of information is derived and taken from this common database. The development of an integrated information system requires a long-term overall plan, commitment from management at all levels, highly technical personnel, availability of sufficient fund, and sophisticated technology. It also requires adequate standby facilities, without which the system is doomed to failure. Because of its integrated component, the modification to the system is quite difficult and the system development takes a fairly long time.
(b) Distributed Information System
There are opinion that development of an integrated information system is embodied with several practical problems and therefore, not feasible. This view has been reinforce by the failure of integrated systems in various large organisations. The concept of a distributed information system has emerged as an alternative to the integrated information system. In the distributed information system, there are information sub-systems that form islands of information systems. The distributed information system aims at establishing relatively independent sub-systems, which are, however, connected through communication interfaces.
Following are the advantages of the distributed information system:
- The processing equipment as well as database are dispersed, bringing them closer to the users.
- It does not involve huge initial investment as is required in an integrated system.
- It is more flexible and changes can be easily taken care of as per user's requirements.
- The problem of data security and control can be handled more easily than in an integrated system.
- There is no need of standby facilities because equipment breakdowns are not as calamitous as in an integrated system.
The drawbacks of the distributed system are:
- It does not eliminate duplication of activities and redundancy in maintaining files.
- Coordination of activities becomes a problem.
- It needs more channels of communication than in an integrated system.
It is possible to consider several alternative approaches, which fall between the two extremes - a completely integrated information system and a totally independent sub-system. It is to be studied carefully what degree of integration is required for developing an information system. It depends on how the management wants to manage the organisation, and the level of diversity within the organisation.
32.7 MULTI-USER ENVIRONMENT
The necessity of sharing of data and information gave rise to multi-user environment. In a multi-user environment, there is a concept of file server and user nodes or user terminals connected to the file server. There are various ways of developing a multi-user environment depending upon the connectivity. There is local area network(LAN) where nodes are connected with the file server with cables through which the data and information are transferred from file server to the different nodes connected to the file server and vice-versa. In a Wide Area Network, the nodes are connected through MODEM or through satellite.
32.8 NETWORK/FILESERVER SYSTEM
In a Local Area Network, all the data and programme files are stored in a file server. A file server is the central node in the network. All the users connected to the file server through different nodes can access the data and information stored in the fileserver simultaneously. The file server in a LAN acts as a central hub for sharing peripherals like, printers, modems, etc. In a LAN, an application running on a workstation reads and writes files on the file server. In many cases the entire files are pumped across the network on behalf of the operations taking place on LAN PCs. A file server does not involve in processing of an application. It simply stores files for applications that run on LAN PCs. For example, you might have a personal database manager and then request information in a file on the on the file server. The file server sends all or part of the data file across the network to your workstation. As you work with your personal database manager and the database on your workstation, the file server does not take part at all. When you save the file back to the file server across the network.
Two flaws limit a file server system for multi-user applications. First, the file server model does not deliver the data concurrency (simultaneous access to a single data set by more than one user), that is required frequently by multi-user applications. The reason behind it is that the file server operates in files, which are set of large number of data records and prevent a user from sharing a file when another user has it locked out. Second, if many workstations request and send many files in a LAN, the network can quickly become saturated with traffic, creating a bottleneck that degrades overall system performance.
32.9 CLIENT /SERVER SYSTEM
The limitations of the network/file server system have led to the genesis of the client/server system. It delivers the benefits of the network-computing model along with the stored data access. Any local area network could be considered as client/server system, since workstations (clients) request services such as data, program file or printing from server.
A client/server has three distinct components, each focussing on a specific job: a database server, a client application and a network. Figure 2 represents an idea about the components of the client/server-computing model.
A server (or "back end") manages the resources such as database, efficiently and optimally among various clients that simultaneously request the server for the same resource. Database server mainly concentrate on the following tasks:
- Managing a single database of information among many concurrent users.
- Controlling database access and other security requirements.
- Protecting database of information with backup and recovery features.
- Centrally enforcing global data integrity rules across all client applications.
32.11 Client Application
A client application (the "front end") is the part of the system that users apply to interact with data. The client application in a client/server model focus on the following job:
- Presenting an interface between the user and the resource to complete the job.
- Managing presentation logic.
- Performing application logic
- Validating data entry
- Managing the request traffic of receiving and sending information from a database server.
32.12 Network
The third component of a client/server system is network. The communication software are the vehicles that transmit data between the clients and the server in client server system. Both the client and the server run communication software that allows them to talk across the network.

32.13 What You Have Learnt
In this lesson different data processing methodologies such as centralised, decentralised have been explained. The development methodologies of various information system is also explained. A brief description about network/file server and client/server technology has also been made.
32.14 Terminal Questions
- Define various data processing techniques.
- What is difference between integrated information system and distributed information system?
- What is client/server system? Explain the different components of a client/server system.


Comments (0)
Post a Comment