Hello guys, in this video we will understand the concept of second normal form. It is the next phase in normalization process after first normal form. There are basically two conditions for table to be in second normal form. First condition is it must be in first normal form and second condition is it must not contain any partial dependency.
Chapters:
Introduction 00:00
Conditions for 2NF 00:41
1NF Condition 01:44
Partial Dependency Condition 03:54
Removing Partial Dependency 06:25
First Normal Form:    • First Normal Form | Normalization | DBMS  
Partial Dependency:    • Partial Dependency in DBMS  

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. :)
#SecondNormalForm #Normalization #DBMS