in Databases edited by
1,095 views
1 vote
1 vote
Given a relation R( P, Q, R, S, T) and Functional Dependency set FD = { PQ → R, S → T }, determine whether the given R is in 2NF? If not convert it into 2 NF.
in Databases edited by
1.1k views

1 comment

No it is not in 2NF because candidate key is $PQS$ and  $PQ → R$ and $S → T$ are both partial keys.

To convert into 2NF find $PQ^+$ and $S^+$

So R(P, Q, R, S, T) will decompose into $R_1(P,Q,S), R_2(P,Q,R), R_3(S,T)$

 

Please mention the source of this question in title and if it is a self doubt mention it in title and ask question in question description.
0
0

1 Answer

3 votes
3 votes
Caption

Not in 2NF. (pqs) will be candidate key