The relation scheme Student Performance (name, courseNo, rollNo, grade)

0

The relation scheme Student Performance (name, courseNo, rollNo, grade) has the following functional dependencies:
A) name, courseNo -> grade
B) rollNo, courseNo -> grade
C) name -> rollNo
D) rollNo -> name
The highest normal form of this relation scheme is :

Ravi Garg edited question
    0
    Ankit Mittal (anonymous)

    It is in 3nf as the Candidate Keys are :

    (name, courseno) and (rollNo, Courseno)

    a) is in BCNF
    b) is in BCNF
    c) is in 3NF (part of key -> part of key allowed)
    d) is in 3NF (part of key -> part of key allowed)

    Ankit Mittal answered
      Add image to editor add image from link

      Question stats

      • Active
      • Views259 times
      • Answers1 answer
      • Followers1 follower
      Question and answer is powered by AnsPress