Second Normal Form 2NF (Part 1) | Oracle SQL Fundamentals

Second normal form (#2NF) is a normal form used in #database #normalization. A relation is in the second normal form if it fulfills the following two requirements: It is in first normal form. It does not have any non-prime attribute that is functionally dependent on any proper subset of any candidate key of the relation. 00:00 What is 2NF? 00:32 Terms in 2NF 00:53 What is Key Column? 01:49 What is Non-Key Column? Website: https://www.dbagenesis.com/ Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis