I have a table like this:
L(A, B, C, D, E) and functional dependencies are:
AB -> CDE C -> D D -> B D -> E
I need to transform this table into 3NF. I think it's not even in 2NF. I found 3 candidate keys:
- first one is obviously
D->Bwe can change
AD->BCE. So another candidate key is
- using similar logic we get another key
(I am not sure if I did this correct).
D -> E (I think there are more dependencies like that) I assume that this table is not in 2NF. What is the correct way to split this table up to get 3NF?