Normalizing table FLIGHT to 3NF will result in:
A)No changes (table FLIGHT 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 ensure that each table contains data about only one entity and that there are no repeating groups or transitive dependencies. The exact number of tables depends on the specific attributes and relationships in the original table, but two separate tables are a common outcome when normalizing to avoid redundancy and ensure each table represents a single entity or concept.

Normalizing Table FLIGHT to 3NF Will Result In