Day 1: ER Modeling, Relational Model & Normalization
Execute an SQL or MongoDB query to see live result tables or documents.
SQL Logical Query Execution Pipeline Simulator
Step through the database engine's internal evaluation pipeline on a live sample query to understand why clauses execute in this sequence and why column aliases work in ORDER BY but fail in WHERE.
Three-Valued Logic (3VL) Interactive Calculator
In SQL, comparisons with NULL evaluate to UNKNOWN. Test boolean logic rules below and see why WHERE clauses reject UNKNOWN.
Interactive 3VL Expression Tester
Complete 3VL Truth Tables
Relational Joins & Set Venn Explorer
Select any join operation to inspect its relational algebra formula, Venn diagram mapping, and live sample record inclusion behavior.
Normalization Assistant & Candidate Key Calculator
Input a relational schema and a set of functional dependencies to compute attribute closures, candidate keys, and step-by-step normal form checks (1NF, 2NF, 3NF, BCNF).
Relation & Functional Dependencies
Analysis Results
Click "Analyze Normal Form" to evaluate candidate keys and normal form compliance.
DBMS Timed Examination Simulation
Test your knowledge under authentic exam conditions. Select an examination drill below:
15-Minute Rapid Drill
15 high-yield mixed questions. Ideal for rapid revision before the exam.
45-Minute University Exam
40 comprehensive questions balanced across all 5 Days of the syllabus.
60-Minute Hardcore Exam
50 advanced questions focusing on tricky traps, 3VL anomalies, and complex subqueries.