R=(StudentID,LName,FName,CourseID,CourseSection,CourseName,Grade,InstructorLName,InstructorFName,Building,OfficeNo)

Assumptions:

StudentID is computer generated and unique

A course can have multiple sections

An office is assigned to only one instructor.

It is okay to generate a surrogate key at the time of normalization if that is necessary.

Using straight-to-BCNF process normalize the above relation to BCNF. Make sure you follow the four step process. Show your work.

List final set of relations that are normalized to BCNF. Include schemas for each of the final set of relations.

Incidate all the primary, foreign, surrogate keys in the final schemas.