2 votes 2 votes Consider relation R(A,B,C,D,E,F,G) with the following functional dependencies AB$\rightarrow$CD , D$\rightarrow$B, AF$\rightarrow$D, DE$\rightarrow$F, C$\rightarrow$G, F$\rightarrow$E, G$\rightarrow$A. What is the highest normal form. Databases database-normalization + – Rajat Agrawal007 asked Dec 20, 2018 Rajat Agrawal007 3.3k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply arvin commented Dec 20, 2018 reply Follow Share 3NF.. 0 votes 0 votes Gaurav Kadyan commented Nov 10, 2023 reply Follow Share In this how could we find all candidate keys easily 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes Here $AF,CF,GF,ADE,ABE$ are some of the candidate keys $\Rightarrow$ $A,B,C,D,E,F,G$ all are primary attributes. $D\rightarrow B$ is given in relation and $D$ is not a Super key $\Rightarrow$ The given relation is not in BCNF. In the given relation since all in the relation the R.H.S side attributes are primary attributes $\Rightarrow$ The given relation is in 3NF. Hence the relation is in 3NF. Satbir answered Dec 20, 2018 • edited Nov 16, 2019 by Satbir Satbir comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments Satbir commented Nov 16, 2019 reply Follow Share bcoz it is not part of any candidate key. 0 votes 0 votes Arjun commented Nov 16, 2019 reply Follow Share ABE is not a candidate key? 0 votes 0 votes Satbir commented Nov 16, 2019 reply Follow Share it is, my mistake. 0 votes 0 votes Please log in or register to add a comment.