# 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)

Member Avatar

LastMitch

Here's what I got after 3NF, could some one verrify whether is the right way?

Can you repost your code?

When you post your code on the editor highlight the code and click Code.

Then the code is highlight and more presentable.

Right now it's just black and white. There should be a color with it.

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)