Lists the lecture topics covered in the module — spanning normalization basics, data redundancy, and data integrity through 1NF, 2NF, and 3NF concepts — serving as a navigation guide for learners to see what will be taught and for instructors to verify curricular coverage.
A slide deck covering database normalization concepts including data redundancy, data integrity, and the rules of 1NF, 2NF, and 3NF, used by instructors to deliver or by learners to review the module's core lecture content.
A reading that introduces database normalization by explaining why poor database design causes problems and how normalization systematically reduces redundancy and improves data integrity, used by learners as a conceptual foundation before studying individual normal forms.
A reading that explains First Normal Form in depth — covering atomicity, repeating groups, and primary key requirements — used by learners to understand the foundational rule that all higher normal forms depend on.
A reading that explains Second Normal Form by defining partial dependencies and showing how non-key columns must depend on the whole primary key rather than part of it, used by learners to identify and eliminate partial dependencies in composite-key tables.
A reading that explains Third Normal Form by defining transitive dependencies — where a non-key column is determined by another non-key column rather than directly by the primary key — used by learners to identify and resolve those dependencies after achieving 2NF.
A reading that walks learners through a complete, sequential end-to-end worked example of applying 1NF, 2NF, and 3NF together starting from a denormalized real-world table, used by learners to practice the full normalization process as an integrated skill.
A duplicate of the end-to-end normalization practice reading covering the sequential application of 1NF, 2NF, and 3NF on a denormalized table, which appears to be a repeated artifact of the same content as the Topic Detail version above.
A drag-and-drop interactive activity where learners evaluate unnormalized table scenarios and place answer tokens on a number line to demonstrate their understanding of First Normal Form (1NF) transformation concepts across five scored questions.
An interactive drag-and-sort activity where learners classify attributes from composite-key tables into the correct bins based on whether they exhibit partial dependencies, reinforcing the concept of identifying 2NF violations.