INTRODUCTION
Database system, plays a vital role in organising data about a particular enterprise. Consider an
example of a company which stores data about following :
Employees ( employee number ,name, address ,salary)
Department( department number, department name ,location )
project (project name, project number, location)
Therefore, a system is needed which can effectively organise the data, organise the data
and also use it to analyse and guide operations of the company.
CONCEPT OF DATABASE MANAGEMENT SYSTEM:
database management system consist two components first database.
1. DATABASE -It’s a collection of data
2. SYSTEM or set of programs which are used to access and manage the database. DBMS
organize the information ,maintain and retrieve it effectively as and when required.
CONCEPT OF DATA:
data are facts or undoubted information used for different computational or calculations. For
example, the facts related to an employee like employee number, name, salary, designation etc.
INFORMATION
Now what is information when these data are retrieved or processed to find answers of questions like
what is employee number of employee whose salary is more than 10,000? THEN IT BECOME
INFORMATION. THUS INFORMATION IS A PROCESSED FORM OF DATA.
FULL DEFINATION OF DBMS
A dat abas e, is a collection of interrelated data which represents some aspects of real world. Database has
some inherent meaning and is related to a particular group of users or applications.
For example - database of a college , May contain data about students, faculties, courses etC. which are
related to each other with certain relations like -faculty teachs students, students are enrolled in courses
etc.
The primary objective of a DBMS is to provide an environment that is convenient and efficient to
use ,in retrieving information from and storing information into the database.
DBMS ALLOWS USERS TO THE FOLLOWING TASKS:
1. DATA DEFINITION : It is used for creation, modification, and removal of database objects that
defines the organization of data in the database.
2. DATA UPDATION : It is used for the insertion, modification, and deletion of the actual data in the
database.
3. DATA RETRIEVAL : It is used to retrieve the data from the database which can be used by
applications for various purposes.
4. USER ADMINISTRATION : It is used for registering and monitoring users,maintaining data
integrity, enforcing data security, dealing with concurrency control, monitoring performance and
recovering information corrupted by unexpected failure.
5. For avoiding data redundancy and inconsistency
