DBMS and RDBMS
SQL Basics Course
Topic 2: DBMS and RDBMS
Understand how database systems manage data and why relational databases dominate modern applications.
Learning Objectives
- Understand DBMS
- Learn the features of DBMS
- Understand RDBMS
- Compare DBMS and RDBMS
- Explore real-world database systems
What is DBMS?
DBMS (Database Management System) is software used to create, store, manage, and retrieve data efficiently.
Users → DBMS → Database
The DBMS acts as a bridge between users and stored data.
Features of DBMS
- Data Storage
- Data Retrieval
- Data Security
- Backup and Recovery
- Multi-user Access
- Data Consistency
What is RDBMS?
RDBMS stands for Relational Database Management System. It stores data in tables consisting of rows and columns.
| Student_ID | Name | City |
|---|---|---|
| 1 | Rahul | Delhi |
| 2 | Amit | Mumbai |
Relationships between tables are created using keys.
DBMS vs RDBMS
| Feature | DBMS | RDBMS |
|---|---|---|
| Storage | Files / Structures | Tables |
| Relationships | Limited | Supported |
| Normalization | Not Mandatory | Supported |
| Large Applications | Less Suitable | Highly Suitable |
| Examples | Legacy Systems | MySQL, PostgreSQL |
Popular RDBMS Software
- MySQL
- PostgreSQL
- MariaDB
- Oracle Database
- Microsoft SQL Server
- SQLite
Why RDBMS Became Popular
- Structured storage
- Fast querying using SQL
- Relationships between tables
- Data integrity
- Scalability
Real World Examples
- Banking systems
- E-commerce platforms
- Hospital management systems
- University portals
- Inventory management software
Practice Exercises
- Define DBMS.
- Define RDBMS.
- List three DBMS features.
- Give five examples of RDBMS software.
- Explain one advantage of RDBMS over DBMS.
Quiz
1. What does DBMS stand for?
2. What does RDBMS stand for?
3. Which stores data in tables?
4. Name two popular RDBMS systems.
5. Which language is commonly used with RDBMS?
Summary
- DBMS manages data storage and retrieval.
- RDBMS is a type of DBMS that stores data in related tables.
- RDBMS supports relationships using keys.
- Most modern applications use relational databases.
- SQL is the standard language for interacting with RDBMS systems.