For a database relation $R(a,b,c,d)$ where the domain of $a,b,c$ and $d$ include only atomic value, only the following functions dependencies and those that can be inferred from them hold
$a\rightarrow c$
$b\rightarrow d$
The relation is in:
Original Source of this question: GATE 1997
https://gateoverflow.in/2265/gate-cse-1997-question-6-9
option a
partial dependecy so it is in 1NF.
answer: A
1st atomic means it is in 1NF
2nd
(ab)+ = abcd (so, ab is candidate key)
prime attributes are : a,b
partial dependencies are: a → c,b → d
therefore, it is not in 2NF
Thank you for reading..
64.3k questions
77.9k answers
244k comments
80.0k users