Question: table [ [ COLA , COLB,COLC,COLD,COLE,COLF ] , [ W _ , 1 , 2 , 3 , ST , 5 _ , R

\table[[COLA,COLB,COLC,COLD,COLE,COLF],[W_,1,2,3,ST,5_,R,3],[W_,2,3,ST,6_,G,5],[x_,3,4,5,VG,7_,B,3],[x_,1,2,3,4,5,VG,6_,G,5],[Y_,2,5,NT,5_,R,3],[Z_,3,PT,7_,B,3]]
3.What is the normal form of the table, if we remove COLB?
0NF
1NF
2NF
3NF
6.How many tables after resolving this table to 1NF?
1
2
3
4
7.How many tables in the model after resolving this table to 1NF then 2NF?
3
4
5
9.Which column is not key dependent?
COLC
COLE
COLF
COLB
10. Which column has a partial dependency?
COLC
COLE
COLF
All of the above
 \table[[COLA,COLB,COLC,COLD,COLE,COLF],[W_,1,2,3,ST,5_,R,3],[W_,2,3,ST,6_,G,5],[x_,3,4,5,VG,7_,B,3],[x_,1,2,3,4,5,VG,6_,G,5],[Y_,2,5,NT,5_,R,3],[Z_,3,PT,7_,B,3]] 3.What is the normal form of the table, if we

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!