Students who complete this unit will demonstrate that they can:
- Determine the functional dependency between two or more
attributes that are a subset of a relation.
- Connect constraints expressed as primary key and foreign key,
with functional dependencies.
- Determine whether a set of attributes form a superkey and/or
candidate key for a relation with given functional dependencies.
- Evaluate a proposed decomposition, to say whether it has
lossless-join and dependency-preservation.
- Describe the properties of BCNF, 4NF and, perhaps, PJNF and 5NF.
- Explain the impact of normalization on the efficiency of
database operations especially query optimization.
- Describe what is a multi-valued dependency and what type of
constraints it specifies.