Third Normal Form (3NF) | Database Normalization | DBMS

For complete DBMS tutorial: www.studytonight.com/dbms/
In this video, you will learn about the Third Normal Form of DBMS with help of the simplest database example ever.
You will also learn how to design a table which follows the Third normal form? What are the rules and requirements for a table to be in the third normal form?
As the data requirements increases, database complexity increases and with it chances of tables not following the Normal Forms also increases. And it is very difficult to notice Transitive Dependency sometimes.
We have extended the example from our 2nd Normal form video, so we suggest you watch that video before this one.
Introduction to Normalization: • Basic Concept of Datab...
First Normal Form: • First Normal Form (1NF...
Second Normal Form: • Second Normal Form (2N...
Third Normal Form: • Third Normal Form (3NF...
BCNF: • Boyce-Codd Normal Form...
Fourth Normal Form: • 4th Normal Form (4NF) ...
Fifth Normal Form: • 5th Normal Form (5NF) ...
If you LIKE this video, give it a thumbs up and do SUBSCRIBE to our channel.
Our website: www.studytonight.com
Facebook: / studytonight
Twitter: / studytonight

[@austinlee7095]

One of the most simplified and easy to understand explanations on youtube period. Keep up the good work :)

[@Studytonight]

Thank you so much, for the appreciation Austin. Do subscribe to our channel for more such amazing videos.

[@vaibhavdadas5372]

3:25 "Transitive Dependency is when some attribute of the table depends on some other attribute which is not a prime attribute " --- best explanation

[@harshadissanayake5269]

yeah

[@cicakmuhamed]

@@harshadissanayake5269 It's also incorrect. It should be stated that that prime attribute which is the determinant must depend on the primary key.

[@vaishnavm9090]

man i have a exam in exactly 7 hours and i thought i couldn't possibly finish normalization but you made me under stand it in less than 30 min !! . Thank you and congratulations for saving many normal people like us from the confusion of normalization.

[@Studytonight]

Hehe! Thank you for the comment. And yes! the videos are supposed to help everyone understand Normalization in about 1 hour max. Share it with your friends too.

[@zl_dz1038]

man im litterally in your position, me and my friend in discord are laughing on your comment

[@Smh.nyom90]

what exam??

[@franzbiberkopf9179]

I love this tutorial! It seems really that it has been done to be understood by people, not to show how good you are in editing videos with special effects or how good you master SQL without caring whether IT-prospects understand a single word of what you are saying. Thank you very much from Rome, Italy!

[@sidrakhan4790]

Sir, I'm one of the biggest fans of yours now, seriously i was confused in class when our teacher taught this topic but , your tutorials are like a Magic , they solved all my confusions regarding Normalization. Now ,I love this topic literally . Thank you so much sir . May God bless you with more and more success. Lots of Respect From Pakistan

[@Studytonight]

Hello Sidra, Thank you for your comment and for your appreciation.

[@sidrakhan4790]

Studytonight you're welcome sir It was my obligation to admire your effort From Pakistan

[@mitchellgresham872]

I agree! I think one of the biggest problems is that in academia they love to use big words and definitions, and get so caught up in those words that they forgot to teach the actual concept. I spend three hours yesterday just learning what functional dependency was because our textbook was horribly written. (and by horribly written I'm talking typos left and right).

[@genocideholocaust7826]

Al Hamdullillah I have internet access

[@kianaarabpour]

that moment when he just explained it better than my lecturer ever did... ever. Why do i even go university anymore?

[@stevenchao1969]

This is exactly what I felt too!!!

[@benvelloor]

Universities give you knowledge on what needs to be studied. It basically creates a courses and syllabus for each course. They conduct exams to give you the opportunity to study all these topics. They also assists you in finding jobs. University rankings don't depend on how well they teach. It depends on the platform they provide to help you understand what is best for you. I don't approve of the current university exam patterns where it's mainly theoretical but I know for a fact that universities help you build your career. None the less, absolute respect to StudyTonight for helping me understand Data Normalization

[@alishagarg150]

For a degree lol

[@HauNguyen-gs5xb]

University put you in competitive environment to help you go faster.

[@JaiminSavaliya-kz8fi]

For attendence 😂

[@RahulSoni-to1jg]

@StudyTonight: This is for the first time I'm able to completely understand all the normal forms and dependencies. Thank you so much for your simplistic yet powerful videos. Got the link to your website from a StackOverflow answer. Subscribing your channel and keep up the great work Sir!

[@macmohan9556]

I have never seen such a simple and better way to expalain 1,2 and 3F good work , keep it up

[@jperx]

Thank you for this video, I appreciate it. I've watched several videos explaining normalization but this series explains the rules in a simple and quick manner. I honestly understood the rules better with this video than from my Database Concepts class, lol.

[@Studytonight]

Thank you Jaime for your comment and appreciation. Do share it with your friends too :)

[@ChesireWaltz]

I wanna cry, why did my professor make this so much more complicated than it needed to be. I felt like I got slapped with the book the first time we talked about it. Thank you so much, now I know where to go with this!!!!

[@ashutoshkumar4099]

First cry and then comment

[@hamadoumoustapha1469]

And seriously, who will say Talent does not exist. All the timing, the animation as well as the delivered information are totally well coordinated. Looks like an Orchestral Event !!! Thank you so much Sir for such saving time and amazing lectures :-) Keep it up Sir ! From a French student

[@LuisCarlosSolano]

What incredible talent to teach! Thank you very much, indeed.

[@GlenMillard]

Good job - all of these videos were a big help - I really appreciate these videos. I thank you. They make it much, much easier to understand the 1NF, 2NF and 3NF :)

