Question: For each 1NF relation below, you will need to normalize the relation to 2NF, and then to 3NF. You must show both the 2NF and


For each 1NF relation below, you will need to normalize the relation to 2NF, and then to 3NF. You must show both the 2NF and 3NF relations. As you know, not all relations have a partial dependency. Likewise, not all relations have a transitive dependency. In fact, once you have normalized the 1NF relation to 3NF, none of the 3NF relations will have a partial or transitive dependency. Either graphical or relational notation is acceptable in your answers. Click the check box next to any correct answers (3 points each problem) 1NF Relation 2NF Relation (2 points each problem) 3NF Relation (2 points each problem) Is the 1NF relation also in 2NFO? Is the 2NF relation also in 3NFO? R(A,B,C,D,E,F,G) FD1 (A,B,C) -> F FD2 (A,B) ->G FD3 G -> DE What are the determinants in the 1NF relation? A BX 5. R1(A, B, C, F) R2(A, B, G) R3(G, D, E) R A B C D EFG - FD1 FD2 FD3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
