What is DBMS?
A Database Management System (DBMS) is software that allows users to create, store, organize, manage, and retrieve data efficiently. It acts as an interface between the database and users.
Why DBMS is Needed?
Traditional file systems have several limitations such as data redundancy, inconsistency, and difficulty in accessing data. DBMS overcomes these problems by providing centralized data- management.
Advantages of DBMS
- Reduces data redundancy
- Improves data consistency
- Provides data security
- Supports data sharing
- Provides backup and recovery
- Ensures data integrity
Components of DBMS
- Hardware
- Software
- Database
- Users
- Procedures
Database Users
- Database Administrator (DBA)
- Database Designers
- Application Programmers
- End Users
Three Level Architecture
- External Level
- Conceptual Level
- Internal Level
This architecture provides data abstraction and data independence.
Data Independence
Data Independence is the ability to modify the schema without affecting application programs.
- Physical Data Independence
- Logical Data Independence
Important Exam Facts
- DBMS stands for Database Management System.
- DBA stands for Database Administrator.
- Data Independence is a key feature of DBMS.
- Three-level architecture was proposed by ANSI-SPARC.