Introduction to RDBMS:

• RDBMS (Relational Database Management System) is a software system that manages relational databases.
• Data is organized into tables (relations) consisting of rows (records) and columns (attributes).
• Ensures data integrity, consistency, and security.

Key Concepts:

• Table: Collection of related data organized in rows and columns.
• Row (Tuple): Single record in a table.
• Column (Attribute): Defines the type of data in a row.
• Primary Key: Unique identifier for each row.
• Foreign Key: Links two tables and maintains referential integrity.
• Schema: Structure that defines tables, fields, and relationships.

How RDBMS Works:

• Data Storage:

  • Data is stored in tables with defined data types.
  • Each table has a primary key to uniquely identify records.

• Data Retrieval (SQL):

  • SQL (Structured Query Language) is used to perform CRUD operations (Create, Read, Update, Delete).

  • Example Query:

    SELECT * FROM Customers WHERE Country = 'USA';
    

• Relationships:

  • Tables are connected via foreign keys.
  • Example: Orders table has a foreign key referencing the Customers table.

• Transactions:

  • Ensures ACID properties (Atomicity, Consistency, Isolation, Durability) for reliable operations.

4. Example:

Customers Table:

Orders Table: