Question: Consider primary key based normalization only. Given a relation R(A, B, C, D, E, F, G, H, I, J) with primary key AB, and the

Consider primary key based normalization only. Given a relation R(A, B, C, D, E, F, G, H, I, J) with primary key AB, and the 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? Justify your 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 you reach 3NF or you cannot decompose the relations further (e.g., n NFàn+1 NFà...). For each normalization step, list all the resulting relations, underline the primary key for each relation, and state the reasons behind each decomposition (e.g., remove ... problem).

Step by Step Solution

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

RABCDEFGHIJ Clearly above relation is in 1NF because to be in 1NF there must not be any multivalued attributes and above relation doesnt have any Nowl... View full answer

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 Programming Questions!

Related Book