Understanding Relational Database Management Systems (RDBMS): Keys, Normalization, and SQL Essentials

A Relational Database Management System (RDBMS) is a software system that enables users to create, maintain, query, and administer relational databases. Unlike flat file systems where data is stored in isolated text or spreadsheet files, an RDBMS organizes data into structured tables (relations) consisting of rows (tuples/records) and columns (attributes/fields). In the Sindh Board and Intermediate ICS curriculum, understanding relational architecture is mandatory for developing robust software solutions.

Keys are constraints used to establish relationships and ensure entity integrity:

• Primary Key (PK): A column (or group of columns) that uniquely identifies each record in a table. It cannot contain NULL values. Example: Student_ID or Roll_Number at Margaret’s Secondary School.
• Foreign Key (FK): A column in one table that references the Primary Key of another table, ensuring referential integrity across related data. Example: Class_ID in the Student table referencing the Master Class table.
• Candidate Key: Any attribute that qualifies to become a primary key due to uniqueness.
• Composite Key: A primary key formed by combining two or more attributes when a single column cannot uniquely identify a row.

Normalization is the systematic process of organizing data in a database to reduce data redundancy and eliminate insertion, update, and deletion anomalies.

1. First Normal Form (1NF):
   
   Each table cell must contain a single (atomic) value, and each record must be unique with no repeating groups.
2. Second Normal Form (2NF):
   
   The table must already be in 1NF, and all non-key attributes must be fully functionally dependent on the entire primary key (no partial dependency on composite keys).
3. Third Normal Form (3NF):
   
   The table must be in 2NF, and there must be no transitive dependencies (non-key attributes should not depend on other non-key attributes).

Structured Query Language (SQL) is categorized into distinct sub-languages:

• DDL (Data Definition Language):
  
  CREATE TABLE Students (StudentID INT PRIMARY KEY, FullName VARCHAR(100), Grade INT);
• DML (Data Manipulation Language):
  
  INSERT INTO Students VALUES (101, 'Ahmed Khan', 10);

UPDATE Students SET Grade = 11 WHERE StudentID = 101;
• DQL (Data Query Language):
  
  SELECT FullName, Grade FROM Students WHERE Grade >= 9 ORDER BY FullName ASC;