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,
3NF
Course
Course Code, Course Title, Level, Mode of Attendance, Course Fee, Start Date, End Date, Department*
Student/Course
Course Code, Student ID, Enrolment Date, Enrolled By
Student
Student ID, Student First Name, Student Last Name, Student Street, Student Town, Student Postcode, Student Landline, Student Mobile, Student DOB
Department
Department, Department Head Title, Department Head First Name, Department Name Last Name, Tutor First Name, Tutor Last Name
Thank you in advance