Normalization Flashcards
1
Q
Normalization
A
Process for evaluating and correcting table structures to minimize data redundancies
2
Q
Denormalization
A
Produces a lower normal form to increase data performance
3
Q
Repeating Group
A
Group of multiple entries of the same type can exist for any single key attribute occurrence.
4
Q
Dependency Diagram
A
Bird’s eye view of the relationships among a table’s attributes.
5
Q
Determinant
A
Attribute whose value determines other values within a row
6
Q
Atomicity
A
Describes an attribute that cannot be further subdivided
7
Q
Granularity
A
Level of detail represented by the values stored in a table’s row
8
Q
Surrogate Key
A
Artificial PK introduced by the designer to simplify assignment of PKs to tables. Numeric and free of semantic content.
