Skip to main content
← Lab

Database normalization lab / NORMALIZATION

Learn
中文 ↗

RELATIONAL DESIGN / 01

One table. How many repeated facts?

Change one record and watch a repeated fact become inconsistent.

ENROLLMENT / 01

Enrollment records

4 records
Enrollment records
SStudent IDNNameDDept. IDMDept. nameCCourse IDGGrade
S01LinD01ComputingC0192
S01LinD01ComputingC0288
S02ChenD01ComputingC0185
S03ZhouD02MathematicsC0390

Assumptions: S uniquely identifies a student; each student belongs to one department; each student has one grade per course. Retakes across terms are outside this model.

Give each fact its own place

A student’s department and a student’s enrollment are different facts. That is where decomposition begins.

Preparing interactions…