| Term | Definition |
|---|
| Best Normal Form | Knowingly violates one or more rules of normalization |
| Domain/Key Normal Form | Table has no anomalies |
| Boyce-Codd Normal Form | All determinants are candidate keys |
| Compound Key | A Key composed of more than one attribute |
| Fourth Normal Form | no multiple multi values dependencies |
| Third Normal Form | No Transitive Dependencies |
| Candidate Key | None of the above |
| Second Normal Form | No partial functional-Dependencies |
| First Normal Form | All key attributes defined, attributes depend on key and no repeating groups. |
| Multi-Valued Dependency | Dependency where determinant determines a list of values for another attribute( a determines several d's all with dif values) |
| Recursive Dependency | does not exist |
| Determinant | Attribute that determines the value of another attribute |
| Primary key | Candidate key that has been chosen |
| Transitive dependency | Functional dependency depending on only non key attributes |
| Functional Dependency | Knowing the value of one attribute you can determine the value of another attribute |
Combine with other sets
Share on Facebook
Share on MySpace