Consider a relation StudentInfo(StudNo, StudName, Major, Advisor, CourseNo, Ctitle, InstrucName, InstrucLocn, Grade). Assume it has the following functional dependencies:

FD1: StudNo -> StudName

FD2: CourseNo -> Ctitle,InstrucName

FD3: InstrucName -> InstrucLocn

FD4: StudNo,CourseNo,Major -> Grade

FD5: StudNo,Major -> Advisor

FD6: Advisor -> Major

To make the StudentInfo table to be BCNF, the StudentInfo table has been decomposed into the following relations:

Student(StudNo, StudName)

StudMajor(StudNo, Major, Advisor)

StudCourse(StudNo, Major, CourseNo, Ctitle, Instrucname, InstrucLocn, Grade).

Does this decomposition satisfy BCNF? If not, apply further decomposition to make all relations satisfy BCNF