A Database is a collection of large volume of data.
Advantages of DBMS:
1. Data Redundancy: It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.
2. Inconsistency can be avoided: If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.
3. Efficient data access: It stored huge amount of data efficiently and can be retrieved whenever a need arise.
4. Data can be shared: The data stored in the database can be shared by the users or programs.
5. Standards can be enforced: The data in the database follows some standards.
Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.
6. Security restrictions can be applied: The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized person.
7. Integrity can be maintained: It ensures that the data is to be entered in the database is correct.
8. Crash recovery: Some times all ora portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.