# Given a UNF normalize upto 3NF: #
UNF:
(booking_ref_no, booking_date, student_no, student_name, student_address, student_tel, course_code, course_name, course_level, course_start_date, course_finish_date, course_cost, lecturer_name, lecturer_no, center_name, centre_phone, class_size)
Here's what I got after 3NF, could some one verrify whether is the right way?
BOOKING: ( booking number (pk), booking_date, student_number (fk))
STUDENT: (student_number (pk), student_fname, student_lname, student_house_no, street_name, town_name, post_code, student_tel_no)
COURSE: (Course_code (pk), course_name, course_level, start_date, finish_date, Course_Cost)
LECTURER: (lecturer_code (pk), lecturer_fname, lecturer_lname lecturer_telephone
STUD_CRSE_LECT: (student_number (pk)(fk), Course_Code (pk)(fk), lecturer_code (fk), centre_name (fk))
CENTRE: (centre_name (pk), centre_telephone, centre_size)