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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!