+1 vote
40 views
AB---->B

AC---->C

C------>B

Highiest normal form?

It is in 1NF, not in 2NF.

AC is a candidate key, it can determine all A, B, and C.

The non-prime attribute will be B.

Which can be determined by the subset of the candidate key.

C $\rightarrow$ B

Not in 2NF.

@Hemant Parihar which form it is:-

{Prime, Non Prime} -> Non Prime.

Like,

AB---->B

I  think it should be 1NF.

ryt??

@Shubhanshu

If this is the only functional dependency then it is BCNF.

AB -> B (trivial).
This is trival fd but my point of u it should be in1 nf... Bacause if we minimize the fd it remain same...

answered ago by Boss (8k points) 6 41 119

+1 vote