3,244 views
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.

1 Answer

2 votes
2 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.

 

edited by

Related questions