What Is 1Nf and 2Nf

A relation is in 1NF if it contains an atomic value. 2NF. A relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key. 3NF. A relation will be in 3NF if it is in 2NF and no transition dependency exists.

What is the difference between 1NF and 2NF?

S.NO.1NF2NF6.The main goal of first normal form is to eliminate the redundant data within the table.The main goal of second normal form is to actually ensure the data dependencies.

What is the difference between NF 2NF and 3NF?

S.NO.2NF(Second Normal Form)3NF(Third Normal Form)1.It is already in 1NF.It is already in 1NF as well as in 2NF also.

David Miller

David Miller

Executive Financial & Market Analyst

David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.

Share this article
Twitter Facebook Pinterest