Database Normalization (1NF, 2NF, 3NF) β€” Free SQL Worked Example

Free university learning sample Β· Quality Assignment Help

Database design and SQL normalization: original worked example

A complete fictional university enrolment example showing how to identify functional dependencies, move through 1NF, 2NF and 3NF, write a relational schema with foreign keys, and query it with a SQL JOIN.

Download the free sample PDF

What’s inside the downloadable learning sample?

A complete fictional university enrolment example showing how to identify functional dependencies, move through 1NF, 2NF and 3NF, write a relational schema with foreign keys, and query it with a SQL JOIN.

Learning outcome: follow the reasoning, adapt the method to another small dataset or system, and check your answers against the worked example rather than copying it as coursework.

A question students often ask

Why does Enrollment need a composite key?

Under the sample rules, one student-module pair identifies one enrolment. If repeat registrations are allowed, the design needs an additional identifier or semester attribute.

Continue learning

Read the related topic guide on Quality Assignment Help. You can also consult PostgreSQL’s official SQL tutorial for additional official examples.

Browse our free student tools and the full sample library.

Need individual feedback?

Students can request database schema and SQL project feedback. Our role is to explain methods, review your own attempts and guide independent learning.

Request academic tutoring

Original instructional example; not a completed assessed submission.

Trustpilot