RDBMS (Relational Database Management System)

What is RDBMS?

• RDBMS is a type of DBMS that stores in the form of related tables consisting of rows and columns.

• Relationship between tables are established using keys such as Primary Keys and Foreign Keys.

What is a Tables?

• A Table is a collection of related data organized into rows and columns.

What is a Rows?

• A Rows represents a single record in a table.

What is a Column?

• A Column represents a specific attribute or field or Multiple data types.

Features of RDBMS:

• Stores data in tables

• Uses rows and columns

• Supports Primary Keys and Foreign Keys

• Reduces data redundancy

• Maintains data integrity

• Supports SQL queries

Example of RDBMS

• PostgreSQL

• MySQL

• Oracle Database

• Microsoft SQL Server

• MariaDB

Why Use RDBMS?

• Organizes data efficiently

• Establishes relationships between tables

• Improve data consistency

• Supports complex queries using SQL

• Ensures data security and integrity

DBMS vs RDBMS

           DBMS                                      RDBMS

* Stores data files or tables          * Stores data in related tables
* Relationships may not exist          * Relationships using keys
* Small applications                   * Large applications
* Data redundancy can be higher        * Data redundancy is reduced
* Example: XML database, File system   * Example: PostgreSQL, MySQL