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:

Answer rating: 100% (QA)

1 NF A table is said to be in first normal form it has the following properties 1 It ... View the full answer