Chapter 7 Flashcards

1
Q

What is normalization?

A

Process of validating data models to minimize data redundancies.

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

What is partial dependence?

A

A non-key attribute depends on only a part of the candidate key, not the entire key.

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

Study the dependency diagram.

A

YouTube

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

What is transitive dependence?

A

When one attribute depends on another, which depends on a third, creating an indirect dependency.

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