Normalization Flashcards
1
Q
Functional dependency
A
the value of one particular attribute associated with a specific single value of another attribute.
2
Q
the value of one particular attribute associated with a specific single value of another attribute.
A
Functional dependency
3
Q
Transitive dependency -
A
.
4
Q
.
A
Transitive dependency -
5
Q
Decomposition -
A
.
6
Q
.
A
Decomposition -
7
Q
Normalization
A
methodology for organizing attributes into tables
8
Q
Unnormalized
A
.
9
Q
First Normalization -
A
The attributes are all single valued
10
Q
Second Normalization -
A
.
11
Q
Third Normalization -
A
The tables are completely free of data redundancy. primary key matching?