0

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

2
Contributors
2
Replies
19
Views
4 Years
Discussion Span
Last Post by coursehorror
0

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.

0

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)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.