3. Consider a relation Studentlnfo(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 Studentlnfo table to be BCNF, the Studentlnfo 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 (50pts)