Can someone help with the normalization of this table up to 3NF? Here's what I have done till now:
UNF
Student [Student Name, {Course ID, Course Title, Lesson No, Lesson Title, Lesson Status, Last Accessed, Instructor ID, Instructor Name}]
1NF
Separating Repeating data and groups:
Student [S.N, Student Name]
S.N. added as primary key for the table.
Course [Course ID, Course Title, Lesson No, Lesson Title, Lesson Status, Last Accessed, Instructor ID, Instructor Name, S.N FK]
Course ID selected as the primary key.
2NF
Student [S.N, Student Name]
This table stays the same because there is no partial dependency.
Course [Course ID, Course Title, Lesson No, Lesson Title, Lesson Status, Last Accessed, Instructor ID, Instructor Name, S.N FK]
Course ID = Course Title, Instructor ID, Instructor Name
Here I don't think course ID gives me Lesson No does it? So, should I make Lesson No a composite primary key along with Course ID?