In send normal form table must follow this condition.
1. Must Follow 1st normal form.
2. Remove partial dependent.
Students Table:
student_no | course_no | course_fee |
1 | c1 | 1000 |
2 | c2 | 1500 |
1 | c4 | 2000 |
4 | c3 | 1000 |
4 | c1 | 1000 |
2 | c5 | 2000 |
Student_no,course_no → Candidate Key (Prime Attribute)
course_fee - Non prime Attribute.
course_fee is dependent on proper subset of candidate key.
2nd Normal Form:
student_no | course_no |
1 | c1 |
2 | c2 |
1 | c4 |
4 | c3 |
4 | c1 |
2 | c5 |
student_no | course_no |
1 | c1 |
2 | c2 |
1 | c4 |
4 | c3 |
4 | c1 |
2 | c5 |