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