SistematikoPH
Learning Hub
Student Portal
Information Management and Databases

Design a Normalized Enrollment Database

Transform a repeated enrollment spreadsheet into related student, course, section, and enrollment tables.

Intermediate 75 minutes John IT 121 ยท Database Management Systems Created Aug 31, 2026 5:55 AM

Explanation

Normalization organizes data to reduce unnecessary repetition and update anomalies. A reliable design separates entities, assigns stable primary keys, and connects records through foreign keys.

Students examine a deliberately messy enrollment sheet, identify functional dependencies, and redesign it into related tables. The class tests whether common inserts, updates, and deletions remain consistent.

Learning activities

  1. Mark repeating data in a sample enrollment sheet.
  2. Identify entities, keys, and relationships.
  3. Create a schema approaching third normal form.

Code example

sql
CREATE TABLE enrollments (
  student_id BIGINT NOT NULL,
  section_id BIGINT NOT NULL,
  enrolled_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (student_id, section_id)
);

Knowledge check

1. Why is repeated course data risky?

  • It creates update anomalies
  • It makes keys shorter
  • It prevents all queries
Show answer

It creates update anomalies

References