Question: Q 5 . ( 8 % ) Consider the relation R ( A , B , C , D , E , F , G

Q5.(8%) Consider the relation R(A,B,C,D,E,F,G,H,I,J,K). A is the primary key. (B,C) forms a
candidate key. The following functional dependencies exist among the attributes of the relation:
A{A,B,C,D,E,F,G,H};{B,C}{A,B,C,D,E,F,G,H};,EF;C{G,H};G{I,J,K}
Transform this relation into a set of 1NF,2NF,3NF relations. {I, J, K}
Transform this relation into a set of 1NF,2NF,3NF relations.
 Q5.(8%) Consider the relation R(A,B,C,D,E,F,G,H,I,J,K). A is the primary key. (B,C)

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!