Characteristics of File system and Data approach in Dbms

1. File System Approach :- 

                                            File system approach was an early attempt to computerize the manual filing system. t is basically a collection of application programs that performed services for the end users. ach program within a file based system defines and manages its own data. In this system, a large number of files are needed to perform various tasks. For example: In sales department of an enterprise, one user will be maintaining the details of how many sales personnel are there in the sales department and their grades, these details will be stored and maintained in a separate file. Another user will be maintaining the salesperson salary details working in the concern, the detailed salary report will be stored and maintained in a separate file. Although both of the users are interested in the data's of the salespersons they will be having their details in separate files and they need different programs to manipulate their files. This will lead to wastage of space and redundancy or replication of data's, which may lead to confusion, sharing of data among various users is not possible, data inconsistency may occur.

2. Database Approach:-

                                      In order to remove all the above limitations of the File system approach, a new approacn was required that must be more effective. So, the concept of database was introduced. This approach is known as database approach. A database is a computer based record record and maintains keeping system whose over all purpose is information. The database is a single, large repository of data, whicn can be used simultaneously by many departments and users. With the database instead of disconnected files with approach redundant data, all data items are integrated with minimum amount of duplication and maintained only at one location .

Characteristics of File System Approach:-

Some important characteristics of file system approach are: 

1. It is a group of files storing data of an organization .
   
   
2. Each file is independent from one another .
   
   
3. Each file is called a flat file . 
   
   
4.  Each file contained and processed information for one specific task, such as accounting or inventory.
   
   
5. Files are designed by using programs written in programming languages such as C++ . 

Characteristics of Database Approach:-

                                                            A database approach possesses the following characteristics:-

1. It is central repository of shared data. It allows several users to access the database i d also take concurrently. 
   
   
2.  A fundamental feature of the database approach is that the database system does not only contain the data but also the complete definition and description of these data These descriptions are basically details about the extent, the structure, the type and the format of all data and, additionally, the relationship between the data. This kind of stored data is called metadata ("data about data"). 
   
   
3.  A primary feature of the database approach is a standardized, uniform approach to same data are ng in different the same data is recorded database access. This means that the same overall procedures are used by all application programs to retrieve data and information.
   
   
4.  Data should be correct with respect to the real world entity that they represent. 
   
   
5.  Data should be protected from unauthorized access.
   
   
6.  Its organization is such that duplication of data is minimized.
   
   
7. Data in a database exist permanently until it is not explicitly deleted.