NORMALIZATION;

Consider the following relation and convert to the normal form indicated. If the relation set is in its highest form simply state 2NF is also 3NF or similar under the appropriate normal form.

0NF:

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

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: