11,685 views
29 votes
29 votes

For a database relation $R(a, b, c, d)$, where the domains $a, b, c, d$ include only atomic values, only the following functional dependencies and those that can be inferred from them hold

  • $a \rightarrow c$
  • $b \rightarrow d$

This relation is

  1. in first normal form but not in second normal form

  2. in second normal form but not in first normal form

  3. in third normal form

  4. none of the above

2 Answers

Best answer
44 votes
44 votes
Candidate Key is $ab$.
Since all a,b,c,d are atomic so the relation is in 1 NF.

Checking the FDs :

$a\rightarrow c\ $ (Prime derives Non-Prime.)
$b\rightarrow d\ $ (Prime derives Non-Prime.)

Since, there are partial dependencies it is not in 2NF.

a} Answer 1NF but not 2NF
edited by
Answer:

Related questions