A table is in Third Normal Form (3NF) if it is 1NF, 2NF and no non-key field functionally depends on any other non-key field.
Such indirect dependencies are known as transitive dependencies.

Problem Description


The 'order_status_desc' column of the 'order_master' table is dependent on the non-key column 'order_status'.

Operation


To make the 'order_master' table 3NF compliant, a separate table is created to eliminate this transitive dependency.

Result


Tables 'order_status' is created.