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;
10 Cards in this Set
- Front
- Back
|
Functional dependence
|
Describing which fields are determined by which other fields
|
|
|
Primary key rules
|
1) All columns in R are functionally dependent on A
2) No sub-collection of the columns in A also has property 1 |
|
|
candidate key
|
column or collection of columns on which all columns are functionally dependent
|
|
|
Alternate keys
|
Keys that are candidates for being a primary key, but are not chosen
|
|
|
repeating group
|
multiple entries for a single record
|
|
|
unnormalized relation
|
contains a repeating group
|
|
|
first normal form
|
does not contain repeating groups
|
|
|
nonkey column
|
not part of the primary key
|
|
|
partial dependency
|
dependencies only on part of the primary key, not the entire thing
|
|
|
second normal form
|
first normal form, no partial dependencies
|
