Question

Consider the following relation with functional dependencies as shown below.
R{sno,sname,age,cno,cname,group}
R(A,B,C,D,E,F)
A-B,C
C-F
D-E
which normal form is the relation R is in?​

Answer 1

Answer:

Depends on what is your candidate key.

But if A alone is candidate key

1nf-atomic

2nf-no partial dependencies

3nf- no transitive dependencies like A->B ,B->C,A->C

not in bcnf because there are non prime attributes on which other columns are depending