Normalization Flashcards

1
Q

Functional dependency

A

the value of one particular attribute associated with a specific single value of another attribute.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

the value of one particular attribute associated with a specific single value of another attribute.

A

Functional dependency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Transitive dependency -

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

.

A

Transitive dependency -

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Decomposition -

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

.

A

Decomposition -

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Normalization

A

methodology for organizing attributes into tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Unnormalized

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

First Normalization -

A

The attributes are all single valued

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Second Normalization -

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Third Normalization -

A

The tables are completely free of data redundancy. primary key matching?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly