1st, 2nd and 3rd Normal Form (Database Normalisation)
ฝัง
- เผยแพร่เมื่อ 6 มิ.ย. 2024
- A beginner's guide to first, second and third normal form when dealing with database normalization.
Like the video? Buy me a coffee and help me make more videos :-)
www.paypal.com/paypalme/richa...
In so many courses, they use ridiculous language almost to make the information as indigestible as possible. Thank you so much for making an effort to convey a cohesive idea. Academia should learn a thing or two from you.
I'm glad it was helpful! :-)
agreed!! in university they would spend an hour to explain it, while still making the students confused
OMG I agree. Its sucks because database and design is super important but is the dryest material ever.
Need advice for normalisation of a database for purchases in a book store
How would I normalise a table in 1nf 2nf and 3nf that has details for a customers purchase of different books-including Author, title, purchase date, price. There is 7 different books, with all the information above for each of the books
Also for the purchaser there is contact information such as name and address. Can someone please explain this properly or give me an example. Thanks!
Thank you! My course material made this needlessly confusing.
Thank you. My teacher spent over an hour confusing everyone instead of just laying it out simply. You saved me from that confusion.
he saved me too
:+)
😂😂😂👍
This is actually an extremely amazing, if not the best breakdown of the three normal forms by far.
Stopping the video at 5:14 to make this comment. You put the first table into 1NF, but then to move on, you switched to a completely different example. From a viewer's perspective, it would have been more helpful in creating understanding to have the same example follow through all the forms of normalization. I'm not ungrateful... I truly appreciate this video! It's just a suggestion. :-)
its done tho, can't simplify further
@@studious_viewer I believe that Tracy means to say that he should have chosen a single example that was unstructured which could then move all the way to total normalization.
I think that this would actually be better done as a "part 2" so that each transition can be viewed both in a vacuum, but also as a complete series of transformations.
omg bro you are like a water in the desert I was just about to give up on my assignment and saw your video thank you so much!
Bro came in clutch night befor exam, ily
Its incredible how much easier things are to understand when they are explained in simple terms rather than overcomplicated messes full of jargon.
The 1st Video that explains the concepts in a way that makes sense to a beginner. Thank You!!
Simple explanation and examples. What a textbook can't do in ten pages is done in under 12 minutes. Thank you for taking the time in making this video, please keep up the great work!
I have seen lots of explanations about table normalization and I believed this is the best of them all.
Love the bullet points. Straight and sweet to the point. Keep up the awesome work.
Very good tutorial. Definitely the best tutorial Ive seen so far
So easy to understand. I spent way too long being confused by a text book and you helped me grasp the concept in a fraction of the time I spent reading. Plus...your voice is nice to listen to.
From all the tutorials i've watched regarding this topic, this is the only one that made me understand completely the 3 Normal Forms.
Thank you so much ♥
This is such a clear and concise breakdown. Was trying to learn about DB normalisation from a textbook and it was so boring. Thank you very much for making this video.
The one tutorial to rule them all. Thank you so much for this super easy and short explanation.
This is so much easier to understand than in my university course. My lecturer spends 2 ours on a topic overcomplicating it and throwing in fancy terminology. This is clear and concise and easily coneys the topic. Thanks :)
I've watched like 5 NF videos and this is the first intuitive one. Thank you
Really great video. Not excessive, explained everything I didn't understand in perfect clarity. Will be watching your channel in the future!
literally the only video on youtube that explains this clearly. Thank you good sir
Easily the best explanation and example ive seen on youtube
Thank you! Thank you! Thank you! You explained concept in 11 minutes what others couldn't in hours.
Thank you so much read this in a textbook 3 times and it never got clearer! This really helped out
A simplified explanation for this topic, which may appear complex to some, including myself. I really appreciated this tutorial, thank you!
Great job! I feel like it's easy for normal form to get confusing but you showed it's actually pretty easy
You summed up and explained in 12 minutes what my instructor couldn't do in 3 hours. Thank you so much.
Glad to be of assistance!
it was so hard for me to comprehend this topic....but you have nailed it this is the best explanation ever on normalization . thank you so much
You're a legend, mate. Thanks for the easy to understand tutorial.
Clean and simple explanation! Such a great tutorial
Thank you for this explanation! I'm retaking a databases course, and the first time around, I had trouble understanding normal forms in lecture or from the verbose section in the textbook. This video, however, is very easy to understand
Best video of normal form so far. Luv you!
you saved me with this, i was so stressed about it during my lessons
Thanks, I already knew how to do db normalisation (I can do it without thinking), but I need to "show my workings" for an assignment and I tend to get lost in the rules of the normal forms, this explanation is a big help! -your mention about splitting first name, last name is interesting, as I've seen people advocate for either approach (splitting, or leaving the full name). I think the best wisdom on the matter is, it depends on whether one needs to access the first name and last name separately or not. If no need, they can remain joined.
waittt, a simple explanation? Thats rare. Bless you g
Thank you!
The best explanation I've read so far.
Thanks for this video, currently taking Database Management & Design and this is a great resource!
Simple and Amazing! Feel thankful watching this video!
This was so much easier to understand than my textbook, thank you!
Seriously the best video on normalization
thank you after searching tones of source about normalization your description quite understandable
Good explanation ....But I feel if u had used a single example would be great.... deducing it from 1NF to 3NF
Straight to the point and easily understood. Thanks!
Nobody made it simple to understand like you, millions thumbs up for you, but there is no transitivity seen between the non prime attributes in 3NF. Thanks
so clear, thanks. Makes normalization really understandable
Had a 2 hour lecture and couldn't understand what you just explained in 10 minutes, thanks so much.
I don't want to get ahead of myself, but I think you got the gift of teaching. Can't wait to check out more of your videos
Thank you very much for your comment! It's greatly appreciated! 😊
how did you manage to dumb it down so easily? Other explanations on YT are boring and confusing, but this video just made it make sense.
Out here saving our A Levels
This was 2 50-minute lectures in my Database class, and it still didn't make sense. This is a 11 minute video which clearly explains what each form is and how to make a database comply to a form. Thank you.
Thank I god I stumbled upon this video I literally have an exam in 6 hours and this helped me a lot.
So clear. You saved my mid-term exam.
you actually helped me pass my exam of databases
thank you a lot
Very clearly explained. Thank you for uploading this!
This was amazing and straight to the point. Thank you.
Liked this tutorial. As Michael Scott would say: "Explain me as I am 5" - You just did it. Thank you
proudly calling you my teacher
Thank you for the efforts at creating this video. It makes me understand the concept.
You're very welcome!
Fantastic video mate cheers best explanation I've heard
Your tutorial is a gem, mate!! It's really simple, the examples are great, and (not to be racist but I feel every European that has recently started messing with programming) you speak in fluent, understandable English. I'm having such a hard time to understand Indians trying to explain anything in English, which is such a pity if you consider how great some of their tutorials are
Very good. The specifics I think are more important and better at communicating the theme then the broad analogy technique.
4 years later... tomorrow I am going to have a meeting with a colleague from Data Science who disrespected 1NF.
I don't know who or how is listening to me, but I didn't know anything about this and TH-cam suggested this video in the New for me section of the Home.
I feel like having buffed up with a side quest before having to beat a boss.
Thank you! Got exam in Database on tuesday and you saved me
I did not get it until I wrote everything down and drew the tables, then it clicked, thx for the video!
This helped me more than office hours thank you 🙏
This helped me so much. Thank you!
Pretty neat, Spent hours trying to understand the material provided by the university, even failed a test. just watched this video and now understand 1NF, 2NF and 3NF.
I was banging my head on the desk trying to understand it from my textbook but this really cleared things up, great video
Glad it helped!
this is so much easy to understand. thank you so much!! :D
Wow, this was so simply explained, it could be taught to kids in preschool 😬💯
Thank you so much. I think you illustrate it much better than my professor. I think my professor simply wasted my time. From now on, I decide not to attend her lectures any more, but listen to your lecture instead.
Awesome video. Thank you!
That was much more helpful than my college book. Thank you.
this video is awesome! Well explains these three concepts
Lovely and clear, very well done - thank you!
It would have been much better if you have used one (unstructured) example through out the video, and made use of keys on the 3NF because one person could be a winner more than once in different years of course or names be the same (highly unlikely but possible). Besides that, great tutorial, you made it much easier. Thank you.
I agree that using the same dataset from start to finish might have had its own benefits.
However, from the example you cited, even if the same person with the same name won all tournaments in the same year or multiple years, does it distort the 3NF?
Won't every record or row still be unique as tournament names and years do the distinguishing?
This was awesome! Thanks.
Overall beautiful clip, greatly appreciated!
Very Good , easy to understand !
This helped a lot very clear explanation
This made no sense in my book, but you made it so simple. Thanks!
Thank you. My teacher took 6 months trying to explain this but still didn't understand him, but you took less than 15 minutes
Amazing tutorial! Thanks for this!
Thank you so much for your effort
Also best tutorial keep going teacher🙏
Extremely helpful, thank you!
best one I found on youtube
Amazing explanations!
really great video! thank you very much:)
Great and easy to understand explanation in a short amount of time
Glad it was helpful!
Thank you sir, you have saved my life!
Very good and simple explanation.🙃
So easy to understand. In such a short time. . ❤❤❤❤❤ thank you. .
I'm glad you liked it!
It's really helpful for my assignment. Thank you so much sir :)
I was completely lost with normalisation, thank you for explaining it
You're welcome 😊
This is such a helpful video!!!
Great explanation, thank you!
Very nicely explained
My online college instead of teaching a lesson on this just linked to this TH-cam video lol.
thank you, very good tutorial and easy to understand.
Great explanation
i think you are the most clear