Normal Forms in DBMS

Published: 02 April 2021
on channel: E-Pathshaala
114
3

This video will see how the normal forms are used to reduce redundancy from the database table. Understanding various normal forms like 1NF, 2NF and 3NF.
1NF 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 transitive dependency exists.


Watch video Normal Forms in DBMS online without registration, duration hours minute second in high quality. This video was added by user E-Pathshaala 02 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11 once and liked it people.