INTRODUCTION
DBMS- A database management system(DBMS) is a collection of interrelated data and a set of programs to access those data.The principal goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.
Database System Applications-
-Banking
-Airlines
-Universities
-Credit Card Transactions
-Telecommunications
-Finance
-Sales
-Manufacturing
-Human Resources
Database System versus File Systems- Typical file processing system is supported by a conventional operating system.The system stores permanent records in various files and it needs different applications programs to extract records from and add records to the appropriate files.
Keeping organizational information in a file processing system has a number of major disadvantages:
-Data redundancy and inconsistency
-Difficulty in accessing data
-Data isolation
-Integrity problems
-Atomicity problems
-Concurrent access anomalies
-Security problems
View of Data- A major purpose of a database system is to provide users with an abstract view of the data.That is, the system hides certain details of how the data are stored and maintained.