Explain third normal form and provide examples.

Third Normal Form (3NF): A relation is in third normal form if it is in 2NF and no nonkey attribute is transitively dependent on the primary key. No dependencies on non-key attributes
3NF is meant to cover single column keys. Simply stated, pull out columns that don’t directly relate to the subject of the row (the primary key), and put them in their own table.
Example:-
Orders         
OrderId (PK)   OrderDate   CustomerName   CustomerCity
1   2009-01-01   John Smith   Chicago
Customer information could be the subject of its own table. Pull out customer name and other customer fields into another table, and then put a Customer foreign key into Orders.
http://www.studytonight.com/dbms/database-normalization.php

PERFECT