Relational Database Design and Normalisation
Computing · JC 2 · Databases and Data Management · 2.º Período

Relational Database Design and Normalisation

Students will design Entity-Relationship (ER) diagrams and normalise databases up to the Third Normal Form (3NF). This ensures data integrity and reduces redundancy.

MOE Syllabus OutcomesMOE H2 Computing (Syllabus 9569), Section 3: Data and Information - 3.2 Databases (Relational Database Concepts)MOE H2 Computing (Syllabus 9569), Section 3: Data and Information - 3.2 Databases (Entity-Relationship Modelling and Normalisation)

About This Topic

Students will design Entity-Relationship (ER) diagrams and normalise databases up to the Third Normal Form (3NF). This ensures data integrity and reduces redundancy.

Key Questions

  1. Why is data redundancy problematic in a database?
  2. How do primary and foreign keys establish relationships?
  3. What are the steps to achieve Third Normal Form (3NF)?

Active Learning Ideas

See all activities→

Activities & Teaching Strategies

See all activities

More in Databases and Data Management

Structured Query Language (SQL)

Practical application of SQL for Data Definition Language (DDL) and Data Manipulation Language (DML). Students will write complex queries involving joins and aggregations.

8 methodologies

NoSQL and Alternative Data Stores

An introduction to non-relational databases, focusing on document-oriented stores like MongoDB. Students will compare NoSQL with traditional SQL databases.

8 methodologies

Edited by Adriana Perusin, Editor-in-Chief, Flip Education