### Multiple Choice Questions on Normalization

Multiple Choice Questions on Normalization

1. A table is in BCNF if it is in 3NF and if every determinant is a ............... key.

A) dependent
B) normal
C) candidate
D) Both B & C

2. The ....................... introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.

A) Third
B) Fourth
C) Fifth
D) Sixth

3. Below table is in First Normal Form:

Person Favourite Colour
Ram Purple
Ram Red
John Green
John Yellow
John Red

A) True
B) False

4. In Case of Database normalization the order of the rows and columns is immaterial;

A) True
B) False

5. A table is in 3NF if it is in 2NF and if it has no ......................

A) functional dependencies
B) transitive dependencies
C) trivial functional dependency
D) multivalued dependencies

6. Every constraint on the table is a logical consequence of the table's ......

A) Fourth normal form
B) Fifth normal form
C) Domain/key normal form
D) None of above

7. A ................. is an indirect functional dependency, one in which X→Z only by virtue of X→Y and Y→Z.

A) multivalued dependencies
B) join dependency
C) trivial functional dependency
D) transitive dependencies

8. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the .......... key.

A) candidate
B) join
C) functional
D) None of above

9. In order to convert the Main table to 2nd normal form we have split it into two tables Split_1 and Split_2. Split_1 and Split_2 are now in 2nd normal form:

Main Table
ID Another_ID City
1 1 LA
1 3 SF
2 1 LA
3 2 NY
4 3 SF

Split_1
ID Another_ID
1 1
1 3
2 1
3 2
4 3

Split_2
Another_ID City
1 LA
2 NY
3 SF

A) True
B) False

10. Anomalies are avoided by splitting the offending relation into multiple relations, is also known as ....................

A) Accupressure
B) Decomposition
C) Precomposition
D) Both b & c