Question: Q 7 . Consider the relation R = { A , B , C , D , E , F , G , H ,

Q7. Consider the relation R={A,B,C,D,E,F,G,H,I,J,K,L,M,N} and the set of functional
dependencies ,
{D}{G,H}.
(a)(2%) What is the key for R?
(b)(6%) Decompose R into 2NF, then 3NF relations.Consider the relation R ={A, B, C, D, E, F, G, H, I, J, K, L, M, N} and the set of functional dependencies F ={{A, B, C}->{L},{B}->{D, E, F},{A, C}->{M, N},{D, E}->{I, J, K},
{D}->{G, H}}.
(a)(2%) What is the key for R?
(b)(6%) Decompose R into 2NF, then 3NF relations
 Q7. Consider the relation R={A,B,C,D,E,F,G,H,I,J,K,L,M,N} and the set of functional dependencies

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!