COMP3311 Week 09 Lecture
Assignment 3
Ass 3: Task A
Ass 3: Task B
Ass 3: Task C
Ass 3: Framework
Relational Design Theory
Relational Design Theory
Relational Design and Redundancy
Database Design (revisited)
Notation/Terminology
Functional Dependency
Exercise: Functional Dependencies (1)
Exercise: Functional Dependencies (2)
Functional Dependency
Inference Rules
Closures
Exercise: Computing Keys
Normalization
Normal Forms
Relation Decomposition
Schema Design
Boyce-Codd Normal Form
BCNF Decomposition
Exercise: BCNF Decomposition (1)
Exercise: BCNF Decomposition (2)
Third Normal Form
Exercise: 3NF Decomposition (1)
Exercise: 3NF Decomposition (2)
Database Design Methodology
Relational Algebra
Relational Algebra
Notation
Describing RA Operations
Example Database #1
Example Database #2
Example Database #3
Rename
Selection
Projection
Exercise: RA Select+Project
Union
Intersection
Difference
Exercise: RA Set Operations
Produced: 14 May 2009