[@sweet-pe7re]

thank you so very much for this series, this seemed so complicated before, but turned out to be so simple.

[@nishadt]

I like your simplicity and humble voice while explaining a complex topics. Great Work. Keep it up !

[@shelbyfaaron739]

French student, found this very helpful, thanks a lot!!

[@hvrry]

Hey, this series really helped on my database final. Thanks!

[@hanyan2676]

Can't believe your examples are so simple and stright-forward! Much love!

[@Studytonight]

Thanks for your feedback 🙂

[@1983saulomoreira]

The way you explain makes everything easier, thank you for creating these videos for us.

[@Kam59045]

I loved these videos so much!! thank you for making my life so much easier

[@183harsh]

This video makes me strangely homesick. I'm a CS student in the US but now I miss the simple clarity of Indian teachers and how exams were set up.

[@arjux4724]

you graduated ?

[@simplemente_humano]

Concise and clear, unlike my textbook. Thank you for these excellent videos.

[@santhoshb1087]

An explanation with simple examples..once you saw this videos you never forget the concept..

[@jasonhare3890]

I am watching this to refresh for a test in school- way better than the class I paid a few thousand to attend-

[@045sakshimishra7]

I am really very happy about that I found your channel...your way of explaining topics with examples and the presentation both are mind blowing.

[@VineetKumar-fk2rl]

Never understood any better than this!! Searched many videos but your videos are consise and clear Thanks a lot❤

[@yevgeniydiriyenko4457]

I am so glad i ran across this "definition" as all textbook definitions are nothing but jargain. Thank you!

[@backrideprincess]

July 2020 subscriber here! So helpful in this time of pandemic as we go online classes, simple yet very informative, thank you for this 🧡

[@manvaditya8092]

Really good work! i have my assignment due EOD and these videos are helping me a lottt

[@darshna21]

These videos are much fun and light to watch and understand Thank you so much

[@kekere04]

These videos of yours just made me realize that there is nothing wrong with me! I not stupid neither am I slow. There are illustrators and then there are TEACHERS. You, sir, are a TEACHER! I am in deep awe at the way you have simplified these hard-to-grasp concepts. It's also fun to learn! Thank you!!!

[@Studytonight]

