Student_Course_Record (UNF)
StudentID StudentName CourseID CourseName Teacher Room
S01 Alice C101
C102
Math
Physics
Mr. Smith
Dr. Lee
R1
R2
S02 Bob C101 Math Mr. Smith R1
Student_Course_Record (1NF)
StudentID (PK) StudentName CourseID (PK) CourseName Teacher Room
S01 Alice C101 Math Mr. Smith R1
S01 Alice C102 Physics Dr. Lee R2
S02 Bob C101 Math Mr. Smith R1
Students Already in 3NF (No non-key attributes depend on other non-key attributes)
StudentID (PK) StudentName
S01Alice
S02Bob
Student_Course Already in 3NF (Only contains keys, no non-key attributes at all)
StudentID (PK, FK) CourseID (PK, FK)
S01C101
S01C102
S02C101
Courses_Info (Only in 2NF - Needs fixing)
CourseID (PK) CourseName Teacher Room
C101 Math Mr. Smith R1
C102 Physics Dr. Lee R2
Courses (3NF)
CourseID (PK) CourseName Teacher (FK)
C101MathMr. Smith
C102PhysicsDr. Lee
Teachers (3NF)
Teacher (PK) Room
Mr. SmithR1
Dr. LeeR2