Database Normalisation: Third Normal Form

Computer Science Lessons

Computer Science Lessons

168,926 views

This video is part of a series about database normalisation.  It explains how to transform a database, which is already in second normal form, into third normal form by working through an example.  It covers the criteria for the second normal form including ensuring that a relation does not contain any transitive functional dependencies.  The video reviews what is meant by a functional dependency and goes on to explain what is meant by a transitive dependency with examples.