Difference between file based approach and database approach
Answers
File Based Approach:
1. The data and program are inter- dependent.
2. File-based system caused data redundancy. The data may be duplicated in different files
3. File –based system caused data inconsistency. The data in different files may be different that cause data inconsistency.
4. The data cannot be shared because data is distributed in different files.
5. In file based system data is widely spread. Due to this reason file based system provides poor security.
6. File based system does not provide consistency constrains.
7. File based system does not provide concurrency facility.
Database Approach:
1. The data and program are independent of each other.
2. Database system control data redundancy. The data appeared only once in the system.
3. In database system data always consistent. Because data appeared only once.
4. In database data is easily shared because data is stored at one place.
5. It provides many methods to maintain data security in the database.
6. Database system provides a different consistency constrains to maintain data integrity in the system.
7. Database system provides concurrency facility.