Normalizing table ENROLLMENT to 3NF will result in:
A)No changes (table ENROLLMENT remains as is,no additional tables)
B)Two separate tables
C)Three separate tables
D)Four separate tables

Question

Quizplus · Accepted Answer

To normalize a table to the Third Normal Form (3NF), you typically need to remove transitive dependencies and ensure that all attributes are functionally dependent only on the primary key. This often results in splitting the original table into multiple tables to eliminate redundancy and dependencies that do not conform to 3NF. The exact number of tables depends on the specific attributes and relationships in the original table, but two separate tables is a common outcome when normalizing to avoid redundancy and ensure each table contains data about only one entity.

Normalizing Table ENROLLMENT to 3NF Will Result In