Database Design Simulator

Relational databases organize information into tables linked by keys: a primary key uniquely identifies each row, and a foreign key in one table references the primary key of another. This simulator renders three linked tables — Customers, Orders and Products — as 3D platforms of colored cubes, one cube per stored value. Raising the normal form (1NF to 3NF) removes redundant, duplicated attributes from the Orders table and replaces them with clean foreign-key references, mirroring how real schema normalization eliminates transitive dependencies. Toggle a primary-key index and run a query to compare a linear table scan against an indexed lookup as the row count grows.