I have been given the example data and have been struggling to normalize to 3NF. I think the issue lies with the Tutor Name but this is my final chance at submitting so would like to get it right.
This is how I have normalised it,
Course Code, Course Title, Level, Mode of Attendance, Course Fee, Start Date, End Date, Department*
Course Code, Student ID, Enrolment Date, Enrolled By
Student ID, Student First Name, Student Last Name, Student Street, Student Town, Student Postcode, Student Landline, Student Mobile, Student DOB
Department, Department Head Title, Department Head First Name, Department Name Last Name, Tutor First Name, Tutor Last Name
Thank you in advance