Unformatted text preview: -one attribute that determines the other attributes = primary key Determinants-the attribute (or attributes) that we use as the starting point is called a determinant. Candidate Key-A candidate key of a relation will functionally determine all other attributes in the row. -A primary key of a relation will functionally determine all other attributes in the row. Normalization-a process of analyzing a relation to ensure that it is well formed-if a relation is normalized, rows can be inserted, deleted, or modified without creating update anomalies-a relation is considered normalized when : EVERY determinant is a candidate key. This is Boyce-Codd Normal Form (BCNF)...
View Full Document
- Fall '08
- Relational model, primary key, Database normalization