940 views

4 Answers

Best answer
6 votes
6 votes

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.

selected by
2 votes
2 votes

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.

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

Related questions

5 votes
5 votes
4 answers
1
learncp asked Dec 17, 2015
5,309 views
Given R(ABCD) andAB → C ;ABD → C ;ABC → D ;AC → Dwhich the highest possible normal form for the above relation ?
3 votes
3 votes
3 answers
2
sh!va asked Nov 11, 2016
545 views
Determine the highest possible normal form of the given relation:A >BCDEF, BC ADEF, B >F a. 1NFb. 2 NFc. 3NFd. BCNF
3 votes
3 votes
3 answers
3
learncp asked Dec 16, 2015
9,992 views
Given a relation R (ABCD), and the following FDs- A->BCDBC->ADD->B.which is the highest normal form the table is in.a) 1NFb) 2NFc)3NFd) BCNF
2 votes
2 votes
2 answers
4