Section outline

    • week 6 Book

      Teaching and Learning Methods to be Employed

      1.    Lecture with step-by-step normalisation worked examples

      2.    Normalisation workshop — students normalise a given unnormalised table

      3.    Collection of Assignment 2

      4.    Discussion: Denormalisation trade-offs in real systems

       

      Learning Outcomes / Objectives

      By the end of this week, students should be able to:

      1.    Define functional dependency and identify FDs from a given relation.

      2.    Explain update, insertion, and deletion anomalies.

      3.    Apply First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).

      4.    Explain Boyce-Codd Normal Form (BCNF).

      5.    Describe the impact of normalisation on database efficiency.

       

    • Assignment 3
      Opens: Wednesday, 8 July 2026, 12:00 AM
      Not available unless: The activity Course Outline is marked complete
    • Course Discussion Forum
      Due: Wednesday, 8 July 2026, 8:14 PM