Like this is straight up amazing! I sat through lectures on this topic given by a bad lecturer thinking I was a moron for not getting it. Watched a 20 minute video by this legend of a man, and it's like someone turned a light on in my brain for how we normalize, and why. You just earned yourself a sub!
Literally the BEST video on RD normalization! In 21+ mins you broke this process from bottom - up. You went over the small details, where does the primary key come from, what is CUD anomalies and how to satisfy 1NF++. You answered al our questions, the reason we came here. They say you truly know something when you can explain it in a very simple way, given this is not rocket science and is capable of explaining in simple ways, you sir have accomplished that! Thankyou! P.S Thanks for adding the subtitles!
I have never had someone explain something to me that was as clear as this presenter did! Excellent job! Now I would like to see how to move a database into the next forms! But only by this guy..absolutely amazing!
I had seen many videos on Normalization before this and still was not confident on the concept. Loved the simplicity with which the concepts were covered. Confident and satisfied :)
You have explained this really well. All other youtubers are just giving examples with those arrows and relations etc. but you took a real world example and explained it.
after 2 years at collage not understand normalization, but i was able to put my tables into the 3nf (i know its werd). i was final able to understand normalization perfectly. this video saved my life as its the best one out of all the normalization videos ive watched, thank you so much
6 Feb 2020: Before watching this video, I was clear with most of the normalization process. Still I was making occasional mistakes. The part of your video that helped me a lot is : To find out if the non-key columns are dependent on primary key, ask this question, does that non-key column describe what the primary key identifies? If the answer is "no", that information should not be in that column. Thank you very much :)
This video is fantastic. I thought he genuinely didn't know how to pronounce those names but then I saw him doing the same with Indian names so I'm sure he's just messing with us. This video had me in stitches at times! Also, more importantly, I've gotten a good overview of what normalisation means. Thanks, man!
I actually wanted the video to explain about the BCNF (Boyce Codd Normal Form) which comes before the 4NF. The video shows a thorough explanation of the concepts, thank you so much.
At around 13:49 of the video, he said that if a customer is removed from its table, the agent will not be affected. My question is, what if the Primary Key of the Agent table is a Foreign Key in Customer table and Referential Integrity is enforced and Cascade Update and Delete Related Fields and Records is checked in the Relationship, will it affect the Agent's table in any way?
This was a very helpful video. I had been reading through a lot of material prior to this and it just was not making sense to me. Your explanation cleared up all my confusion! Thank you!!!
this 21 min video is worth months of study, your explanation is fantastic and very clear, i have also watched you "how to draw ER diagram" video and it was as good and i heavily recommend everyone to watch it, thank you Mr Kaustubh Joshi for providing all of these nice videos to us for free!
Hey, Dean From Ireland. My database lecture is not good a teaching in general. I thought I was screwed for my summer exams until I came across this. Thanks you
thank you very much sir of your tutorials it helps all computer related courses anywhere in the country keep it up sir i hope you wont stop uploading videos
Awesome tutorial. Excellent... my lol comment is > the whole time I was thinking ' WTF is a pincode ? ' , ahhh yes, a city thing. Now that the db is normalized I know it has NOTHING to do with mortgage freemoney . thnx for normalizing my confusor
Dude, he's an awesome teacher! I have a bias typically attached to heavy accents, but his video is super well done and laid out. You can follow him easily. I just feel bad for Gori Diamond and Morgan Freeman........=/ . Morgage will never be casted again! =)
sir one doubt, In 3nf you have customized the customer table into two tables one is customer info and other one is customer location table. My doubt is that the agency table also has the same descriptions of customer table. it has agency id, agency name, location and phone number. here phone number transitively dependent on the agency id. But why you didn't normalized the agency table into 3nf
AgencyName does not describe an agent. It describes his/her work location and so is in another table. Why is CustCity which does not describe the customer, but his/her residence location, stay in the CustomerInfo table? Is this violating the 2NF?
Like this is straight up amazing! I sat through lectures on this topic given by a bad lecturer thinking I was a moron for not getting it. Watched a 20 minute video by this legend of a man, and it's like someone turned a light on in my brain for how we normalize, and why. You just earned yourself a sub!
William Organ, I cannot be more agree with you
Good students aren't just good on their own. Half of their results come from good teachers like this.
OMG.. you taught me a lot here, but the Mortgage Freeman part killed me man ! I hope Mortgage Freeman watches this video !
One of the simplest videos to understand database form normalisation. Thanking you, all the way from Sri Lanka.
Literally the BEST video on RD normalization! In 21+ mins you broke this process from bottom - up. You went over the small details, where does the primary key come from, what is CUD anomalies and how to satisfy 1NF++. You answered al our questions, the reason we came here.
They say you truly know something when you can explain it in a very simple way, given this is not rocket science and is capable of explaining in simple ways, you sir have accomplished that!
Thankyou!
P.S Thanks for adding the subtitles!
Thanks for this great video. The names are hysterical. Concise explanation of normal forms.
Bread Pith is my favorite.
I have looked through lots of material on NORMALIZATION and this has been the **BEST** explanation. Great Job!!!
straight to the point. I am studying database introduction as one of my modules and this video helped alot
I have never had someone explain something to me that was as clear as this presenter did! Excellent job! Now I would like to see how to move a database into the next forms! But only by this guy..absolutely amazing!
What I like about your videos is you make things so easier and explain technical things in simple words.
Thank you for explaining. Only 20 minute and I master 0NF to 3NF already! Thank you so much!
ONE OF THE BEST EXPLANATION OF NORMALIZATION I CAME THROUGH ON RUclips.........
I had seen many videos on Normalization before this and still was not confident on the concept. Loved the simplicity with which the concepts were covered. Confident and satisfied :)
RIP Gori Diamond 1967 - 2017
?
hahaha.....he could say...he got transfer or left the company...........but he killed him :)
He sent Morgage Freeman to the moon.
ROFL LMAO... Yes, He killed GORI Diamond... That's homicide...
@@shaunonmt betterrr
tons of people clarified it on youtube but noone did like you,big respect thank you Man!!!!!
You have explained this really well. All other youtubers are just giving examples with those arrows and relations etc. but you took a real world example and explained it.
Thank you for your kind words.
Watched many videos on this topic, this is by far one of the better if not the best one! Much appreciated.
Shoutout Mortgage Freeman lmao
Hey man don't forget about Bread Pith!
For sure, LOooOL!
Was he referencing the Boondocks😂, as in Morgan Jebediah Freeman?
Don't know how to thank you! U made it understandable in 21 min which my professor couldn't do in 3 hrs.. make more videos like this. God bless u!!
to think this video was made in 2017 and it made the most impact to my understanding of the subject in 2022. thank you.
after 2 years at collage not understand normalization, but i was able to put my tables into the 3nf (i know its werd). i was final able to understand normalization perfectly. this video saved my life as its the best one out of all the normalization videos ive watched, thank you so much
6 Feb 2020: Before watching this video, I was clear with most of the normalization process. Still I was making occasional mistakes. The part of your video that helped me a lot is :
To find out if the non-key columns are dependent on primary key, ask this question, does that non-key column describe what the primary key identifies? If the answer is "no", that information should not be in that column.
Thank you very much :)
literally after going through 4 other videos from different people explaining Normalization, you got the best explanation thanks man keep it up.
One of the best on RUclips.
Thank you.
Glad you think so!
This video is fantastic. I thought he genuinely didn't know how to pronounce those names but then I saw him doing the same with Indian names so I'm sure he's just messing with us. This video had me in stitches at times!
Also, more importantly, I've gotten a good overview of what normalisation means. Thanks, man!
1 hr Nptel and 2 hrs of my university class couldnt make me understand this topic but your videos made me understand everything.
I am glad that it was useful !
This really helped ! You dont rush through things and very easy to listen to.
Thanks a ton Branden for your kind words.
Your teaching style is amazing and your wealth of knowledge on the subject is incredible.
Very well explained.
Thank you.
THE BEST EXPLANATION OF NORMALIZATION ON RUclips. HATS OFF MATE!!!! (:
I actually wanted the video to explain about the BCNF (Boyce Codd Normal Form) which comes before the 4NF. The video shows a thorough explanation of the concepts, thank you so much.
At around 13:49 of the video, he said that if a customer is removed from its table, the agent will not be affected. My question is, what if the Primary Key of the Agent table is a Foreign Key in Customer table and Referential Integrity is enforced and Cascade Update and Delete Related Fields and Records is checked in the Relationship, will it affect the Agent's table in any way?
This man is an excellent teacher. Thanks for the lesson.
This was a very helpful video. I had been reading through a lot of material prior to this and it just was not making sense to me. Your explanation cleared up all my confusion! Thank you!!!
The best video ever on Normalization! Better than my teacher loool
Amazing teacher, great job sir. Thank you for making this accessible and easier to understand =]
You're very welcome! Thanks
how can you keep a straight face saying things like "Mr bread pit" ? I love you !
I have a lame face!
best video ever thanks from Australia😃
this is a super video explaining Third normal form, easy and straight forward, thanks
That is one handsome teacher! Thank you for the lessons.
U SAVED MY FINAL TERM, Thankyou and I love you :)
Most welcome !
Morgan freeman to Mortgage freeman was funny i couldn't stop cracking but Sir you are doin' a great job!
such a good communicator. good explanation.
Very funny video, full of comedy...I have started to watch very seriously but couldn't stop laughing so much..
this 21 min video is worth months of study, your explanation is fantastic and very clear, i have also watched you "how to draw ER diagram" video and it was as good and i heavily recommend everyone to watch it, thank you Mr Kaustubh Joshi for providing all of these nice videos to us for free!
Glad it was helpful! Thank you for your kind remarks.
This was an excellent description. thankyou!
Glad it was helpful!
Fantastic video. Thank you from Australia :)
Amazing lecture! The best so far on youtube on this subject.Also I appericate the good English accent.It was a pleasure to watch it!
I just noticed, you typed the subtitles for this video yourself, right? Dedication, right there. Great video.
Amazing video, better than my teacher! You guys are amazing!!! Keep it up!
Great teacher. Simply explained.
Brilliant video. Thank you so much for the wonderful explanation.
You are better than my University Professor , thanks a lot
Happy to help!
Execellent explaination of normalization in a very simple way....thank you soo much sir
great teacher.Portion of my university tuition fees should be paid to him.. not to the fool authority
Thanks a ton for your kind words
true that !!!
100% true
Great Teacher to learn even for P.hd candidates.
Really Best Teaching Methodology - Great Work
Hey, Dean From Ireland. My database lecture is not good a teaching in general. I thought I was screwed for my summer exams until I came across this. Thanks you
I'm officialy in love with you! jaja great explanation!
Nice explanation. When do we use a join table and when do we use a foreign key? Like in 17:13
Great Video, thankyou so much and keep uploading great educational content
Nice video sir.. Able to understand the concept 👍🏻
man i don't normally write comments but damn!! you are so good explaining
I have the exam in 3hours and you saved me. Thank you ❤🎉
Best of luck!
It helps a lot.Data normalization done in DBMS project efficiently. Thank you.
Thanks a lot for your kind words Shreya.
one of the best explanations
thank you very much sir of your tutorials it helps all computer related courses anywhere in the country keep it up sir i hope you wont stop uploading videos
Thanks buddy.. I like a lot ur video. Happy to watch again new videos too.
Great Video. A lot of information served clearly.
Really intuitive explanation! Thanks
I kinda always knew Mr. Mortgage Freeman is not from this planet. That also explains how he knew so much about space and wormholes.
Very great explanations. I learned the essentials of good relational database design...
You explained it very clearly. Thank you so much
Awesome tutorial. Excellent... my lol comment is > the whole time I was thinking ' WTF is a pincode ? ' , ahhh yes, a city thing. Now that the db is normalized I know it has NOTHING to do with mortgage freemoney . thnx for normalizing my confusor
One of the best explanation. Good work.
Well done Sir thanks a lot to explaining all forms by one complete example. keep it up GOD BLESS YOU
Too handsome and obviously very smart and helpful. Literally loved it.
excellent explanation
amazing explantaion, loved the names lol
why in 2NF, you have removed agent id from the customer table? it could be part of it and as in agent table you linked agency id
Amazing explanation sir..!
Excellent explanation, thank you
Great explanation!!!
One Doubt:
Why would we create a CustomerAgents table? Customer would have only a single agent. Customer can have FK to Agents.
Absolutely fantastic!! Great explanation!
rip bread pith, this guy is amazing
Excellent presentation! I understand it completely...
Excellent and clear explanation..!!
Dude, he's an awesome teacher!
I have a bias typically attached to heavy accents, but his video is super well done and laid out. You can follow him easily.
I just feel bad for Gori Diamond and Morgan Freeman........=/ . Morgage will never be casted again! =)
This was an awesome and well explained video. Thanks so much!
thank you very much for the video it really helped me to understand normalization
Awesome Video. Clean narrative
sir one doubt,
In 3nf you have customized the customer table into two tables one is customer info and other one is customer location table. My doubt is that the agency table also has the same descriptions of customer table. it has agency id, agency name, location and phone number. here phone number transitively dependent on the agency id. But why you didn't normalized the agency table into 3nf
same confusion to me
+1
That was too helpful......thnkuu
Glad it helped !
well produced and I learned a lot!!!
Excellent video. Very well explained.
AgencyName does not describe an agent. It describes his/her work location and so is in another table. Why is CustCity which does not describe the customer, but his/her residence location, stay in the CustomerInfo table? Is this violating the 2NF?
Great Explanation Man. Simply Great.
Excellent explanation... I learned a lot. Thanks!
It was good after all, but you didn't mention how did you do the normal forms. For example identifying partial dependencies.
Fantastic explanation and the time markers are really helpful as well.
Thanks a lot Sir for the effort. Brilliant concept. Worth 21:41 mins 😭😭. Also upload videos on joins,complex query
Nicely explained..
Great video, was entertaining with concise and simple explanations.