1 votes 1 votes The relation R (ABCDE) with FD set $\{AB \rightarrow CDE, \ A \rightarrow C, \ C \rightarrow D\}$ is in which of the following normal forms? 1NF but not in 2NF in both 2NF and 3NF in 3NF but not in BCNF in BCNF Databases tbb-dbms-2 databases database-normalization + – Bikram asked Aug 26, 2017 retagged Sep 17, 2020 by ajaysoni1924 Bikram 315 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 2 votes 2 votes First, we need to find the candidate keys. From the given functional dependencies, only $AB$ is the candidate key. We have a partial dependency here, $A \rightarrow C$ So, it is not in $2NF$. Hence, option (A) 1NF but not in 2NF Rishabh Gupta 2 answered Dec 15, 2017 selected Aug 22, 2019 by Bikram Rishabh Gupta 2 comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes C is not fully functionally dependent on candidate key AB because A-->C. so it is not in 2NF.So answer is A chap24 answered Oct 3, 2017 chap24 comment Share Follow See all 0 reply Please log in or register to add a comment.