Question: ) ( Consider a relation R ( a , b , c , d , e , f , g , h ) with functional

)(
Consider a relation R(a,b,c,d,e,f,g,h) with functional dependencies as given below:
abc
de1
gfh
chd
Consider the following statements about relation R.
The candidate keys of relation R are {a,b,e,g,d},{a,b,e,g,f} and {a,b,e,g,h}.
2 The cancidate keve of given relation are {a,b,c} and {a,b,d,e,f,g,h}.
The relations after normalizing to second normal form is R1(a,b,e,g,d),R2(a,b,e,g,f) and , e, g, h).
The relations after normalizing to second normal form is R1(a,b,c) and R2(a,b,d,e,f,g,h)
Which of the following are correct?
 )( Consider a relation R(a,b,c,d,e,f,g,h) with functional dependencies as given below:

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!