retagged by
1,015 views
2 votes
2 votes

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\to c\\b\to d$

the relation is in

  1. first normal form but not in second normal form.
  2. second normal form but not in third normal form.
  3. third normal form.
  4. none of these.
retagged by

3 Answers

1 votes
1 votes
The candidate key for the relation is:  $ab$ ,  because  $ab^{+}=abcd$

Since,  $a \rightarrow c$  and  $b \rightarrow d$ are partial dependencies which are not allowed in $2$NF, the relation is hence in $1$NF.

Option A is correct.
1 votes
1 votes
A) first normal form but not in second normal form,

( ab)+=abcd..so , ab is a candidate key, so, a→c and b→d both are partial dependencies...and in 2NF it is not Allowed...and in the question it is given that  domains of a,b,c,d include only atomic values...So it is in 1NF..
1 votes
1 votes
ANS: A

CANDIATE KEY OF THIS RELATION IS AB

 

a→c

b→d

BOTH CONTAIN PARTIAL INDEPENDENCIES , AND IN 2ND NORMAL FORM PARTIAL INDEPENDENCIES IS NOT ALLOWED.

SO GIVEN RELATION IS ONLY IN 1ST NORMAL FORM.
Answer:

Related questions

4 votes
4 votes
3 answers
1
admin asked Mar 31, 2020
936 views
Let $R=(A,B,C,D,E,F)$ be a relation scheme with the following dependencies:$C\to F,E\to a,EC\to D, A\to B$.Which of the following is a key for $R$?$CD$$EC$$AE$$AC$
0 votes
0 votes
1 answer
2
admin asked Mar 31, 2020
683 views
Global lockssynchronize access to local resources.synchronize access to global resources.are used to avoid local locks.prevent access to global resources.
1 votes
1 votes
2 answers
3
admin asked Mar 31, 2020
1,609 views
In a relational Schema, each tuple is divided into fields calledrelationsdomainsqueriesnone of these
2 votes
2 votes
1 answer
4
admin asked Mar 31, 2020
1,759 views
The employee salary should not be greater than Rs.$2000$. This isintegrity constraintreferential constraintover-defined constraintfeasible constraint