Question

        Consider the following relation and convert to the normal form indicated. Make sure your Primary Key and its attribute(s) is/are underlined for full credit. Also indicate foreign keys using (FK) if any.

0NF:

COURSE[course_num, course_name, prof_name, prof_email, (student_id, student_name, student_email)]

Notes: Courses have many students and each student can take many courses.  However, a professor can teach many courses, although a course can be taught by only one professor.

1NF:

2NF:

3NF:

       

Answer 1

COURSE (course_num, course_name)

PROFESSOR (prof_num, prof_name, prof_email)

STUDENT (student_id, student_name, student_email)

REGISTRATION (course_num, prof_num, student_id)