Introduction to Relational Database Management Systems (RDBMS)

Core Components of RDBMS

Understanding the core components helps grasp how RDBMS organizes and enforces data rules.

Relationships in RDBMS

RDBMSs allow tables to relate to each other, reflecting real-world connections between data entities.

• One-to-One: Each record in Table A relates to one record in Table B.
• One-to-Many: One record in Table A relates to multiple records in Table B.
• Many-to-Many: Records in Table A relate to multiple records in Table B and vice versa, often implemented via a junction table.

Role of SQL in RDBMS

SQL (Structured Query Language) is the standard language used to interact with RDBMS.

It allows users to create, read, update, and delete data within the database.

• Data Definition Language (DDL) commands create and modify database structures.
• Data Manipulation Language (DML) commands manage data within tables.
• Data Control Language (DCL) commands control access and permissions.