database - prime to prime transitivity in 3nf normal form -
i stuck in question. should answer this:
the relation scheme student performance (name, courseno, rolino, grade) has following functional dependencies:
name, courseno, -> grade
rolino, courseno -> grade
name -> rolino
rolino -> name
the highest normal form of relation scheme is
(a) 2 nf (b) 3 nf (c) bcnf (d) 4 nf
relation has 2 overlapping candidate-key dependencies in 3nf.
Comments
Post a Comment