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

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -