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 |
|---|---|
| S01 | Alice |
| S02 | Bob |
Student_Course
Already in 3NF (Only contains keys, no non-key attributes at all)
| StudentID (PK, FK) | CourseID (PK, FK) |
|---|---|
| S01 | C101 |
| S01 | C102 |
| S02 | C101 |
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) |
|---|---|---|
| C101 | Math | Mr. Smith |
| C102 | Physics | Dr. Lee |
Teachers (3NF)
| Teacher (PK) | Room |
|---|---|
| Mr. Smith | R1 |
| Dr. Lee | R2 |