MySQL RDBMS
MySQL as an RDBMS (Relational Database Management System)
MySQL is a Relational Database Management System (RDBMS), which means it stores data in a structured format using tables, and allows relationships between those tables. It uses SQL (Structured Query Language) to manage and manipulate the database.
What is an RDBMS?
An RDBMS (Relational Database Management System) is software used to create, manage, and operate relational databases. It organizes data in tables containing rows and columns, and relationships can be created using keys.
Example Table:
| ID | Name | Age | City |
|---|
Each row = a record
Each column = a field
Why MySQL is an RDBMS?
MySQL qualifies as an RDBMS because it:
- Stores data in multiple related tables
- Uses SQL for data manipulation
- Supports Primary Keys, Foreign Keys, and Constraints
- Ensures data integrity and relationships
Key Concepts in MySQL RDBMS
1. Database
A collection of tables and related data.
2. Table
A structured format to store data in rows and columns.
3. Row (Record)
A single data entry in a table.
4. Column (Field)
Defines the type of data stored (e.g., name, age).
Keys in MySQL RDBMS
| Key Type | Purpose |
|---|---|
| Primary Key | Uniquely identifies each record in a table |
| Foreign Key | Creates a relationship between two tables |
| Unique Key | Prevents duplicate values |
| Composite Key | Combination of two or more columns to uniquely identify a record |
Example:
Students Table
| student_id (PK) | name |
|---|---|
| 1 | Neha |
| 2 | Rahul |
Courses Table
| course_id | student_id (FK) | course_name |
|---|---|---|
| 101 | 1 | PHP |
| 102 | 2 | MySQL |
Here, student_id connects both tables → Relationship.
MySQL Supports ACID Properties
ACID ensures reliable and accurate transactions:
| Property | Meaning |
|---|---|
| A – Atomicity | Complete transaction success or failure |
| C – Consistency | Ensures valid and correct data |
| I – Isolation | Prevents transaction conflicts |
| D – Durability | Saves committed data permanently |
SQL Operations in RDBMS
| Category | Commands | Purpose |
|---|---|---|
| DDL (Data Definition Language) | CREATE, ALTER, DROP | Structure control |
| DML (Data Manipulation Language) | INSERT, UPDATE, DELETE | Modify data |
| DQL (Query Language) | SELECT | Retrieve data |
| DCL (Control Language) | GRANT, REVOKE | Permissions |
| TCL (Transaction Control) | COMMIT, ROLLBACK | Transaction management |
Advantages of MySQL RDBMS
Fast and reliable
Secure with user access control
Maintains data accuracy and integrity
Supports large multi-user applications
Backup and recovery support
Example Basic Commands
Summary
MySQL is a powerful Relational Database Management System that stores data in a structured table format and allows relationships using keys. It ensures data integrity, supports transactions, and is widely used in web applications, software systems, and enterprise-level solutions.
