Recent questions tagged 3nf

Consider $R(A,B,C,D,E,F,G)$ with $F=\{BCD\to A,\ BC\to E,\ A\to F,\ F\to G,\ C\to D,\ A\to G\}$.Which of the following statements are correct after applying the $\text{3N...

Consider $R(A,B,C,D,E,F)$ with functional dependencies$A \to BCDEF$ $BC \to ADEF$ $E \to F$ $EF \to C$Which functional dependency satisfies 3NF but violates BCNF?$A \to B...

Consider $R(A,B,C,D)$ with functional dependencies$A \to BCD$$B \to C$$CD \to A$Assuming atomic values, what is the highest normal form satisfied by $R$?$\text{1NF}$ $\te...

Consider $R(A,B,C,D,E)$ with $A \to B,$ $BC \to E,$ and $ED \to A$.Which of the following statements are correct?$ACD$ is a candidate key. $BCD$ is a candidate key. $CDE$...

Consider $R(A,B,C,D,E,F)$ with $AC \to B,$ $BD \to F,$ and $F \to CE$.Which functional dependency causes $R$ to violate $\text{3NF}$?$AC \to B$ $BD \to F$ $F \to C$ $F \t...

Consider $R(A,B,C,D,E)$ with $C \to D,$ $DE \to B,$ and $AB \to C$.Which of the following statements are correct?$ABE$ is a candidate key. $ACE$ is a candidate key. $ADE$...

Consider $R(A,B,C,D,E)$ with $A \to B,$ $B \to C,$ $C \to D,$ and $C \to E$.Assuming atomic attribute values, what is the highest normal form satisfied by $R$?$\text{1NF}...

Consider $R(A,B,C,D)$ with functional dependencies $AB \to C,$ $BC \to D$.Which statement correctly explains why $R$ is not in $\textbf{3NF}$?$AB \to C$ violates $\text{3...

A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of RHere, what is the actual meaning of word key ? Does it mean prim...