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 nonkey 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
