When is a table in third normal form (3NF)?
1 answer
A table is in third normal form (3NF) if it is already in second normal form (2NF) and does not contain any transitive dependencies. This means that each non-key column depends only on the primary key column and not on any other non-key column. In other words, every non-key column should be directly related to the primary key of the table.
1 answer