💡 What is RDBMS?
RDBMS stands for Relational Database Management System.
It is a software system used to create, manage, and interact with relational databases — where data is stored in tables (relations) with rows and columns.
📌 Key Concepts of RDBMS:
Term | Meaning |
|---|---|
📘 Relation | A table in the database |
📌 Attribute | A column (field) in the table |
📄 Tuple | A row (record) in the table |
🔑 Primary Key | Uniquely identifies each row in a table |
🔗 Foreign Key | Links two tables (used to represent relationships between tables) |
✅ Examples of Popular RDBMS Software:
🐬 MySQL
🐘 PostgreSQL
🧱 Oracle Database
💼 Microsoft SQL Server
💻 SQLite
📊 Why Use RDBMS?
✅ Data Integrity using keys and constraints
🔐 Security with user roles and permissions
🔄 Data Consistency through transactions
🔎 Efficient Querying using SQL (Structured Query Language)
🧩 Data Relationships maintained through foreign keys
💡 Real-Life Analogy:
Imagine a school register:
Each page = a table (relation)
Each row = a student's details (tuple)
Each column = specific info like name, age, class (attributes)
The Student ID = primary key
A reference to teacher ID = foreign key