Chapter-1
BASIC CONCPETS OF DBMS
DATA : Data is a raw fact or figures of any object through which an object cannot be identified.
For example: Emp_No, Name, Salary of an employee individually known as one data.
INFORMATION: Organized Collection of related data is known as information through which
an object can clearly identified OR the processed data is called information.
For example: Emp_No, Name, Salary of an employee combined together, is known as
information.
DATA FILE: Organized Collection of related information is known as data file.
For example: Sales dept, purchase dept, Administrative dept of a particular company maintains
their data file.
DATA BASE: Organized collection of related data files or information is called database.
OR
A database is an integrated collection of logically related records and files. OR A database can
be defined as a collection of coherent, meaningful data.
For example: Qr_No, Road name, Area name, Dist name, State name, pin code Combined
together creates a postal address. The multiple addresses kept together in one place, such as an
address book is a database and the postal address in the book is the data that fills the data base.
DBMS: It is a collection of programs that enables user to create and maintain a database. In
other words it is general-purpose software that provides the users with the processes of defining,
constructing and manipulating the database for various applications.
DATABASE SYSTEM: The database and DBMS software together is called as Database
system.
NOTE: Though data is a raw fact through which an object cannot be identified, but it’s the bare
minimum requirement to build a database.
Applications of DBMS:
Databases are widely used. Some of them are as follows.
Banking-> For customer information, accounts, loans and banking transactions.
Airlines-> For reservation and scheduled information.
Universities-> For student, course and grade information.
Credit card transactions-> For purposes on credit cards and generation of monthly
statements.
