| Term | Definition |
|---|
| Functional Dependency | Knowing the value of one attribute you can determine the value of another attribute. |
| Transitive Dependency | Functional dependency involving only non-key attributes. |
| Primary Key | Candidate key selected for use. |
| Determinant | Attribute that determines the value of another attribute. |
| Multi-valued Dependency | Dependency where determinant determines a list of values. |
| Recursive Dependency | DOC MADE UP |
| First Normal Form | All key attributes defined, attributes depend on key and no repeating groups. |
| Second Normal Form | No partial functional-dependencies. |
| Third Normal Form | No Transitive Dependencies. |
| Fourth Normal Form | No multiple multi-valued dependencies. |
| Compound Key | A Key composed of more than one attribute. |
| Boyce-Codd Normal Form | All determinants are candidate keys. |
| Domain/Key Normal Form | Table has no anomalies. |
| Best Normal Form | Knowingly violates one or more rules of normalization. |
Combine with other sets
Share on Facebook
Share on MySpace