Question: QUESTION 2 (a) Consider a relation R(A, B, C, D, E, F, G, H, I, J, K) with the following functional dependencies (FD1 to FD5)
QUESTION 2 (a) Consider a relation R(A, B, C, D, E, F, G, H, I, J, K) with the following functional dependencies (FD1 to FD5) that exist between these attribute and answer all questions below. A B B D D E F G H K (Primary key) FD1: A, B D, E, F FD2: A C FD3: B G, H, I, J, K FD4: DF FD5: H I, J, K i) Identify all functional dependencies (FD2, FD3, FD4 and FDS) given above. Consider all functional dependencies above, write the 1NF relation schema. Identify the Primary key for the INF relation. iii) Based on the answer in (b), produce the 2NF relation schema and identify the Primary key for the 2NF relation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
