Archtecture Flashcards
1
Q
A process of structuring relational database using normal forms is called
A
Normalization
2
Q
Types of normal forms
A
1st, 2nd, 3rd, Dr. Boyce, 4th, 5th and 6th
3rd and Dr. Boyce- the most commonly used
3
Q
Reverting a process of normalization is called
A
De- normalization
4
Q
When there are too many tables and normal forms it is called ——- and it affects the database ———
A
Over-normalization
Performance of the database
5
Q
First normal form is all about
A
The primary key
6
Q
Which normal form is partially dependent on the primary key
A
2nd
7
Q
Which normal form is not dependent on the primary key
A
3rd
8
Q
A
