Determine the highest possible normal form of the given relation?

Question

Consider the relation  R(Name,courseNO,rolNO,grade)

name,courseno ->grade

rollno,courseno->grade

name->rollno

rollno->name

 

Given answer as it is 3NF . But Im getting 1NF. is it correct ?

Answer 1

Yes it is 3NF. In this relation the candidate keys are (name,courseno) and (rollno,courseno). So the there are no partial or transitive F.Ds in the given relation. 

name->rollno

rollno->name
 

these two F.D s are not partial as both LHS and RHS contain only prime attributes.

Answer 2

Consider N ->Name , C-> courseNO , R-> rolNO , G->grade

Candidate key : NC and RC

N,C, R are prime attribute.

NC -> G : BCNF

RC -> G : BCNF

N -> R : 3NF ( R is prime)

R -> N : 3NF (N is prime)

The relation is in 3NF.

Answer 3

This is definitely 3NF. But isn't it a BCNF too?

Comments

no not in BCNF because name and roll no are not a candidate key...last two dependency will not allow BCNF

Answer 4

So, highest normal form is 3NF