I've been trying to understand how to identify the rules. This is by far the only thing ive seen that made it easy to understand normalizing databases and how to break them down. Thank you sir!
@Sdirimohamedsalah
3 ай бұрын
Thank you for this tutorial, The third rule (country, city…) Generally what i prefer is to put city id, state id , country id in the same table to directly and joins them in one query, i believe that reduce the complexity of getting data.
@JKarle
3 ай бұрын
A fantastic and easy to understand explanation of normalization as a whole, and how each level of normalization (1st to 3rd) differs. Thank you very much.
@nenadsavanovic8628
2 жыл бұрын
Best video I have been able to find on Normalization. Love it!
@PaperRaines
2 жыл бұрын
This video was savage! Explained so many things that eluded me for years, thanks so much 😊
@jamesbell8861
2 жыл бұрын
Thanks !!! You explained it way better than the textbook !!!
@thebulletkin8393
Жыл бұрын
isn't the third normal form just the second but done again? Since it just has you checking through to make sure that all the non key values depend on the primary?
@ereh_yeager
2 жыл бұрын
Thanks for this, helped me understand normalization easily
@nniiiluuu
5 ай бұрын
Orderitems stores the quantity and price per unit. Orders stores ordertotal, which is a derived attribute (sum of the ordered items*quantity). I'm curious why you chose to store the ordertotal in the table, should we not remove derived values in 1nf?
@Veikkuu
8 ай бұрын
Super clear tutorial, well done!
@sardorabdirayimov
Жыл бұрын
Great tutorial. I wonder if you can tell which app did used for visualization of database notation in the end of the video :)
@JoLynch0
Жыл бұрын
around 5:00 mark, wouldn't you say that "Address" is not yet an atomic value, thus not meeting 1NF?
@Ex-Clamation
Жыл бұрын
This is the source that made it make sense for me. Thanks.
@hasanmougharbel8030
2 жыл бұрын
Hello there, glad to meet again. I have a simple enquiry.. In what case it would be convenient to apply BCNF form of normalization to my data? Thanks for taking care of this.
@UvanSankar
2 жыл бұрын
Great work man!
@رند-س5ح
2 жыл бұрын
Thank you so much. You can’t imagine how much it is helpful
@hcetc
3 жыл бұрын
Wow man! Wonderful explanation.
@tadeob_UB
2 жыл бұрын
Amazing video! packed with helpful information and easy to understand. thanks a lot
@nathankirklambo1986
5 ай бұрын
Totally rad, dude!!
@brunoggdev6305
Жыл бұрын
What an amazing video, great work
@mateuszmiskiewicz3823
2 жыл бұрын
Not the best example. If you don't have a composite key, then your table already is in 2NF. Instead, what you're showing here is basically 3NF, not 2NF.
@LeEnnyFace
Жыл бұрын
Exactly. He basically did 3NF twice
@MaxMineur
2 жыл бұрын
Thanks, very helpful!
@PetrosMengsteab
Жыл бұрын
Great video.
@o-o857
3 жыл бұрын
I swear every video on this topic has different definitions for 1NF
Пікірлер: 26