bless u, much better taught than my shitty lecturers
@gieslermapute9821
8 жыл бұрын
I feel u dolan, Keep those MLG montages coming though i enjoy your content
@MightyP
8 жыл бұрын
Wow Wasnt expecting you here
@GrootGuitar
8 жыл бұрын
What brought you to this video Dolan?! You taking database management at the moment?
@quirkyjaywalker
7 жыл бұрын
Wow
@zero555
7 жыл бұрын
is the legendary Dolan
@sburns90
9 жыл бұрын
This video was more helpful than the college classes I pay for. Thanks for creating this video.
@RelaxSimmer
8 жыл бұрын
+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
@dustinbishop965
8 жыл бұрын
Lol....I think we have the same instructor
@senciddimisin
8 жыл бұрын
+Steve Burns so true.
@evncliff4d
8 жыл бұрын
+Steve Burns Agreed! They all keep using the same dry examples from the 80's. This was great!
@GilbertMartinelli
7 жыл бұрын
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.
@davidmaiolo
8 жыл бұрын
Watching this 20 minutes before my database final. Thank god this is only 19 minutes.
@amiladrck
8 жыл бұрын
lmao tomorrow morning I have DBMS exam and it's late night now.
@davidmaiolo
8 жыл бұрын
+Amila Abeygunasekara good luck. I passed my class :)
@amiladrck
8 жыл бұрын
+David Maiolo thanks mate!
@mingthemerciless834
8 жыл бұрын
same
@Tamerlane619
7 жыл бұрын
same
@ammarthemartian
3 жыл бұрын
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
@hanzalamansoor
Жыл бұрын
18:07 is 5 n.f
@monkeman4692
3 жыл бұрын
So are we all here before an exam?
@auleian
5 ай бұрын
yes😂
@JiaSki
5 ай бұрын
Yes o
@monkeman4692
5 ай бұрын
@@JiaSkigood luck broski 🫡
@rupaldhurde5937
4 ай бұрын
Yeah bro
@monkeman4692
4 ай бұрын
@@rupaldhurde5937 gl m8 🫡
@Fireprincess161
3 жыл бұрын
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_raw
5 ай бұрын
I am dumber. I thought black is the new beautiful.
@michaelwhitlock7398
2 жыл бұрын
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!
@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-jd1hy
4 жыл бұрын
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.
@bryanhall9230
5 жыл бұрын
I just finished this chapter in my book and it was tough to read. Your breakdown really helped! Thank you!
@Helloomadison
2 жыл бұрын
This man out here saving lives. Actual saint. Thank youuuuu for finally explaining this in human/real terms sir!
@CS-bl2sz
4 жыл бұрын
Simple but understandable for beginners, way better than explanations in textbooks
@smoothbeak
3 жыл бұрын
This is one of the best videos I have seen on this topic. Great example, and great explanation.
@mussieg5807
7 жыл бұрын
Thank you so much. Now, my head is functioning Normal with your Normalization lecture. Definitely, better than what I learned in class.
@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!
@SaiChandPasupuleti
5 жыл бұрын
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 !
@budatn
5 жыл бұрын
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!
@milanmijailovic9765
8 жыл бұрын
Subscription table has error. You have to add ID column, because wilson44 appears twice...
@spiritofslumber
8 жыл бұрын
+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?
@aishikbhattacharya4870
8 жыл бұрын
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.
@trnek
8 жыл бұрын
This table should have compound key like sales invoice table. There is no possibility to one user has the same subscription twice.
@mikejohn8030
8 жыл бұрын
you need to have a seperate table for cust_id and newsletter.
@bharathsairam443
7 жыл бұрын
I totally agree with you and please find my reply to solve the issue..
@zaitieamirah9876
3 жыл бұрын
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
@Bornheck
3 жыл бұрын
Mine posted hour and a half long videos expecting us to be able to pay attention that long
@Noahh_jp
3 жыл бұрын
1NF is about 5:12 ... 2NF - 7:45 about... 3NF - 13:27
@smtxtv
6 ай бұрын
Yep. Great explanation. You uncomplicate what has been previously presented in a disjointed, convoluted manner. Thx ! What I needed, for sure.
@marjoriefreeman6160
5 жыл бұрын
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.
@philipbein3586
4 жыл бұрын
you deserve $123,000 dollars a year because you taught me what my professor couldn't in thirteen minutes, godspeed and good luck
@PanzerFaustFurious
8 жыл бұрын
Protip: Set video speed to 1.25x or 1.5x
@osamajandali
7 жыл бұрын
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
@semirumutkurt6635
7 жыл бұрын
i really want to thank you/ life pro tip
@PrimeFreedom2008
7 жыл бұрын
LOL
@Noblessed7
7 жыл бұрын
1.5 was good enough for me
@matthewhowes4775
7 жыл бұрын
2x even better
@dmeskhi
7 жыл бұрын
There are dozens of videos out there on KZitem 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.
@troykachor3521
8 жыл бұрын
5 classes, in 10 minutes (skipped through a bit). Final in 7 hours. You saved me a ton of sleep. Thanks!
@hudsontaylor2515
8 жыл бұрын
+Troy Kachor Hahaha Ikr! All the best! Final here in 19 hours.
@venublanco6629
8 жыл бұрын
+Troy Kachor hope you both score great :)
@ayyjayy5018
8 жыл бұрын
+Troy Kachor 12 hours ayyy
@8ZZZZZZZD
8 жыл бұрын
+Troy Kachor hahaha final in 11 hours!
@MasonCYT
8 жыл бұрын
+Troy Kachor Last minute studies ftw
@juhirawat4243
6 жыл бұрын
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
@SkillGamingNL
4 жыл бұрын
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.
@PHYCHOLOGICAL1337
6 жыл бұрын
The most accurate and clear explanation for normalization you can ever find. Your work is amazing, my friend.
@theletterpurple6228
7 жыл бұрын
this helped a lot. when youtube is a better teacher than you pay for. :)
@parvez4506
3 жыл бұрын
Only 17 videos and 4.47k Subscribers. This is how quality works.... Thank you so much for the explanation.
@denistocilin8702
2 жыл бұрын
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.
@frankm35506
5 жыл бұрын
"There's still a question about this, Alan Smith....."
@kmekky3870
2 жыл бұрын
I come from the future and your work is still highly appreciated 🙏. Thank you Sir.
@catlord69
5 жыл бұрын
love the real-world examples and little details (allan thomas smith), good job
@kittycatbuttbutt
8 жыл бұрын
more helpful than several weeks my professor spent on normalization. Thanks
@IchigolovesRukia7
8 жыл бұрын
That's true! Good explanation +channel5567 :)
@juliocheranthonypenaperez7919
4 жыл бұрын
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.
@MaheshBabu1989
8 жыл бұрын
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..
@IgorAherne
8 жыл бұрын
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.
@clarianken4223
8 жыл бұрын
@Igor Aherne check my query pls..?
@8a1ad61b
8 жыл бұрын
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.
@Cornellie
8 жыл бұрын
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
@BurninRevolver
7 жыл бұрын
You should watch you fellow indians tutorials
@Abdzenq
6 жыл бұрын
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
@hotmandead1
7 жыл бұрын
This is the best lecture on normalization I have ever seen thank you
@annjames6522
7 жыл бұрын
The example that you used here is so apt to understand the concepts.... now I finally understand the different kinds of normalization. Thank You.
@jadeite20
7 жыл бұрын
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?
@muhammadnurirsyad9887
5 жыл бұрын
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
@neerajce
3 жыл бұрын
They are just identifiers and not primary key.
@pelelathabo8925
6 жыл бұрын
How convenient, my lecturer used the same example and explained it in the same level is explained in this video. wow good work tutor....
@bhrzali
2 жыл бұрын
Love this tutorial. It's very precise, doesn't waste time, and gets to the point right away.
@aoa0i2u
8 жыл бұрын
very useful tutorial, just saved me a lot of time instead of understanding purely by reading notes
@VeyselAytekin-k2b
6 ай бұрын
Thank you so much. After 8 years it is still helpful
@tjstudibros4677
8 жыл бұрын
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??
@NavalKishoreBarthwal
8 жыл бұрын
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.
@ajaykiran7765
6 жыл бұрын
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!!
@aayamoza8495
8 жыл бұрын
You repeated willson44 twice as a primary key, is that not redundancy? I learnt in 1st NF there should be no repetition!
@Thisisloco1
8 жыл бұрын
+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
@aayamoza8495
8 жыл бұрын
That's fine if you are using two primary key!!
@muhanad102
7 жыл бұрын
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-db9qj
6 жыл бұрын
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.
@ramakantasamal7482
6 жыл бұрын
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 .
@basetroll1627
3 жыл бұрын
Super video. You explained it very clearly in details like for an 8 yr old (Don't get me wrong!) I learned more in these 20 minutes than reading books about normalization.Thanks a ton!
@arashm3669
7 жыл бұрын
cust ID was a bad choice. transaction or invoice id would be a better choice. you cannot have primary keys repeated
@breezycodes
Жыл бұрын
7 years later & this is still gold!
@S0up3rD0up3r99
8 жыл бұрын
This was infinitely more helpful than the college class I'm taking going over databases -.-
@bhsharma2
5 жыл бұрын
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 !!
@abdullahhaidar3658
6 жыл бұрын
I could've spent 100 hours trying to understand that from the teachers course, you saved me lots of time !!
@joshuaturner4033
7 жыл бұрын
Thank you for literally saving my degree.
@qwerty86567
3 жыл бұрын
Excellent video. Very clear and minimal example which illustrates the concepts effectively. Thanks!
@ranjan_v
5 жыл бұрын
Thank YOu
@Citizen-Burns
4 жыл бұрын
This was a much better explanation then my university resources. There is an error in this however, in the 4th normal form the subscription table cannot be setup with the same primary key as the customer table. The subscription table needs a unique ID so that Wilson is not repeated. Even with that error however this is an excellent tutorial. Thank you!
@fahimbaig825
5 жыл бұрын
why would they both buy a ps4 if they live in the same house ? these the real question we all should be asking here ..
@CynicalOldDwarf
5 жыл бұрын
They don't like sharing, and they want to play multiplayer without split screen cheating.
@fahimbaig825
5 жыл бұрын
@@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*
@kabelokgabo880
6 жыл бұрын
This is the best Normalization video... everything was clear and it was audio-able
@cairnebloodfist3347
7 жыл бұрын
By far the best normalization example I have seen.
@abdulrahmanlingga9420
4 жыл бұрын
I barely comment on yt videos but my time and energy will be worthwhile for thanking you. Thank you.
@beyondsounds2640
5 жыл бұрын
Hi, Your tutorial is the best of the best in term of explanation of normalization. I wouldn't have understood this concept if not for your tutorial and how clear your explanations are. Bravo. I really appreciate your understanding of this concept and for passing it onto a novice like me..
@jadeite20
7 жыл бұрын
2nd normal form first relation is wrong. Cust ID does not determine Newsletter. There is a partial dependency on 9:42
@hussainhaider3162
5 жыл бұрын
You're right. What do you think should be the solution? Put newsletter column into the other table maybe?
@vasanthsrinivaspadmanathan2185
2 жыл бұрын
Very simple and effective way of representation. Much relieved! Thanks for this important post.
@nadirhussain4209
5 жыл бұрын
Tomorrow i have to submit my final year project and just watch this video and it help me so much😊 I m first graduate from my village and you play good role to reach my dream
@timothywynne7025
8 жыл бұрын
That's the best explanation and well demonstrated demonstration I have seen on this subject. It did a very good job of explaining concepts that I was having a difficult time understanding in the text book. Very nice. Thank you...
@ShukyPersky
5 жыл бұрын
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.
@joshuaaguilar1033
3 жыл бұрын
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.
@theamazingmonkey100
3 жыл бұрын
then make a video yourself if you think you can do better damn
@MKouthere
8 жыл бұрын
you are my savior
@tanishqvyas8387
4 жыл бұрын
One of the best videos to understand normalization concept. Good job man
@Haapavuo
8 жыл бұрын
NOTE: wilson44 CANNOT BE TWICE IN 1NF!! THERE IS A FAILURE IN THE VIDEO!
@jjthomson4609
8 жыл бұрын
1nf allows multiple tuples but not multiple valued attributes
@zwels
5 жыл бұрын
This was super helpful. My textbook was too cryptic too understand this concept. Thank you.
@ericpoirier3705
6 жыл бұрын
Well done. The pace is right on spot so we can follow everything. Thanks.
@padoharaja4503
2 жыл бұрын
Love this one, i think this is the most clear explain on Normalization
@yasirzubair20
Жыл бұрын
Clearly explained throughout the entire KZitem platform!
@pcinformes1
7 жыл бұрын
Excellent explanation! much better than other videos I have seen.
@qdoan17
6 жыл бұрын
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!
@dev9545
8 жыл бұрын
excellent presentation ....in 19 min i have learned the normalization very easily
@maxvve
3 жыл бұрын
The video is highly beneficial and wow. i wanna say THANK YOU A LOT. you basically helped me to understand 3 lectures. Iconic.
@yumincao5878
5 жыл бұрын
A great thank! This video links the Fs to table. Much better than what I've been taught by lectures.
@Webheadization
6 жыл бұрын
This is excellent. Well explained and easy to follow. As others have said, far more helpful than my college resources!
@hinaa3
8 жыл бұрын
You made this much more easier to understand than everyone else I've went to! Thank you!
@ahmedanjariny2617
6 жыл бұрын
From the best videos I have seen about normalization ... Thanks a lot MASTER
@kolbymcgarrah8565
7 жыл бұрын
I struggled with this concept for a long time. This completely cleared everything up!
@tubesanedude6227
4 жыл бұрын
god bless you i just subscribed to your channel my lecture confused me u just made normalization look so easy
@eminguney8325
4 жыл бұрын
Best description Ive seen about normalization thanks a lot man 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
@WowPr0digy
8 жыл бұрын
thank you so much, my teacher did not explain this properly, i dont fully get the jist of it but i can say i have a huge understanding on why we make sure data is not repeated or in this case NORMALIZED lol!
@u34153
6 жыл бұрын
Thanks for all the efforts to create this video. The most helpful normalization explanation ever.
@fercho810116
5 жыл бұрын
Excellent explanation. Simple but covering the what, why and how perfectly. Thanks!
@gary657595
8 жыл бұрын
No better explanation after watching this video. Thanks!
@fezekileplaatyi7224
6 жыл бұрын
Thanks sir. This is wonderful video, I fully understand now the normalization. Fezekile(WSU, South Africa)
@marioayala3910
2 жыл бұрын
You explained in 19 minutes what my professor tried to in 2 hours
@AlbertYankson
7 жыл бұрын
Thanks for sharing this..really helpful.. One comment though..Newsletters exist even if customers don't exist.. so they have to stand alone with newsletterID and then linked to customer in subscription. This way newsletter can be renamed without multiple edits too.
@anghud1
4 жыл бұрын
You Explained this better than my professor!! OMG! Thank you!!!
@tylerd8896
6 жыл бұрын
Thanks for this, cannot understand my teacher due to their accent and broken English. This helped me out so much!!
@rimvydaskanapka3229
4 жыл бұрын
I was having hard time understanding normalization but you explained it so clear! Thank you very much for your work, we appreciate it. :)
@spook873
Жыл бұрын
Laba Diena bratka
@Mady526
8 жыл бұрын
This is more useful than what I learnt in class...We have a professor who makes us sleep
@BestowTechs
7 жыл бұрын
Wonderful explanation, it is clean and simple. Straight to the point... good job....
@nalakaviraj6016
4 жыл бұрын
This 19 mins is ,worthy than all the lecuture notes i had on dbms.
Пікірлер: 1,2 М.