Question: Consider a relation T ( Al , A 2 , A 3 , A 4 , A 5 , A 6 , A 7 )

Consider a relation T(Al, A2, A3, A4, A5, A6, A7)in which (A1,A2,A3) is the key, and the set of functional dependencies:(A1, A2,3)(A4, A5,6,7)(A1, A2)> A4A4> A5A6> A2Which of the following decompositions satisfies 3NF?I. TI(A1, A2, A3, A6, A7), T2(A1, A2, A4), T3(A4,A5)II. T1(A1, A6, A3, A7), T2(A1, A2, A4), T3(A6, A2), T4(A4, A5)(A) I only(B) II only(C) Both I and II(0) Neither I nor II

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!