Can I read Canonical Covers and Normal Forms Guide on EtoBox?
Canonical Covers and Normal Forms Guide by Biswamitra Rath is a document available to read on EtoBox.
What is Canonical Covers and Normal Forms Guide about?
The document discusses canonical covers and normal forms for database relations. A canonical cover is a minimal set of functional dependencies (FDs) that is equivalent to the original set of FDs. It is computed in three steps: (1) putting FDs in single-attribute form, (2) minimizing left sides of FDs, and (3) removing redundant FDs. Normal forms like 1NF, 2NF, 3NF and BCNF impose restrictions to avoid redundancy. Higher normal forms have more restrictive requirements. The document gives examples to explain
- Author
- Biswamitra Rath
- Language
- EN