Second Normal Form (2NF) | Normalization | DBMS
Vložit
- čas přidán 2. 08. 2024
- 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 | No...
Partial Dependency: • Partial Dependency in ...
If you have not watched my previous videos on Database and DBMS concept click playlist link below:
Functional Dependency in DBMS: • Functional Dependency ...
Normalization & Normal Forms | Playlist: • Normalization & Normal...
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 S...
Process - Operating System | Playlist: • Process - Operating Sy...
Types of Operating System | Playlist: • Types of Operating Sys...
Other videos on the channel:
What is compiler?: • What is Compiler | Sho...
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
I have my semester tomorrow and you made it so simple to learn. Thank you So Much. I appreciate your hard work.
Glad I could help!
your explanation is one of the great explanation i hope you complete the playlist as soon as possible where each and every topics are covered
4:55 how there is only one candidate key? I think (Student_ID, Course_Fee) is also a candidate key isn't it?
Can someone please explain I am very confused.
🙌🙌
Crystal clear explanation❤
Thank you :)
4:55 how there is only one candidate key? I think (Student_ID, Course_Fee) is also a candidate key isn't it?
Can someone please explain to me, I am very confused.
4:55 how there is only one candidate key? I think (Student_ID, Course_Fee) is also a candidate key isn't it?
Can someone please explain I am very confused.