An interactive HTML exercise using a DOG_REGISTRY sample table in which learners judge each candidate functional dependency (e.g., dog ID, breed, owner, vet attributes) as valid, invalid, or partially valid, with hints available for self-paced practice.
Topics
This module covers 5 topics. Open a topic to see its subtopics.
Module Content
21 items.
-
-
An interactive HTML exercise built on a university course registration dataset where learners classify proposed functional dependencies among student, course, instructor, and enrollment attributes as valid, invalid, or partially valid using the sample rows as evidence.
-
A reading that explains how functional dependencies drive schema design, treating tables as logical consequences of real-world business rules rather than ad hoc inventions, for learners preparing to decompose and normalize schemas.
-
An interactive design-board assignment (Assignment 3) in which learners act as a consultant, taking four draft entities, a director's interview, and a set of functional dependencies and reorganizing them into a database design that satisfies all constraints, with undo/redo and a finish-check.
-
A worked exercise handout based on a university course registration table that asks learners to identify which attribute pairs exhibit functional dependencies and which do not, for in-class or homework practice.
-
A set of example problems with solutions on applying Armstrong's axioms — reflexivity, augmentation, and transitivity — to derive new functional dependencies from a given FD set, aligned to the module's 'Apply' learning outcome.
-
A narrative lesson tracing the relational model back to Codd's 1970 paper and developing its mathematical basis — sets, domains, Cartesian products, and the formal definition of a relation — as background reading for the module.
-
A lesson introducing the three core structures of the relational model — relations as tables, tuples as rows, and attributes as columns — and how they map onto real systems such as PostgreSQL, MySQL, and Oracle.
-
A lesson defining functional dependency as a constraint between attribute sets reflecting real-world rules, introducing X → Y notation and terminology as the prerequisite for later normalization work.
-
A lesson that classifies functional dependencies — trivial versus nontrivial, full versus partial, and transitive — and explains the properties designers use when reasoning about dependency sets.
-
A second narrative lesson on using functional dependencies as the blueprint for schema design, showing how each attribute's placement follows from the dependencies that govern it.
-
A condensed text version of the mathematical foundations lesson, defining domains, tuples, relation schemas, and relations as sets, intended as a quick-reference reading before studying keys and normalization.
-
A condensed text lesson defining a relation as a set of tuples over fixed attributes, with each attribute tied to a domain, and relating the formal definitions to the familiar table/row/column picture.
-
A concise reading defining functional dependencies formally (if two tuples agree on X they must agree on Y), introducing the determinant and reading X → Y, with illustrative examples.
-
A concise reading on classifying dependencies as trivial or nontrivial, partial or full, and transitive, giving learners the vocabulary to analyze an FD set formally.
-
A concise reading showing how dependencies such as StudentID → Advisor act as real-world statements that determine which tables to create and where each attribute belongs.
-
A single consolidated page combining all five module readings in sequence, giving learners one continuous document covering relational foundations through functional dependencies and design.
-
An interactive normalization lab in which learners decompose a client's flat spreadsheet into tables using stated business rules, then verify that the decomposition reconstructs the original data on join, with undo/redo and a finish-check.
-
This assignment presents a realistic university course registration dataset and asks students to classify a set of potential functional dependencies as Valid, Invalid, or Partially Valid, providing reasoned justifications for each decision. Students analyze relationships among attributes such as StudentID, CourseCode, InstructorID, and composite keys like (CourseCode, Semester). The exercise culminates in a formal written report submitted in Word or PDF format.
-
This interactive HTML tool allows students to work through functional dependency problems by splitting FD sets and proving derived dependencies step by step. It provides a structured, rule-checked environment where students can apply derivation rules and receive real-time feedback on whether their steps are valid. The interface includes scenario selection, a live rule checklist, and visual indicators for correct and incorrect reasoning.
-
An interactive HTML-based design board activity that presents relational schema concepts and functional dependency exercises in a structured, visual interface. The tool appears to include attribute chips, dependency relationship displays, and checklist-style criteria panels for hands-on schema analysis. Students likely drag, select, or organize schema components to complete guided tasks.