Third Normal Form | Normalization | DBMS
Hello, in this video we will be simplifying the concept of third phase in normalization that is Third Normal Form. So what have we not done already in first normal form and second normal form that we will do in third normal form? Watch the complete video to understand. In first normal form we got rid of composite and multivalued attributes. In second normal form we got rid of partial dependency. So now let us see what we will eliminate in third normal form.
Chapters:
Introduction- 00:00
Definition- 00:55
Condition 1- 01:33
Condition 2- 02:44
Converting to 3NF- 04:32
Why 3NF?- 05:07
Transitive Dependency: • Types of Functional Dependencies | Fu...
Partial Dependency: • Partial Dependency in DBMS
First Normal Form: • First Normal Form | Normalization | DBMS
Second Normal Form: • Second Normal Form (2NF) | Normalizat...
If you have not watched my previous videos on Database and DBMS concept click playlist link below:
Functional Dependency in DBMS: • Functional Dependency in DBMS
Normalization & Normal Forms | Playlist: • Normalization & Normal Forms
Keys in DBMS | Playlist: • Types of Keys | DBMS
Database and DBMS | Playlist: • Database & DBMS
If you want to watch videos on operating system concepts use the links below:
Deadlock - Operating System | Playlist: • Deadlock - Operating System
Process - Operating System | Playlist: • Process - Operating System
Types of Operating System | Playlist: • Types of Operating System.
Other videos on the channel:
What is compiler?: • What is Compiler | Short and Simple E...
If you find my videos helpful and if the videos help in clearing your concepts, like the video, share it with your friends, subscribe the channel and press the bell icon. :)
#ThirdNormalForm #Normalization #DBMS
