Home » Online Computer Education » Learn online DBMS “Need of Database Management System” Lesson 2

Learn online DBMS “Need of Database Management System” Lesson 2

 

Need for a Database
In Traditional file processing, data is stored in the form of files. A number of application programs are written by programmer’s to insert, delete, modifyand retrieve data from these files. New application programs will be added to the system as the need arises. For example, consider the Sales and Payroll departments of a company. One user will maintain information about all the salespersons in the Sales department in some file say File1 and another user will maintain details about the payroll of the salesperson in a separate file say File2 in the Payroll Department as shown in Figure 3.

 

need of dmbs 1

Although both the departments need information about the salesperson but they will store information about the salesperson in different files and will use different application programs to access those filesand this would result in:
1. Data Redundancy – Same information is stored in more than one file. This would result in wastage of space.
2. Data Inconsistency – If a file is updated then all the files containing similar information must be updated else it would result in inconsistency of data.
3. Data Isolation – For new application programs, it might be difficult to retrieve the required data which might be stored in different files.
4. Lack of Data Integration – As data files are independent, accessing information out of multiple files becomes very difficult.
Database approach overcomes these problems and also adds a lot of advantages as discussed later. In database approach a single repository of data is maintained which is accessed by different users as per their needs.

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

Leave a Reply

Your email address will not be published. Required fields are marked *