Page 1 of 1
Question4: [15 points) Given the relation R(X,Y,Z,T,K,L) and F = {XY → ZL, YZ > XTK, XZ→ L} Is this relation in 3NF? Exp
Posted: Mon May 02, 2022 12:27 pm
by answerhappygod
- Question4 15 Points Given The Relation R X Y Z T K L And F Xy Zl Yz Xtk Xz L Is This Relation In 3nf Exp 1 (25.99 KiB) Viewed 34 times
Question4: [15 points) Given the relation R(X,Y,Z,T,K,L) and F = {XY → ZL, YZ > XTK, XZ→ L} Is this relation in 3NF? Explain why or why not. If not, decompose into smaller relations so that it satisfies 3NF. In case you decompose it, is the decomposition lossless? Is it dependency preserving? Justify your answer.