.BZU. | 13-06-2011 01:05 PM | Chapter 14 Advanced Normalization Transparencies by Carolyn E. Begg, Thomas Connolly 1 Attachment(s) Chapter 14 Advanced Normalization Transparencies by Carolyn E. Begg, Thomas Connolly http://bzupages.com/attachment.php?a...1&d=1307948445 - How inference rules can identify a set of all functional dependencies for a relation.
- How Inference rules called Armstrong’s axioms can identify a minimal set of useful functional dependencies from the set of all functional dependencies for a relation.
- Normal forms that go beyond Third Normal Form (3NF), which includes Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), and Fifth Normal Form (5NF).
- How to identify Boyce–Codd Normal Form (BCNF).
- How to represent attributes shown on a report as BCNF relations using normalization.
- Concept of multi-valued dependencies and Fourth Normal Form (4NF).
- The problems associated with relations that break the rules of 4NF.
- How to create 4NF relations from a relation, which breaks the rules of to 4NF.
- Concept of join dependency and Fifth Normal Form (5NF).
- The problems associated with relations that break the rules of 5NF.
- How to create 5NF relations from a relation, which breaks the rules of 5NF.
|