[Solved]1 30 Pts Consider Primary Key Based Normalization Given Relation R B C D E F G H J Primar Q37197690

1. (30 pts) Consider primary key based normalization only. Givena relation R(A, B, C, D, E, F, G, H, I, J) with primary key AB, andthe set of functional dependencies (FDs)

AB->C, A->DE, B->F, F->GH, D->IJ
a. Is this relation in primary key based 1NF, 2NF, or 3NF? Justifyyour answer.

1NF: Yes/No, justify:
2NF: Yes/No, justify with all possible FDs

3NF: Yes/No, justify with all possible FDs

b. Apply primary key based normalization successively until youreach 3NF or you cannot decompose the relations further (e.g., nNFn+1 NF…). For each normalization step, list all the resultingrelations, underline the primary key for each relation, and statethe reasons behind each decomposition (e.g., remove …problem).

Expert Answer

---

Answer to 1. (30 pts) Consider primary key based normalization only. Given a relation R(A, B, C, D, E, F, G, H, I, J) with primary… . . .