Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
13 Cards in this Set
- Front
- Back
|
Normalization
|
identifying and removing problems called updated anomalies
|
|
|
A Functionally determines B
|
if each A value is associated with a b value
|
|
|
Primary key
|
functionally determines all other columns
|
|
|
candidate keys
|
columns which functionally determine all other columns
|
|
|
Alternate key
|
candidate key that was not picked as primary key
|
|
|
repeating groups
|
multiple entries for a single record
|
|
|
1NF
|
no repeating groups
|
|
|
2NF
|
no non key field is partially dependent on primary key
|
|
|
Dependency diagram
|
shows partial and normal dependencies using arrows
|
|
|
Partial dependency
|
dependent only part of the primary key
|
|
|
Determinant
|
column that determines another column
|
|
|
3NF
|
only candidate keys are determinants
|
|
|
Multivalued dependency
|
A multidetermines B, If each A value is associated with a collection of B values.
|
