2 2 votes Given a table $R(ABCDEF)$ $ABC -> D$ $ABD -> E$ $CD -> F$ $CDF -> B$ $BF -> D$ It's candidate keys are $ABC, ACD.$ So while checking for $2NF$, Can I say that $ABD -> E$ is not partially dependent because $ABD$ as a whole is not a part of candidate key even though $AB$ is a part of candidate key. Databases rdbms databases database-normalization + – Rahul Ranjan 1 2.2k views answer comment Share Follow Print See 1 comment 1 1 comment reply srestha commented May 27, 2018 reply Follow flag ACD is a key CD-> F has partial dependency 1 1 replyShare Please log in or register to add a comment.
Best answer 1 1 vote Yes you are right whole is the part of key. Here ABD is not part of key . So it have no partial dependencyv. abhishekmehta4u answered May 28, 2018 • selected May 28, 2018 by Rahul Ranjan 1 abhishekmehta4u comment Share Follow 0 reply Please log in or register to add a comment.