Normalization - 1NF, 2NF, 3NF and 4NF

Database Normal Forms

[DolanDark]

bless u, much better taught than my shitty lecturers

[davidmaiolo]

Watching this 20 minutes before my database final. Thank god this is only 19 minutes.

[sburns]

This video was more helpful than the college classes I pay for. Thanks for creating this video.

[ammarthemartian]

3:00 - 1st Normal Form
6:21 - 2nd Normal Form
9:40 - 3rd Normal Form
13:37 - 4th Normal Form
18:07 - Table relationships and name

How does something so simple can be super confusing in class?
Thank you so much!

[Fireprincess]

I'm dumb, so the only thing I've learned in the past 4 minutes is that beautiful isn't a colour, it's an opinion.

[troykachor]

5 classes, in 10 minutes (skipped through a bit). Final in 7 hours. You saved me a ton of sleep. Thanks!

[parvez]

Only 17 videos and 4.47k Subscribers. This is how quality works.... Thank you so much for the explanation.

[michaelwhitlock]

This is so much simpler and practical compared to the overly formalized logical relationships they use to try to teach this. You don't need to worry about terms like functional or transitive dependencies....The data speaks for itself and becomes intuitive with this approach. Thank you so much!

[philipbein]

you deserve $123, 000 dollars a year because you taught me what my professor couldn't in thirteen minutes, godspeed and good luck

[Noahh_jp]

slacked off all semester. final is in 30 mins, just finished this video and completely understand it. Phenomenal.

[budatn]

Excellent video! I sat through 2 hours of online classes and had no idea what the professor was saying, thanks for fixing me in 20min!

[bryanurizar]

On the first table at 5:51, Cust ID cannot be the primary key as the values in that column are not unique (e.g. wilson44). The correct way would have been to label that as a foreign key (it would be the primary key of a customer table) and then have a Sales ID which would be unique.

[willardbarrwb]

Hands down the greatest normalization example and explanation I have ever watched. He used one example straight through unlike others who like to switch the example once they reach 2nf and he explain partial dependency in layman terms than just textbook.

[bryanhall]

I just finished this chapter in my book and it was tough to read. Your breakdown really helped! Thank you!

[juhirawat]

i have wasted money in several tutions.. wasted my time in various classes..but never got such crystal clear view on this topic.... thanks a tonn buddy

[Sean-jdhy]

I appreciate this video. I wish you would have addressed BCNF as well because the way you explained these four forms are clear and concise.

[graceherbert]

Was going around in circles looking for an understandable explanation, now click! Thank you!!!

[mussieg]

Thank you so much. Now, my head is functioning Normal with your Normalization lecture. Definitely, better than what I learned in class.

[Helloomadison]

This man out here saving lives. Actual saint. Thank for finally explaining this in human/real terms sir!

[CS-blsz]

Simple but understandable for beginners, way better than explanations in textbooks