Covers core relational database concepts — including tables, primary keys, data redundancy, and anomalies — alongside normalization principles (1NF through BCNF) and functional dependencies, serving as the structural outline that guides learners and instructors through the sequence of topics in the module.
Module Artifacts
This reading introduces database normalization as a step-by-step process for structuring tables and columns to eliminate redundancy and inconsistency, providing learners with the conceptual foundation and rationale before they study specific normal forms.
This reading explains the core concepts of relational databases — how data is organized into tables with rows and columns, how tables relate to one another, and why this structured approach is foundational to software development and data management.
This reading describes the practical consequences of poorly designed database tables — including wasted storage, increased maintenance burden, and data integrity problems — helping learners recognize why thoughtful schema design matters before studying normalization techniques.
This reading defines and illustrates insertion anomalies, explaining how poorly structured tables can make it impossible or awkward to add valid data without fabricating unrelated information, so learners can identify this design flaw in real schemas.
This reading defines and illustrates update anomalies, showing learners how denormalized tables force multiple row updates to reflect a single real-world change and how failing to do so creates data inconsistencies.
This reading defines and illustrates deletion anomalies, explaining how removing a single row in a poorly designed table can unintentionally destroy unrelated data, helping learners understand a key motivation for normalization.
This reading introduces database normalization as a step-by-step process for structuring tables and columns to eliminate redundancy and inconsistency, providing learners with the conceptual foundation and rationale before they study specific normal forms.
This text-based HTML resource explains and contrasts the three types of data anomalies — insertion, deletion, and update — that arise in poorly structured database schemas, using example problems so learners can practice identifying and differentiating each anomaly type in preparation for analyzing real schema designs.
This reading covers how to identify common flaws in relational table design — including repeating groups, mixed entity types, and partial-key dependencies — and presents worked example problems that learners use to practice diagnosing these issues in a given schema as preparation for the module's analysis-level outcome.
This interactive drag-and-drop activity asks learners to match database anomaly types (such as insertion, deletion, and update anomalies) to real-world scenarios that illustrate them, providing immediate feedback on correct and incorrect matches so learners can self-assess their understanding of how and when each anomaly occurs in relational databases.