Page 1 :
DBMS, , , , Database management system is, software that is used to manage the, database., , What is Database, , The database is a collection of inter
Page 2 :
related data which is used to, retrieve, insert and delete the data, efficiently. It is also used to, organize the data in the form of a, table, schema, views, and reports,, etc., , For example: The college Database, organizes the data about the admin,, staff, students and faculty etc., , Using the database, you can easily, retrieve, insert, and delete the, information., , Database Management, System
Page 3 :
- Database management system, is a software which is used to, manage the database. For, example: MySQL, Oracle, etc are, a very popular commercial, database which is used in, different applications., , - DBMS provides an interface to, perform various operations like, database creation, storing data in, it, updating data, creating a table, in the database and a lot more., , - It provides protection and, security to the database. In the, case of multiple users, it also
Page 4 :
maintains data consistency., , DBMS allows users the following, tasks:, , - Data Definition: It is used for, creation, modification, and, removal of definition that defines, the organization of data in the, database., , - Data Updation: It is used for the, insertion, modification, and, deletion of the actual data in the, database., , - Data Retrieval: It is used to, retrieve the data from the
Page 5 :
database which can be used by, applications for various purposes., , - User Administration: It is used for, registering and monitoring users,, maintain data integrity, enforcing, data security, dealing with, concurrency control, monitoring, performance and recovering, information corrupted by, unexpected failure., , Characteristics of DBMS, , - It uses a digital repository, established on a server to store, and manage the information.