Question: A relation R (A, B, C, D, P, Z) is having two FDs F and G. Check if F = G. Demonstrate the steps involved
A relation R (A, B, C, D, P, Z) is having two FDs F and G. Check if F = G. Demonstrate the steps involved in finding the equivalence.
Set F =
A C
AC D
P AD
P Z
Set G
A CD
P AZ (5 marks)
a.A Relation R(P,Q,R,S,T) is decomposed into
R1(P, S)
R2(P,Q)
R3(Q,T)
R4(R,S,T)
R5 (P,T)
Check whether the decomposition is lossless join decomposition. Show all the steps clearly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
