R= (StudentID, LName,FName,CourseID,CourseSection,CourseName,Grade,InstructorLNa

Question

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 step-by-step process normalize the above relation to BCNF.

Make sure you go through all normalization steps from 1NF to BCNF. Show your work.

You must indicate all anomalies lead to the violation of each normalizaion conditions.

List final set of relations that are normalized to BCNF.

Include schemas for each of the final set of relations. Indicate all the primary, foreign, and surrogate keys in the final schemas.

Explanation / Answer

Hi, Below are the functional dependencies-

1. StudentID --> {LName,FName, Grade} 2. StudentID --> {LName} 3. StudentID --> {Fname} 4. StudentID --> {Fname} 4. StudentID --> {Grade}

1. CourseID --> {CourseSection,CourseName, Grade} 2. CourseID --> {CourseSection} 3. CourseID --> {CourseName} 4. CourseIID --> {Grade}

1. OfficeNO --> {InstructorLName,InstructorFName,Building} 2. OfficeNO --> {InstructorLName} 3. OfficeNO --> {InstructorFName}  4. OfficeNO --> {Building}

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.