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

AC---->C

C------>B

Highiest normal form?
asked | 74 views
+1

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.

0

@Hemant Parihar which form it is:-

{Prime, Non Prime} -> Non Prime.

Like,

AB---->B

I  think it should be 1NF.

ryt??

0
@Shubhanshu

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

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

## 1 Answer

0 votes

my answer

answered by Veteran (17.1k points)

+1 vote
0 answers
1
+1 vote
0 answers
2
+2 votes
0 answers
3