A database system is basically a computer based record system. The collection of data, usually referred to as the database,contains information about one particular enterprise. In a typical file-processing system,permanent records are stored in various files.A number of different application programs are written to extract records from files and add records to the appropriate files.But this scheme has a number of limitations and disadvantages, such as data redundancy, data inconsistency, un-sharable data, un-standardized data.
Some advantages are:
- Database systems reduce data redundancy to a large extent.
Database system control data inconsistency to a large extent.
Databases facilitate sharing of data.
Databases enforce standards.
Loop crew.