Introduction to Database Management System



Data: The Collection of Organized Information is called the Data.
Database: The Organized Collection of Data, which contains relation information.
Database Management System: The Collection of interrelated Data and a collection of Programs to access that Data.
Goal of DBMS: The goal of DBMS is to provide a way to store and retrieve information in a convenient and efficient manner.

Properties of DBMS:

  1. A Database represents some aspect of the real world. Changes to the real world reflected in the database.

  2. A Database is a logically coherent collection of data with some inherent meaning. A random assortment of data cannot correctly be referred to as a database.

  3. A Database is designed built and populated with data for a specific purpose. It has an intended group of users and preconceived applications in which these users are interested.

Need of DBMS:

  1. Before the advent of dbms, organizations typically stored information using a “file processing systems”. Example of such systems are file handling in high level languages like c, basic and cobol etc., these systems have major disadvantages to perform the data manipulation. So to overcome those drawbacks now we are using the dbms.

  2. Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition to that the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results.

  3. The information is so important in most organizations. Computer scientists have developed a large body of concepts and techniques for managing data.