Normalization Flashcards

1
Q

How many relationship types exist?

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

How UNIQUE constraint is used?

A

It prevents the insertion of duplicate values into a column or combination of columns.

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

Advantages of Database Normalization

A
  1. Improve data integrity
  2. Reduce data redundancy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly