A relation has the attributes R(ABCDEPG). The set of Functional Dependencies are :
$F: { AB \to CD, DE \to P, C\to E, P\to C, B \to G }$
After normalising this relation till 3NF, I get the following tables : ${ABDE, DP, PC, CE, and BG}$
Please confirm the answer.
The decomposition is lossless, but I am not getting dependency preserving property. However, I read it in books that IT IS ALWAYS POSSIBLE TO GET A LOSSLESS AND DEPENDENCY PRESERVING PROPERTY IN 3NF - But I am not getting the Dependency Preservation property. Is something wrong with the decomposition ?