Available under Creative Commons-ShareAlike 4.0 International License.
- To move on to 2ndNF, the table must be in 1stNF.
- The student table is already in 2ndNF because it has a single column PK.
- When examining the Student Course table, we see that not all the attributes are fully dependent on the PK. Specifically, all course information. The only attribute that is fully dependent is grade.
- Identify the new table that contains the course information.
- Identify the PK for the new table.
Student (Studentno,student_name,major)
Course_Grade(studentno,course_no,grade)
Course_Instructor(Course_no, course_name, instructor_no, instructor_name, instructor_location)
- 1282 reads