Hey Adetola, Your comment made our day :) Thank you for loving our video. Do share the videos with your friends and colleagues who are facing issue in understanding these concepts in class.

[@AdityaJain24]

Awesome videos! Really helpful. Easy to understand and saves a lot of time. Keep up the great work!😀 Looking forward to have some more such videos ahead.

[@Studytonight]

Thank you Aditya!

[@ghulamrasuldev]

3:14 yes we did it, and you deserve appreciation, love from Pakistan.

[@BenTampa]

I just learned normalization from your videos! Thank you!

[@wanigrace5997]

Thank you very much sir, all the tutorials about Normalization were very useful to me

[@ptrikha1]

Fantastic Video- I had been looking for such a nice video on Normal forms and found this. Th concept of Transitive dependence is something that not many understand and was clearly illustrated here.

[@pichazai]

These videos are life savers🙏thanks

[@deepdeep-kh2jt]

this video is easy to understand, I swear I couldn't have got from reading books about this, thank so much for this video.

[@wednesdaysangel1]

thank you for the explanation, it is very useful, my first assignment in SQL implementation class is how to take the values for an invoice at a veterinary clinic and then putting it in a table, and then progressively transitioning the values for the columns into 1NF, then 2NF, and then 3NF, all in a one page word document, so this is very useful, thank you.

[@arvind_purushotham]

1:29 my exact feeling at right time..wonderful teaching

[@gazesalso645]

These are great videos. Thank you. Personally though, I find that the slides move too quickly, so I'm still trying to figure out what the table looks like before it moves on, sometimes to unnecessary slides like "you must be thinking how?". The format used in the normalisation intro and 1NF videos I thought were easier to follow where the tables were left on the screen and the cursor was used to point out what was necessary while the narrator spoke. This format I think would make even more sense where dependencies are being explained.

[@nezrealtan3875]

Nice, I watch from 1 until 3, easy to understand, clear example.

[@ashanisuranga2687]

Thank you very much❤. With this vedio i learn normalization in 30 minitues, while my collage took 4hours to teach but yet i did not understand until now

[@rohanbhagat1317]

Really loved your videos sir I couldn't have learn it In any better way Thank you Sir

[@DJ83596]

I was quite in a struggle to understand these normal forms, and this series helped a lot to understand them. Thanks for the help! Keep up the good work 👍!

[@Studytonight]

Yesss 🙌🏼 so glad it is helping everyone ❤️

[@MagzHD0113]

shut up NERD

[@basatejaz6469]

Excellent selection of videos. Well presented and easy to understand. Thank you

[@harmanbedi7577]

really amazingggg...likee best explanation everrrrrrrrrrrr......thankyouuuuuu soo muchh

[@Studytonight]

Thank you :)

[@adeelsaigal713]

You are such an underrated youtuber, hands on for this really nice playlist for us ❣❣

[@ced4298]

Love the Colbert victory Gif! But the information is even more valuable!

[@GeethaGeetha-hj5de]

I am very confusing whenever study about normalization, but now I got clear idea by ur video,thanks a lot.

[@vineelapallapu8350]

Love your explanation.....thank you so much

[@molyshikder4987]

Your videos are really helpful. Thank you so much.

[@arbazkhan-je6bj]

Thanks sir for teach us indian students love you lots....make a lots of videos for us

[@jineshdave6451]

The explaination of exam table n total marks was fantastic.....Thanks sir :)

[@vaibhavmoharkar2349]

Yaar, you teach the very critical concept in very easy way. wow

[@teccitv8613]

thank u bro ! all my support from algeria .

[@mingminglu1711]

Thank you so much for such easy to understand explanation.

[@PatronSaintOfPigeons]

This is so much easier to understand, seriously, and I only had to rewatch it once.

[@Studytonight]

If you had to re-watch it, then we failed. Next time, we will try to make videos which you will understand in one go.

[@challasaibharath4866]

@@Studytonight your a gem of a person 😊

