Database Normalisation: Second Normal Form

This video is part of a series about database normalisation. It explains how to transform a database, which is already in first normal form, into second normal form by working through an example. It covers the criteria for the second normal form including ensuring that a relation, that is a table, does not contain any partial dependencies on the primary key. The video explains what is meant by a functional dependency and a partial dependency.

[firepower]

These are hands down the best computer science videos on the internet... Thank you so much for helping me get through my degree over the years!

[TheZliKadi]

i've watched several normalisation tutorials, also listened to a college course, and this is the best material i've found! you could say - normalisation for dummies :) TY

[deathnightpwnage]

This channel is quite underrated. Thank you for publishing these videos!

[jeffreytello]

best explanation of normalization on the internet! thank you

[iyasuwalalign]

ur voice, logicallity of teaching is just perfect

[mikekirby]

Superior treatment of normalization; great teacher

[gsfwnut]

Thank you so much for this series! You're much better at explaining database normalisation than our university professors.

[Combatechist]

It's good to know there are people who have a clear mental thought process in this industry.

[dhkim]

All the lingo about partial dependencies, prime and non prime attributes had me confused but you were able to explain it in such a clear and concise manner! Much appreciated, and definitely helped me understand this part of my DBMS course much better!

[SiddiqNx]

This is the clearest video I have seen on this topic. Your way of teaching is really amazing! Clear, concise, comprehensible and to the point. Keep up the work. Please don't ever stop making such high quality videos. :) Thanks.

[mgray]

You have a very professional voice, and I like how you use examples and problems that would occur in the field. So grateful for this! I was getting horribly flustered and depressed from this week's work because the book and prof aren't doing the best job. Thank you.

[jamie-leevellem]

This is by far the best explanation there is out Thank you

[abu-bakrmohamed]

literally the best normalization tutorial i have ever watched !, thank you so much 💖

[bobbyw]

Thank you. You are the only one that can explain it simply.

[NixTheGat]

thanks man, after a 3, 4 days of researching finally i understand 2nf from this video, you are my database hero bro :X

[James-mvge]

This was one of if not the most helpful videos I found on normalisation.

[Jobe-bjpq]

I struggled with 2NF all day in my class but this video had the best explanation yet! Thank you so much!

[fadygamilmahrousmasoud]

for sure it's the best explanation ever for normalization on youtube, thanks

[katruya]

Lifesaver! Database Systems textbook is too dense! Thanks for helping my grade! Subscribed!

[Billbillbillhahagdvdve]

These vids are great. Super clear and easy to understand unlike so many others !!