← Home

RDBMS Lab · CSC2131

Lab Materials

Open any lab below directly in your browser.

Lab 00 — Syllabus & Evaluation Hand-out
Course structure, evaluation breakdown, and the full lab schedule.
Lab 01 — E-R Diagrams
Entity-Relationship notation, worked examples, and mapping ER diagrams to relational tables.
Lab 02 — Introduction to SQL
Relational database technology and the anatomy of a SQL statement.
Lab 03 — DDL
Creating tables, data types, and modifying a table.
Lab 04 — Constraints
NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK — and managing constraints on live tables.
Lab 05 — DML
INSERT, UPDATE, DELETE, DEFAULT values, and the MySQL upsert equivalent.
Lab 06 — SELECT and WHERE
Column projection, DISTINCT, limiting rows, comparison operators, BETWEEN/IN/LIKE, NULL handling.
Lab 07 — ORDER BY & Functions
Operator precedence, sorting rows, group functions, GROUP BY and HAVING.
Lab 08 — JOINs
Inner, self, and outer joins; equijoin vs. cartesian product; non-equijoins.
Lab 09 — Subqueries
Single-row and multi-row subqueries, IN/ANY/ALL/EXISTS, correlated subqueries.
Lab 10 — Views
Creating views, updatable vs. non-updatable views, and managing views.
Lab 11 — Privileges (DCL)
System vs. object privileges, GRANT and REVOKE, controlling user access.
Lab 12 — TCL, Triggers & Stored Procedures
COMMIT, ROLLBACK, SAVEPOINT, triggers, and stored procedures.
Lab Evaluation opens on lab day
Thirty practical SQL scenarios on Labs 1–7 in two batches. Question sets are released here on the day of the lab.
Lab End-Term Exam opens on exam day
Thirty practical SQL sets on Labs 1–11 in two batches, with write-up questions. Question sets are released here on the day of the exam.