RDBMS=== LECTURE CLASS I

===========================================

1. What is DBMS? Explain its features.

====================================

A. 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 and add recordsto the appropriate files. But this method has a number of disadvantages, such as DataRedundancy, Difficulty in access, Data Isolation, Concurrent Access, Security Problems, andIntegrity Problems..

A Database Management System (DBMS) consists of a collection of interrelated data and a set of programs to access this data. This collection of Data is called Database. The Primary goal of a DBMS is to provide a convenient environment to retrieve and store database information.

Features of DBMS:-

=========================================

1.

The integration and sharing of data files minimizes the duplication and redundancy of

data to a great extent.

2.

Integration of data files also results in a considerable saving of storage space and in

data entry and data storage costs.

3.

Fewer application programs need to be developed for obtaining various reports due to independence of programs and data.

4.

The query language facility helps non-programming persons to access the database

for information as needed without the help of any programmer.

5.

Faster preparation of information to support non-recurring tasks and changing

conditions is possible.

6.

Updation of data becomes easier due to integration of data file. Fewer errors may

when several records may be updated simultaneously.

7.

Large database maintenance.