One of the college work items reads as follows:
Consider the following relation: R (A, B, C, D, E, F) where the primary key is A, B and the relation has the following functional dependencies: DF1-A - > W; Home DF2-B - > D; Home DF3 - (A, B) - > AND; Home DF4-E-> F
The. In what normal form R is found? Home B. Normalize R to the third normal form justifying each step.
In item 'a' I replied that it is in the first normal form, is it correct? Home In the 'b' section I do not know how to normalize the DF3 and DF4, because in my view the DF3 is ok in all normal ways and would generate a table (A (FK / PK), B (FK / PK), E). I believe that it would be right if the attribute E did not become a PK so that we can normalize the DF4 and generate a table (E (PK), F). What to do in this situation?