DBMS and Normalization Flashcards

1
Q

When building a database from an existing set of tables, we still need to consider normalization principles. T/F

A

True

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

Multivalued dependencies should ______ be eliminated.

A

Always

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

One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data. T/F

A

True

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

We can eliminate modification anomalies with proper normalization that results in tables in BCNF. T/F

A

True

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