[@jiwachhetri4165]

Amazing work. Please don't stop posting videos !!

[@deekshithhn6391]

your vedio helps a lot in understanding concept in simple way

[@abdullahmaqsood3962]

You're a life saver.

[@sanjuadhikary4652]

Awesome explanation in simple and concise manner

[@liamk.2162]

Yo thanks Abhishek! This video was lit, needed this

[@alekhyapajjuri]

Thank you for this series of videos!

[@inspiringworld1120]

You have beautifully explained Thanks for this lecture

[@fadelnasution2862]

gonna take a test for a IT bootcamp but I have 0 knowledge, This channel help me a lot to catch up the materials. Thanks sir!

[@jeffreycruz3743]

you're so helpful, thank u so much!

[@suryatanyarout3551]

Thank you!!!!!!!!! Perfect explanation

[@vinitpatel7600]

very simple and clear explanation. Much helpful!!

[@shadmanahmed3666]

thank you for making such an educational video

[@hjcastellanopersonal2]

Very good video! It keeps you paying attention and it´s very likeable. Everything is well explained and very easily. Thank you!

[@Studytonight]

Glad you enjoyed it!

[@yatharthbhardwaj1225]

Brother great work ,you are last time gob for me.

[@krishnandah3217]

Very good teaching. Now I am very clear about normalisation. Thank you very much sir.

[@professorsarcasm]

thanks for the video, much easier to understand than my class text!

[@JohnSmith-zl8rz]

this is way better, no background music and better voice sound

[@valerybanadzem5900]

Excellent explanation. Thanks a lot

[@stoianrobert]

Very good explanation! Thank you AGAIN!

[@RoPPaFu]

LOVE YOU.....YOU ARE THE BEST TEACHER....!!

[@joekibz]

Normalization explained in a really simple way! Thanks 4 this ...

[@Studytonight]

Glad it was helpful!

[@nivid6484]

Thankyou for explaining normalization very clearly

[@garyjohnston2777]

Thankyou I love all your videos keep them coming I just subscribed

[@abrhammamuye1361]

Easy and best explanation. Thank you man

[@ozgurbaskn7559]

Very clear explanation. Thanks

[@nagendrakumarbhupathi2342]

excellent explanation sir.. thank you very much

[@lavanyam1511]

1:28 My exact reaction!! lol. You guys slayed it!!

[@Sindhu-qy1gd]

Same here😂

[@larrylyu9570]

Great content!Could you tell us how to decompose 3NF with algorithm in the simplest way?And BCNF?

[@saurabhkirgat839]

You know what you are just amazing!!

[@safiyyahnawaz-q2i]

so useful video thank you sir 🙌

[@sajishavs5589]

Very informative.. Expecting more videos on this subject

[@janaka123kandy]

Actually a great tutorial appreciated brother

[@peacemostimp6639]

Superb video..Must watch

[@jay_with_the_real6381]

This is so helpful!!

[@vincentmalinga5233]

Brilliant !! , thank you So much

[@ivansolares8919]

These are the BEST explanations, thank you for this!

[@Studytonight]

You're very welcome! 🙂

[@bieberpurple08]

THANKYOU FOR HELPING ME IN THIS PANDEMIC!

[@aravindreddy4507]

Great work, Team!!! Kudos

[@headyshotta5777]

My instructor spent 15 week teaching 3 normal form. You explain better than professor in 15 week of 8 hours a day in 4 minutes. Thank you for this 😊

[@Studytonight]

Great to hear!

[@yulin2707]

thank you so much, really clear and well-structured video

[@Studytonight]

You are welcome :)

[@haomai6937]

I have been struggling with this class since my semester started. Thank you so much for breaking this down!

[@harshadissanayake5269]

im from sri lanka.I watched many videos to get an idea about 3NF. But can't be got the exact idea. But you're the man.

[@Studytonight]

Thank Harsha for the appreciation 🤩 and I am glad that this video helped you. Love from India !!