GATE 1997
2.3  For a database relation R(a,b,c,d), where the domains of a, b, c, d include only
atomic values, only the following functional dependencies and those that can be
inferred from them hold:
a -->c
b -->d
This relation is
(a) in first normal form but not in second normal form
(b) in second normal form but not in third normal form
(c) in third normal form
(d) None of the above

  • Explanation


    For finding normal form, we should first concentrate on finding key. If you find key of this relation, it is " ab" .Prime attribute { a,b} and non prime attribute {c,d}.

     The relation will be in 2NF if every Non Prime attribute is fully functional dependent on KEY.

    Here {c,d } are not fully functionally dependent,rather they are partially dependent.

    So this relation is in 1NF but not in 2NF.

    Let me know if I am unclear.


lonasarkarcs's picture
vivek14's picture

Did not found what you are looking for, Ask your doubt or Help by your contribution

Enter your search keyword:

Search form


Here is a chance to join biggest community of technical Students,
Tutors with FREE learning resources and so much more.
It takes less then 60 seconds.