Question: Given a university database schema where one table records the relationships between students, courses, and professors with attributes ( StudentID , CourseID, ProfessorID, Grade )

Given a university database schema where one table records the relationships between students, courses, and professors with attributes (StudentID, CourseID, ProfessorID, Grade), assuming:
Each course is taught by only one professor.
A student can enroll in multiple courses.
Professors can teach multiple courses.
Which of the following statements is true regarding the normalization of this table into BCNF?
Group of answer choices
The table cannot be in BCNF until it is decomposed into two separate tables: one linking students to courses and grades (StudentID, CourseID, Grade) and another linking courses to professors (CourseID, ProfessorID).
The table is already in BCNF because each course is uniquely identified by CourseID.
The table is in BCNF if StudentID and CourseID together form the primary key, as all non-key attributes are dependent on the primary key.
Decomposition is unnecessary as the functional dependency ProfessorID -> CourseID ensures that the table is in BCNF.

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!