bless u, much better taught than my shitty lecturers
@gieslermapute98218 жыл бұрын
I feel u dolan, Keep those MLG montages coming though i enjoy your content
@MightyP8 жыл бұрын
Wow Wasnt expecting you here
@GrootGuitar7 жыл бұрын
What brought you to this video Dolan?! You taking database management at the moment?
@quirkyjaywalker7 жыл бұрын
Wow
@zero5557 жыл бұрын
is the legendary Dolan
@davidmaiolo8 жыл бұрын
Watching this 20 minutes before my database final. Thank god this is only 19 minutes.
@amiladrck8 жыл бұрын
lmao tomorrow morning I have DBMS exam and it's late night now.
@davidmaiolo8 жыл бұрын
+Amila Abeygunasekara good luck. I passed my class :)
@amiladrck8 жыл бұрын
+David Maiolo thanks mate!
@mingthemerciless8348 жыл бұрын
same
@Tamerlane6197 жыл бұрын
same
@sburns909 жыл бұрын
This video was more helpful than the college classes I pay for. Thanks for creating this video.
@Rlaxox8 жыл бұрын
+Steve Burns Haha ... so true lol I have a professor that makes me go to sleep every time he talks No hard feelings ofc but I learned more in this video then I ever did there
@dustinbishop9658 жыл бұрын
Lol....I think we have the same instructor
@senciddimisin8 жыл бұрын
+Steve Burns so true.
@evncliff4d8 жыл бұрын
+Steve Burns Agreed! They all keep using the same dry examples from the 80's. This was great!
@GilbertMartinelli7 жыл бұрын
Because most employers aren't going to just take your word for it that you studied. They want a piece of paper from a place they can look up that shows you've been tested on the subject matter and passed.
@monkeman46923 жыл бұрын
So are we all here before an exam?
@auleian4 ай бұрын
yes😂
@JiaSki3 ай бұрын
Yes o
@monkeman46923 ай бұрын
@@JiaSkigood luck broski 🫡
@rupaldhurde59372 ай бұрын
Yeah bro
@monkeman46922 ай бұрын
@@rupaldhurde5937 gl m8 🫡
@ammarthemartian3 жыл бұрын
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!
@devonligaray2448 Жыл бұрын
Hi please help may code
@hanzalamansoor11 ай бұрын
18:07 is 5 n.f
@Fireprincess1613 жыл бұрын
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.
@greenpocket_raw4 ай бұрын
I am dumber. I thought black is the new beautiful.
@troykachor35218 жыл бұрын
5 classes, in 10 minutes (skipped through a bit). Final in 7 hours. You saved me a ton of sleep. Thanks!
@hudsontaylor25158 жыл бұрын
+Troy Kachor Hahaha Ikr! All the best! Final here in 19 hours.
@venublanco66298 жыл бұрын
+Troy Kachor hope you both score great :)
@ayyjayy50188 жыл бұрын
+Troy Kachor 12 hours ayyy
@8ZZZZZZZD8 жыл бұрын
+Troy Kachor hahaha final in 11 hours!
@MasonCYT8 жыл бұрын
+Troy Kachor Last minute studies ftw
@michaelwhitlock73982 жыл бұрын
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!
@kittycatbuttbutt8 жыл бұрын
more helpful than several weeks my professor spent on normalization. Thanks
@IchigolovesRukia78 жыл бұрын
That's true! Good explanation +channel5567 :)
@bryanhall92304 жыл бұрын
I just finished this chapter in my book and it was tough to read. Your breakdown really helped! Thank you!
@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.
@Sean-jd1hy4 жыл бұрын
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.
@Noahh_jp3 жыл бұрын
slacked off all semester. final is in 30 mins, just finished this video and completely understand it. Phenomenal.
@bryanurizar3 жыл бұрын
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.
@BhagyaBlossom3 жыл бұрын
Exactly, I kept thinking that wilson44 is repeated even though it's a primary key. It needs to have all unique values. but he never addresses it.
@vanlalhruaiiswansi51823 жыл бұрын
I think because the table is not an "Employee" table and wilson44 purchased two different items and also subscribed to two different newsletters.
@gpk64582 жыл бұрын
Yeah... video is incorrect. First table should have order ID or something, not customer ID.
@kyleclarke48452 жыл бұрын
Well the user ID's are unique because they're like usernames on social media - they can only be used if they're not already taken.
@kyleclarke48452 жыл бұрын
They are normalised, they're just secondary keys, not primary ones.
@Helloomadison2 жыл бұрын
This man out here saving lives. Actual saint. Thank youuuuu for finally explaining this in human/real terms sir!
@smoothbeak3 жыл бұрын
This is one of the best videos I have seen on this topic. Great example, and great explanation.
@mussieg58077 жыл бұрын
Thank you so much. Now, my head is functioning Normal with your Normalization lecture. Definitely, better than what I learned in class.
@CS-bl2sz4 жыл бұрын
Simple but understandable for beginners, way better than explanations in textbooks
@PHYCHOLOGICAL13376 жыл бұрын
The most accurate and clear explanation for normalization you can ever find. Your work is amazing, my friend.
@philipbein35864 жыл бұрын
you deserve $123,000 dollars a year because you taught me what my professor couldn't in thirteen minutes, godspeed and good luck
@zlotnleo7 жыл бұрын
Cust ID can't be a primary key unless you introduce a list of unique customers. There's a duplicate wilson44 Cust ID, which means it can't be a key. You'd have to introduce a column Order ID or similar. (In 4NF this problem simply moves from Customer Table to Subscription Table)
@luke.43173 жыл бұрын
how would u fix the problem on the bridge table ? i was thinking about adding a quantity row for not preparing (ex: Wilson - xbox) srdy for 4 years later lol
@bendruce6672 жыл бұрын
fr
@Alpaca_925 жыл бұрын
I've been learning SQL on my own and you explained this topic very well. Thank you.
@zaitieamirah98763 жыл бұрын
This man explained it logically. I can picture the database inside of my mind and how it works. My lecturer didnt do this. She just poured out theories and didnt explain it
@Bornheck3 жыл бұрын
Mine posted hour and a half long videos expecting us to be able to pay attention that long
@budatn5 жыл бұрын
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!
@milanmijailovic97658 жыл бұрын
Subscription table has error. You have to add ID column, because wilson44 appears twice...
@spiritofslumber8 жыл бұрын
+Milan Mijailovic Indeed, imo they all should have ID columns, especially invoice too. What if a customer buys another playstation or any item multiple times?
@aishikbhattacharya48708 жыл бұрын
Can you please explain why there is a need of 3rd table in 2NF?? We could have added aother column in the frist table and entered the name of the products along with the newsletters.
@trnek8 жыл бұрын
This table should have compound key like sales invoice table. There is no possibility to one user has the same subscription twice.
@mikejohn80308 жыл бұрын
you need to have a seperate table for cust_id and newsletter.
@bharathsairam4437 жыл бұрын
I totally agree with you and please find my reply to solve the issue..
@marjoriefreeman61605 жыл бұрын
Thank you SO much for this video. Less is more (and just enough). This was perfect and SO organized and thank you for building on each example, too.
@mikeandrewfernandez9797 Жыл бұрын
Damn, you just made normalization easier. I was having trouble identifying dependencies but the way you explained it was as accurate and practical as hell. Thank you for this wonderful video!
@zagreus63004 жыл бұрын
thanx dude now i can get 5 marks,now only woried for 95
@PanzerFaustFurious7 жыл бұрын
Protip: Set video speed to 1.25x or 1.5x
@osamajandali7 жыл бұрын
I used 1.5x and feel he talks normally and at last minute I return it back to normal, I felt that he have taken some kind of drugs
@semirumutkurt66357 жыл бұрын
i really want to thank you/ life pro tip
@PrimeFreedom20087 жыл бұрын
LOL
@Noblessed77 жыл бұрын
1.5 was good enough for me
@matthewhowes47757 жыл бұрын
2x even better
@frankm355065 жыл бұрын
"There's still a question about this, Alan Smith....."
@dmeskhi7 жыл бұрын
There are dozens of videos out there on KZbin but this one is the best. It explains on real life kinda scenario and is easy to understand all these functional dependencies. Thank you sir very much.
@yasirzubair20 Жыл бұрын
Clearly explained throughout the entire KZbin platform!
@Noahh_jp3 жыл бұрын
1NF is about 5:12 ... 2NF - 7:45 about... 3NF - 13:27
@theletterpurple62287 жыл бұрын
this helped a lot. when youtube is a better teacher than you pay for. :)
@smtxtv4 ай бұрын
Yep. Great explanation. You uncomplicate what has been previously presented in a disjointed, convoluted manner. Thx ! What I needed, for sure.
@kmekky38702 жыл бұрын
I come from the future and your work is still highly appreciated 🙏. Thank you Sir.
@catlord695 жыл бұрын
love the real-world examples and little details (allan thomas smith), good job
@SaiChandPasupuleti5 жыл бұрын
If I have watched this video before 3weeks by this time I will be working in an company which I have attended before 3weeks and they have asked to explain normal forms with tables as examples but I don't know this concepts at that time but I had answered other all queries now I was confident I can crack any interview after watching this video Thanks man good explanation keep going !
@graceherbert74012 жыл бұрын
Was going around in circles looking for an understandable explanation, now click! Thank you!!!
@karensynesiou77504 жыл бұрын
Fantastic explanation. Learned more from this easy to understand explanation than from several videos I have watched. Thank you.
@ranjan_v5 жыл бұрын
Thank YOu
@jadeite207 жыл бұрын
how can you have duplicate values in Primary Key column ? If that is the case, don't we have to combine it with other columns to determine a candidate key?
@muhammadnurirsyad98875 жыл бұрын
its actually true, as it called as the composite key, that merges the primary key and candidate key(s) for a better specifications on determining its values
@neerajce3 жыл бұрын
They are just identifiers and not primary key.
@MZKLORD2 жыл бұрын
This video as good as 2hours class at my UNI. Thanks for creating this video.
@Dentiddo3 жыл бұрын
Appreciate the video tutorial. This does bring some clarity to what normalization means in these databases. This is my first time studying databases (DBMS) and its a lot to take in, but I appreciate videos such as this one which brings more understanding to these database concepts. Thank You
@MaheshBabu19898 жыл бұрын
Everything is good but at last i am bit confused.. In Subscription table you said Cust Id is a primary key.. But it is having multiple entries (one for xbox and other for playstation) for customer wilson44. Primary key will not allow multiple records belongs to same id. Correct me if i say something wrong..
@IgorAherne8 жыл бұрын
8:36 I think it indeed will be a "foreign key", not a "primary" Also, quoting a comment below: Primary key cannot repeat the same value and must be unique in relational database. Thus, it will require an extra "id column" to make each wilson44 unique.
@clarianken42238 жыл бұрын
@Igor Aherne check my query pls..?
@8a1ad61b8 жыл бұрын
I think he is talking about the subscription table at 18:33. In that case, I think the combination of Cust ID and Newsletter is the only valid candidate to be a primary key.
@Cornellie7 жыл бұрын
I think he made a little mistake as you were able to spot it easily, "Cust ID" column in the "Subscription Table" should be a FOREIGN KEY instead as a PRIMARY KEY is always UNIQUE and does not allow duplication. But it was a great video though it helped me a lot, I'm having trouble normalizing my database for a college case study :p
@BurninRevolver7 жыл бұрын
You should watch you fellow indians tutorials
@hotmandead17 жыл бұрын
This is the best lecture on normalization I have ever seen thank you
@juliocheranthonypenaperez79194 жыл бұрын
Aquí tienes un mensaje en español de alguien que te agradece profundamente está clase, tras 6 años nunca entendí la normalización y en tan solo 19 minutos, me ha quedado mas que claro. Estoy agradecido infinitamente.
@scottmccarter39696 жыл бұрын
Thank you very much for this. I searched online for a couple of hours and no one explained it so clearly as you.
@SkillGamingNL4 жыл бұрын
There are a lot of things wrong with this normalization: 1. Subscription table should have a auto increment ID as primary key, in the result it has wilson44 2 times in it. This is not possible in a real database because the primary key always has to be unique. 2. Invoices table, in the result one customer can only buy a playstation or xbox 1 time. This is because custID and Item are a compounded primarykey, so if a customer tries to buy another playstation it is not possible(primary key duplicate). 3. The shipping address would NEVER ever get stored like that in a database, a better way of doing it is splitting the data in to multiple fields.
@chandrasekharp36837 жыл бұрын
Everything is good but at last i am bit confused.. In Subscription table you said Cust Id is a primary key.. But it is having multiple entries (one for xbox and other for playstation) for customer wilson44. Primary key will not allow multiple records belongs to same id. Iam confused at 4th normal form because a key attribute will never entertain same values to insert more than once so how we solve the problem on your given example particularly at (4nf) please elaborate the explanation. thankyou
@juhirawat42436 жыл бұрын
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
@user-dp7lr5qh6o5 ай бұрын
Thank you so much. After 8 years it is still helpful
@tjstudibros46777 жыл бұрын
for the first normal form, "wilson44" shows up twice. So how can the key uniquely identify each row if the key value shows up twice??
@NavalKishoreBarthwal7 жыл бұрын
I think "Cust ID" is unique but not a primary key... or shall I say a candidate key and in first normal form one need to identify each row uniquely. The trouble he had before was identifying "Alan Smith". If "Cust ID " is same then all information belongs to the same person. And we are performing normalisation because the table is badly organised.
@aayamoza84958 жыл бұрын
You repeated willson44 twice as a primary key, is that not redundancy? I learnt in 1st NF there should be no repetition!
@Thisisloco18 жыл бұрын
+Aayam Oza I noticed this aswell. I think if he should have another table with the Newsletter and a primary key. The table he created could use the Customer ID and the Newsletter ID together to create the primary key. Then surely you could query the database and retrieve everything belonging to a Customer ID and retrieve all the newsletter IDs? thats how i would do it
@aayamoza84958 жыл бұрын
That's fine if you are using two primary key!!
@muhanad1027 жыл бұрын
this is just an example so think about it that you want to to be different and unique here...the compound key is unique. If in any situation you think it's not unique anymore then you need to fix it...
@PK-db9qj6 жыл бұрын
You cannot have same entity in primary key. That's the concept of primary key - it defines all attributes uniquely. For ex- you bank account number can be primary key because every person in world have unique bank account number. If you have 2 same bank account number it will be disastrous as other person can transact from your account.
@ramakantasamal74826 жыл бұрын
I dont think it enforces primary key on the 1st NF. It says no two rows could have identical values which is not the case here. But as you move on the 2nd and 3rd NF the primary key will come into picture .
@parvez45063 жыл бұрын
Only 17 videos and 4.47k Subscribers. This is how quality works.... Thank you so much for the explanation.
@josayamanko78742 жыл бұрын
much thanks to you, this 20 mins teaches more than what i've learnt in 1 month.
@S0up3rD0up3r998 жыл бұрын
This was infinitely more helpful than the college class I'm taking going over databases -.-
@aoa0i2u8 жыл бұрын
very useful tutorial, just saved me a lot of time instead of understanding purely by reading notes
@adilmughal22517 ай бұрын
one of the best explanations on database normalization.
@muhammadsufi5103 жыл бұрын
i have exam tomorrow and i don’t have time to read 50+ slide that explain these things but at the end i know i wont understand that wordy slides. this video helps me understand so well within just 20 minutes. thank you so much
@joshuaturner40337 жыл бұрын
Thank you for literally saving my degree.
@freakymundo7 жыл бұрын
wouldn't the Shipping Adress not obey the 1NF? It has multiple values such as Number, Street, and City.
@randomuser664386 жыл бұрын
You get the idea
@breezycodes Жыл бұрын
7 years later & this is still gold!
@bhrzali Жыл бұрын
Love this tutorial. It's very precise, doesn't waste time, and gets to the point right away.
@nebula18638 жыл бұрын
Cust ID in the subscription table and sales invoice table must be a foreign key, not a primary key, am i right?
@hamidmehmood4728 жыл бұрын
+Nishant Revur CUS_ID in Subscription and sales invoice table is Primary key as well as act as a foreign key
@Ericsicons8 жыл бұрын
+Nishant Revur Yes it can not be a primary key on its own it must be a composite key with Newsletters as you can not have duplicates in primary key.
@tushars57248 жыл бұрын
Hi.. i have a small question... The rule of primary key is that there should be NO DUPLICATE ENTRY for a column, but in your explanation i see CUST ID with duplicate entries "wilson44" which violates the rule of keys. Can you plz explain your logic behind this? Correct me if i am wrong. Thank you.
@lionbarz8 жыл бұрын
+Tushar S CUST ID is not a primary key in the Sales Invoice table, so it can be duplicated. It's a primary key in the Customer table only.
@ronaldpasipanodya94908 жыл бұрын
+Mohamed Fakhreddine i believe Tushar is refering to the subscription table, you have duplicate entries "wilson44" on your primary key column. this violates the rule of primary keys which states that each key should identify a single row
@talhaiqbal93876 жыл бұрын
May be both the customer id and the shipping address should be the primary key here.
@andreibehjan96586 жыл бұрын
The Subscription table has what they call a composite key. The combination of Cust ID and Newsletter make the Primary Key.
@denistocilin87022 жыл бұрын
I have read 3 chapter of a book, dedicated to Database design and understood nothing from it. Thank you very much for this video. Now it makes sense to me and really helped to understand the material.
@virunpatolankitkunchai43142 жыл бұрын
I took 2 database courses in college but never really understand this topic. Thank you so much for the explanation. Now I understand everything
@arashm36697 жыл бұрын
cust ID was a bad choice. transaction or invoice id would be a better choice. you cannot have primary keys repeated
@fahimbaig8255 жыл бұрын
why would they both buy a ps4 if they live in the same house ? these the real question we all should be asking here ..
@CynicalOldDwarf5 жыл бұрын
They don't like sharing, and they want to play multiplayer without split screen cheating.
@fahimbaig8255 жыл бұрын
@@CynicalOldDwarf AND they wont have any ping problems if they connect them via LAN cable , the only way to determine who is better .. it seems i have underestimated the intellect of this man .. *tips his hat*
@mzwandiledlamini4552 Жыл бұрын
For the first time I've seen someone explain this clearly than my lecturers at school.
@1VESOH6 жыл бұрын
For the very first time, I have understood normalisation after many lectures and notes, Thank you
@030040782668 жыл бұрын
Hello , You First Normal Form is not Good. This is wrong . because you are making the customer ID (Cust ID) as primary key and willson44 are two time in Primary column. you should yellow (make primary key ) item as well . then its satisify the first NF. Then I did not go further as I don't want to make my concepts wrong. Regards, Your well wisher
@_.mochi___chan._6 жыл бұрын
That's why I left the video after seeing that the primary key is not even unique .
@MKouthere8 жыл бұрын
you are my savior
@qwerty865673 жыл бұрын
Excellent video. Very clear and minimal example which illustrates the concepts effectively. Thanks!
@pelelathabo89256 жыл бұрын
How convenient, my lecturer used the same example and explained it in the same level is explained in this video. wow good work tutor....
@jadeite207 жыл бұрын
2nd normal form first relation is wrong. Cust ID does not determine Newsletter. There is a partial dependency on 9:42
@hussainhaider31625 жыл бұрын
You're right. What do you think should be the solution? Put newsletter column into the other table maybe?
@ShukyPersky5 жыл бұрын
This video is superficial ... First, it doesn't explain anything about how PK (Primary Key) is selected along the way from FDs (functional dependencies), selecting SuperKeys => Selecting Candidate Keys => Selecting a Primary Key. As well, it doesn't say anything about 2NF rule that a non-prime attribute should not depend on part of the Primary Key (and for that, we are looking for a minimal Primary Key which has to do with Candidate Key). In addition, the "conjunction table" primary key is wrong ... think of that a certain customer will return to purchase the same product again.... so we are going to have duplication on the primary key which is invalid. This entity (table) requires a surrogate attribute i.e. purchase ID which guarantees unique tuples (rows), and I think that some attributes are missing on that table like date of purchase, quantity, cost, etc.
@joshuaaguilar10333 жыл бұрын
The comments in this video are a bit disconcerting. I read that many people, and I quote "Learned more from this video than from thier professor" or "Have a test in less than x hours and this video helped them to understand the material". This video has a bunch of mistakes! This is not a good refrence.
@theamazingmonkey1003 жыл бұрын
then make a video yourself if you think you can do better damn
@annjames65226 жыл бұрын
The example that you used here is so apt to understand the concepts.... now I finally understand the different kinds of normalization. Thank You.
@basetroll16273 жыл бұрын
Although a commentor pointed it out, channel5567 mad a mistake to call in the customer table the first col a Primary Key, since it PK must be unique, never NULL, and never change, that is a tremendous fantastic video about NF in databases. I have learned a ton with it. THANKS A LOT!
@Haapavuo8 жыл бұрын
NOTE: wilson44 CANNOT BE TWICE IN 1NF!! THERE IS A FAILURE IN THE VIDEO!
@jjthomson46098 жыл бұрын
1nf allows multiple tuples but not multiple valued attributes
@Abdzenq6 жыл бұрын
Lol could not understand this Normalization thing in 4 Months and tomorrow is my Exam i i just understood this in 20 minutes..Thanks a lot for such a creative and understandable video. Much Love
@DirectionNext Жыл бұрын
Thanks for creating this video. Simple, crisp and to the point with proper example. Amazing video.
@cairnebloodfist33477 жыл бұрын
By far the best normalization example I have seen.
@abdulrahmanlingga94204 жыл бұрын
I barely comment on yt videos but my time and energy will be worthwhile for thanking you. Thank you.
@ajaykiran77656 жыл бұрын
wow!!! wat a man u did a really gr8 job man... taught me many things in 19 mins!! thank u very much .. instead of paying fa stupid lectures i'm ready to pay u man!!
@bhsharma25 жыл бұрын
First time i got clear understanding of what the each of the normalization statements means in practical. Awesome Video, thank you very much for the great explanation !!
@yinhaodeng3 жыл бұрын
Extreamly useful tutorial! I am preparing for practical quiz on next Monday. Thanks!
@abdullahhaidar36586 жыл бұрын
I could've spent 100 hours trying to understand that from the teachers course, you saved me lots of time !!
@padoharaja45032 жыл бұрын
Love this one, i think this is the most clear explain on Normalization
@qdoan176 жыл бұрын
Why am I paying $1500 for a class at uni that teaches jackshit about databases when I could watch this 19-minute video that sums up everything. Thanks for the upload!
@kabelokgabo8806 жыл бұрын
This is the best Normalization video... everything was clear and it was audio-able
@desisto0073 жыл бұрын
Hands down the best explanation around. Just an observation, Customers Table and Item table represent the M-M relationship. Sales table is actually the linking table of the M-M relationship of Customer and Items. Great explanation though!
@nalakaviraj60164 жыл бұрын
This 19 mins is ,worthy than all the lecuture notes i had on dbms.
@inder19ify3 жыл бұрын
Best video so far on KZbin for this topic
@vasanthsrinivaspadmanathan21852 жыл бұрын
Very simple and effective way of representation. Much relieved! Thanks for this important post.
@Mahadonation17 жыл бұрын
thank you so much, finally someone who knows the importance of examples
@dev95458 жыл бұрын
excellent presentation ....in 19 min i have learned the normalization very easily
@yongyeserkfem67935 жыл бұрын
Your presentation was the icing on the cake, you solidified my understanding of the concept beyond my imagination. Thank you.
@BlazinWolfz3 жыл бұрын
This is the best normalization video to date. ty so much