Database Management System (DBMS):
A Database Management System (DBMS) is a software system that is designed to manage and
organize data in a structured manner. It allows users to create, modify, and query a database, as
well as manage the security and access controls for that database.
Key Features of DBMS:
Data storage and retrieval
Data integrity and security
Backup and recovery
Concurrency control
Applications of DBMS:
Banking and Finance Sector:
University
Airlines.
Telecommunications
Airlines
Schools & Colleges
etc.
Database Schema:
A database schema is a structure that represents the logical storage of the data in a
database. It represents the organization of data and provides information about the relationships
between the tables in a given database.
DBMS Instance:
In DBMS, the data is stored for a particular amount of time and is called an instance of the
database. The database schema defines the attributes of the database in the particular DBMS. The
value of the particular attribute at a particular moment in time is known as an instance of the
DBMS.
Advantages of DBMS:
Data organization: A DBMS allows for the organization and storage of data in a
structured manner, making it easy to retrieve and query the data as needed.
Data integrity: A DBMS provides mechanisms for enforcing data integrity constraints.
Concurrent access: A DBMS provides mechanisms for controlling concurrent access to
the database, to ensure that multiple users can access the data without conflicting with each
other.
Data security: A DBMS provides tools for managing the security of the data, such as
controlling access to the data and encrypting sensitive data.
Backup and recovery: A DBMS provides mechanisms for backing up and recovering the
data in the event of a system failure.
Data sharing: A DBMS allows multiple users to access and share the same data, which
can be useful in a collaborative work environment.
Difference between File System and DBMS:
File System:
File based systems were an early attempt to computerize the manual system. It is also called a
traditional based approach in which a decentralized approach was taken where each department
stored and controlled its own data with the help of a data processing specialist. The main role of
a data processing specialist was to create the necessary computer file structures, and also manage
the data within structures and design some application programs that create reports based on file
data.
DBMS:
A database approach is a well-organized collection of data that are related in a meaningful way
which can be accessed by different users but stored only once in a system. The various
operations performed by the DBMS system are: Insertion, deletion, selection, sorting etc. A
Database Management System (DBMS) is a software system that is designed to manage and
organize data in a structured manner. It allows users to create, modify, and query a database, as
well as manage the security and access controls for that database
Two-Tier architecture:
Three-Tier architecture:
Data models in DBMS:
1. Relational data model
2. Semi structured Data model
3. Entity- Relationship data model
4. Object based data model
Overall database Structure: