Question: Consider the relation schema {program, course, professor, student, score} and the following FDs: (We use to for the arrow.) course,student to score course to professor

Consider the relation schema {program, course, professor, student, score} and the following FDs: (We use "to" for the arrow.)

course,student to score

course to professor

professor to program

Which of the following statements are correct?

1.

the closure of {professor} is {professor, program, course}

2.

the closure of {course, student} is {course, student, score}

3.

{program} is a key

4.

{course, professor} is a key

5.

{course, student} is a key

6.

This is in BCNF.

7.

{student, score} is a key

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!