Page 1 of 1
Question No: 04 29 consider 13037 the following FD's FI->F3 F2->F45 (F1,F2)->F5 in terms of this table is in 1NF, 2NF or
Posted: Wed Mar 30, 2022 9:22 am
by answerhappygod
- Question No 04 29 Consider 13037 The Following Fd S Fi F3 F2 F45 F1 F2 F5 In Terms Of This Table Is In 1nf 2nf Or 1 (31.85 KiB) Viewed 26 times
Question No: 04 29 consider 13037 the following FD's FI->F3 F2->F45 (F1,F2)->F5 in terms of this table is in 1NF, 2NF or 3NF? Reason it? 32 ation (2 marks) (b) Consider RTT (A, B, C,D,E) with the following functional dependencies: A-B CD-E EA BD Specify all minimal keys for R. (2 marks) (c) Explain Is it Lossy or lossless join decomposition in the following relation RTT(A,B,C,D,E) and FA->B, B--C.D.C, D-SE) Where RTT is decomposed into RTTI(A,B,D) and RTT2(CDE) (2 marks)