Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. If a relational database table is in Boyce-Codd normal form, it is also in a.

ID: 3825569 • Letter: 1

Question


1.   If a relational database table is in Boyce-Codd normal form, it is also in

a.   the first normal form.
b.   the second normal form.
c.   the third normal form.
d.   all of a., b., and c.

--------------------------------------------------------------------------------------------------------
2.   If a relational database table is in the first normal form, it is also in

a.   the non-first normal form.
b.   the second normal form.
c.   the third normal form.
d.   the Boyce-Codd normal form.

--------------------------------------------------------------------------------------------------------
3.   If a relational database table is in the second normal form, it is also in

a.   the first normal form.
b.   the third normal form.
c.   the Boyce-Codd normal form
d.   all of a., b., and c.

---------------------------------------------------------------------------------------------------------
4.   If a relational database table is in the third normal form, it is also in

a.   the first normal form.
b.   the second normal form.
c.   the Boyce-Codd normal form.
d.   both a. and b.

Explanation / Answer

1)Ans) d

We can say that the relation is in boyce codd normal form ,only if it is in first ,second and third normal forms.

2)Ans) a

3)Ans) a

We can say that the relation is in second normal form ,only if it is in first normal forms.

4)Ans) d

We can say that the relation is in second normal form ,only if it is in first and second normal forms.