BCE-C403- DATABASE MANAGEMENT SYSTEM
An Overview of DBMS
A Database Management System (DBMS) is a software system that manages and
controls the storage, organization, retrieval, and security of data in a database. It is an
essential tool for managing data in
organizations and businesses of all
sizes.
For example, if we have data about
marks obtained by all students, we can
then conclude ( Calculate the data and
find out ) about toppers and average
marks.
A database management system stores
data in such a way that it becomes easier to fetch, use in future in case we want to use
this data.
The main functions of a DBMS include:
● Data storage: It provides a mechanism for storing and organizing data in a
structured way.
● Data retrieval: It allows users to retrieve data from the database using queries
and other search mechanisms.
● Data manipulation: It enables users to modify, update, and delete data in the
database.
● Data security: It provides security features to protect data from unauthorized
access, modification, and deletion.
● Data integrity: It ensures that the data stored in the database is accurate,
consistent, and up-to-date.
,DataBase System and File System
Database System File System
To manage and organize large To store and manage individual
Purpose
volumes of data. files.
Organized into tables with Organized as a collection of
Structure
interrelated data. individual files.
Data Minimal, as data is stored only Common, as data may be
Redundancy once in the database. duplicated across multiple files.
High, as data is checked for
Data Low, as consistency and accuracy
consistency and accuracy
consistency are not enforced.
before being stored.
, Controlled and secure, with user Unrestricted, with files accessible
Data access access managed through user to any user with appropriate
permissions. permissions.
Limited or no query language, with
Query SQL or other specialized query
data accessed through file names
language languages.
and folder structures.
Built-in backup and recovery Manual backup and recovery, with
Data backup
mechanisms. no built-in mechanisms.
Limited scalability, with file
Can handle large volumes of systems becoming slower and less
Scalability
data and can be easily scaled. efficient as the number of files
increases.
An Overview of DBMS
A Database Management System (DBMS) is a software system that manages and
controls the storage, organization, retrieval, and security of data in a database. It is an
essential tool for managing data in
organizations and businesses of all
sizes.
For example, if we have data about
marks obtained by all students, we can
then conclude ( Calculate the data and
find out ) about toppers and average
marks.
A database management system stores
data in such a way that it becomes easier to fetch, use in future in case we want to use
this data.
The main functions of a DBMS include:
● Data storage: It provides a mechanism for storing and organizing data in a
structured way.
● Data retrieval: It allows users to retrieve data from the database using queries
and other search mechanisms.
● Data manipulation: It enables users to modify, update, and delete data in the
database.
● Data security: It provides security features to protect data from unauthorized
access, modification, and deletion.
● Data integrity: It ensures that the data stored in the database is accurate,
consistent, and up-to-date.
,DataBase System and File System
Database System File System
To manage and organize large To store and manage individual
Purpose
volumes of data. files.
Organized into tables with Organized as a collection of
Structure
interrelated data. individual files.
Data Minimal, as data is stored only Common, as data may be
Redundancy once in the database. duplicated across multiple files.
High, as data is checked for
Data Low, as consistency and accuracy
consistency and accuracy
consistency are not enforced.
before being stored.
, Controlled and secure, with user Unrestricted, with files accessible
Data access access managed through user to any user with appropriate
permissions. permissions.
Limited or no query language, with
Query SQL or other specialized query
data accessed through file names
language languages.
and folder structures.
Built-in backup and recovery Manual backup and recovery, with
Data backup
mechanisms. no built-in mechanisms.
Limited scalability, with file
Can handle large volumes of systems becoming slower and less
Scalability
data and can be easily scaled. efficient as the number of files
increases.
