This video taught me normalization in 10 min, but my lecturer spent 1 hour confusing me
@JesperLowgren10 ай бұрын
LOL Thank you !!
@crislell6 ай бұрын
Exactly, I ask myself WHY? If they can simplify. Why make it more complicated than really is!!
@thisusernameisalreadytaken80414 ай бұрын
They're not qualified (stupid) @@crislell
@gugkiuuАй бұрын
😂😂
@ItsGorka2 жыл бұрын
Got a databases exam tomorrow for uni. This has really came in clutch since I've always struggled to understand the differences between 1NF - 3NF. Cheers!
@JesperLowgren2 жыл бұрын
Great, and good luck !!
@feimimi4 ай бұрын
BRO SAME
@ItsGorka4 ай бұрын
@@feimimi U got this bro
@tigranasatryan52323 ай бұрын
Same Here :DDD
@sainiapulemasara2 жыл бұрын
I had a class in the morning hours about normalisation and woke early to watch this. It has been very helpful to me. Be blessed alot.
@DBalint88 Жыл бұрын
YES! I have listened / read / watched some 10 other explanations that seem to use absolute gibberish for this concept. But yours is immediately crystal clear. I finally understand 3rd Normal Form. Thank you so much.
@JesperLowgren Жыл бұрын
Thank you! My pleasure 🙏
@alekizzu4705 Жыл бұрын
I have a Microsoft Access exam tomorrow and I was struggling a lot with normalisation. You explained it well and now I have a decent understanding of what I have to do. Thank you!
@JesperLowgren Жыл бұрын
Thank you AlekiZzu!
@JessiesGengar6 ай бұрын
This is so helpful! i've been struggeling to understand this particular part of the course i'm following for the past 3 days, and you have made it very clear in 10 minutes. it's clear, with a simple visual and without all the extra's which just confuses the main point. TY so much, i can continue my course with confidence!
@JesperLowgren5 ай бұрын
Thank you Jessie !! 😁
@feimimi4 ай бұрын
got a database exam tomorrow too and ive been going crazy reading the material over and over again,, this vid really just saved my life
@JesperLowgren4 ай бұрын
This kind of feedback makes my day 😁!!
@yehanwasura7 ай бұрын
There's at least a one guy on educational videos saying they didn't get anything from lectures.😅 So here I am, Thank you ,this video helped me a lot.
@JesperLowgren7 ай бұрын
Thank you !!
@kareemsharawi4778 Жыл бұрын
This is just amazing the way you describe things! I come here after failing to understand NF through an instructor of a well known EXPENSIVE online educational platform (will not mention the name). Thank you very much!
@JesperLowgren Жыл бұрын
Thank you 🙏
@paigeroman1977 Жыл бұрын
Omg I was sobbing trying to figure out my assignment until I found this video. It's the only video I could find that used an example I could understand! 😭
@JesperLowgren Жыл бұрын
Thank you Paige you made my day !!
@Alfenijonas5 ай бұрын
Nice examples and explanations. Everything goes from start to end, without any "side quests". The explanation is fluent and has a flow. Like a well-written book. Clicked that like button and spent some time writing this comment in hopes that the yt algorithm will show this to as many people as possible.
@JesperLowgren5 ай бұрын
I really appreciate your feedback 😁!!
@Alfenijonas5 ай бұрын
@@JesperLowgren I really appreciate your explanation!
@JesperLowgren5 ай бұрын
@@Alfenijonas My pleasure !!
@kemalist98783 жыл бұрын
Finally, somebody! I've needed this video for such a long time, thank you.
@rishabhsingh07682 күн бұрын
Such an amazing explanation in just 10 minutes..Thank you so much!!!
@btchhushington28105 ай бұрын
I would love to see a video on 4NF-5NF: exceptions. Liked the video, Subscribed to the Channel and Shared on LinkedIn. Great job!!
@JesperLowgren5 ай бұрын
Thank you! Will do one of 4NF and 5NF, been thinking about it for a while.
@makenzierebeca84083 жыл бұрын
This video has been super useful in my computer course!!
@JesperLowgren3 жыл бұрын
Thank you. Good luck with your course!
@yssplays26202 ай бұрын
THE BEST NORMALIZATION EXPLAINING EVER
@JesperLowgren2 ай бұрын
Thank you !! 😁
@andygaal793614 күн бұрын
very effective lesson, nicely done I instantly could understand the matter, thanks !
@andresviveros39943 ай бұрын
this has helped me get a job in application support where we use DBs to query data for bugs
@JesperLowgren3 ай бұрын
Fantastic. Thank you!
@mine99112711 ай бұрын
So useful! I could not understand anything from my classes at uni before this
@JesperLowgren11 ай бұрын
Thank you, I am very happy I could help 😄!
@dude_mude3366 Жыл бұрын
I got a CS exam next week, ur A LIFE SAVER!!!
@Comrade42135 ай бұрын
Beautiful video and a great explanation. Thanks Jesper.
@JesperLowgren5 ай бұрын
Thank you 😁!!
@gjergjikokushta Жыл бұрын
Thank you Jasper - best explaination so far. I teach students in highschool - but the textbook it kinda techy and not very suitable for students. Your explanation is easy to grasp :)
@JesperLowgren Жыл бұрын
Thank you Gjergji !!
@danielscopyright1375 Жыл бұрын
I love this video, so easy to understand. But then at minute 8:00, I don't think it should be "skill 1 ID" since it references a skills table containing any skills. Then I suggest it should be only ''skill Id''. Kindly correct me if am wrong.
@tigranasatryan52323 ай бұрын
great video, great explanation!!!!
@JesperLowgren3 ай бұрын
Thank you 😁!!
@howling-wolf Жыл бұрын
I love how he pronounces "data". And yes I mean that honestly.
@realshinsa2 ай бұрын
thanks, and i have an exam on tuesday
@jentevanrosmalen9300 Жыл бұрын
I have an exam tommorow and this was the one thing I couldn't understand, Thank u!
@JesperLowgren Жыл бұрын
Great, happy to help Jente.
@iamkhol22325 ай бұрын
Really well explained, much better than some Udemy courses!
@JesperLowgren5 ай бұрын
Thank you 😄!
@kimchijamАй бұрын
quick and simple, nice
@JesperLowgrenАй бұрын
Thank you !! 😁
@diegoortega2374 Жыл бұрын
Thank you Jesper, your explanatio was just awesome! Cheers man!
@JesperLowgren Жыл бұрын
My please! Thank you!
@deffdepth824 Жыл бұрын
Thank you for this wonderful explaination. Please make more videos!
@JesperLowgren Жыл бұрын
Thank you !! I wish I had time to make more 😁
@joenathanlofties1253 Жыл бұрын
Writing an essay on normalizing a presented database, this helps alot!
@pranicbutton3 жыл бұрын
Great video with many useful insights.
@JesperLowgren3 жыл бұрын
Thank you Robert, glad you liked it :).
@cubingandgaming61587 ай бұрын
THANK YOU JESPER
@JesperLowgren7 ай бұрын
My pleasure !!
@Licvidatorr8 ай бұрын
Thank you, i have an exam tomorrow and this helped me !
@JesperLowgren8 ай бұрын
I love to hear that 😁!
@barisaytimur Жыл бұрын
great video, keep up the great work my G!
@JesperLowgren Жыл бұрын
Thank you Baris !!
@sunilgajurel26182 жыл бұрын
great Vedio so far. I really got concept up to 3NF . Bunch of thanks.
@JesperLowgren2 жыл бұрын
My pleasure, glad to be able to help!
@ranaanforlemu82435 ай бұрын
Very Helpful 👍👍
@JesperLowgren5 ай бұрын
Thank you !!
@riannacarlos43343 жыл бұрын
Easy to understand with great for your next video :).
@ashwinichoudhary811 Жыл бұрын
You save whole lot of a struggle to me , thanks Jesper
@Mehmetcetin003 жыл бұрын
This one is the best one.
@huangJJ0412 Жыл бұрын
briefly explained well! thanks sir 🙏
@MohamedBarreOMER3 ай бұрын
Wonder explanation
@JesperLowgren3 ай бұрын
Thank you !!
@krisscage3 ай бұрын
Thank you for great lecture.
@evalaviniabucur1789 Жыл бұрын
Thank you, I understood 3NF quite well from your explanation. How do you know when to draw the line when using 3NF? For example, the Employee table's primary key doesn't define the address column. Should we also move the addresses to a separate table and uniquely identify each address, then change the address column in the Employee table to, let's say, address_id?
@JesperLowgren Жыл бұрын
Hi Eva, a great observation and the answer is.... you could! Many organisations use services like Experian to validate addresses, and you could store a primary key for a particular address instead of the whole address. The same goes for employee. The question I would ask, and where I would draw the line, is how the data is used. Are there any benefits in creating a specific address table with a primary key? If yes, then I would do it, if no, I wouldn't. In most cases there probably wouldn't be a benefit and it would be easier to store the full address in attributes against an employee (or customer for that matter). Unless you are in the business of managing address data, like Experian, then you most certainly would. Hope this helps 😀.
@evalaviniabucur1789 Жыл бұрын
@@JesperLowgren thank you for the answer and, yes, it helps. It's just that I'm the sort of person who tends to believe you can't learn computer programming if you don't understand how the current flows inside the computer if you understand what I mean, and that is the reason I'm not really able to draw some lines :))
@ryzawy3 ай бұрын
Interesting thread. If it’s up to one to decide, in which NF do the scenarios fall? Are both 3NF of varying degrees? I understand it depends, but I am a bit confused on how to identify NFs then
@MuksEmmaN Жыл бұрын
God bless you dearly sir!
@JesperLowgren Жыл бұрын
Thank you !!
@user-ot9uv2gp7v8 ай бұрын
ez explaination 5-star review!
@JesperLowgren8 ай бұрын
Thank you !! 😁
@henriettaneiss87643 жыл бұрын
Very good intro and well explained.
@mehranbarahouei23468 ай бұрын
great job Jesper
@JesperLowgren8 ай бұрын
Thank you Mehran! 😁
@khiarahmed4045 Жыл бұрын
Great video, explained well 😊
@JesperLowgren Жыл бұрын
Thank you !!
@jacobs8531 Жыл бұрын
Great explanation and a refresher,
@asifityourlast78466 ай бұрын
THANK YOUUUUU !!
@markkevnjfloresАй бұрын
Thaaaank you!
@alaa.albast Жыл бұрын
Thank you ,I understand now ...
@meowpasha4998 Жыл бұрын
Nice Job! I understand it under 15 mins thx.
@YouTubeMarketingexpert0073 жыл бұрын
Great video, but keen to see higher forms of normalization.
@JesperLowgren3 жыл бұрын
Thank you, yes I am planning to make a video on BCNF, 4NF, and 5NF soon!
@omniscienceisdead88372 жыл бұрын
simple and clear , thank you
@JesperLowgren2 жыл бұрын
Thank you!
@not_nev2 ай бұрын
thank you for real doc Jesper Lowgren Sheldon ❤
@smtxtv4 ай бұрын
Good video. Asst. due. Thx !
@JesperLowgren4 ай бұрын
Thank you !!
@theyvesloy Жыл бұрын
with the rule that each column value should be atomic, shouldn’t name and address be split up?
@JesperLowgren Жыл бұрын
Hi Yves, yes a great observation and the answer is yes, you could split them and create an address entity with an address id, and then add address id as a foreign key to name. Some organisations do this when address is particularly important, such as sending items to a postal address. For example, using an external address validation service like Experian, and using the Experian address ID as a foreign key against a customer entity.
@aymanmouhcine5749 Жыл бұрын
This is amazingly explained Thanks a lot
@zweitekonto9654 Жыл бұрын
At 9:15 in the video, what does it mean "Not defined by the primary key"?
@JesperLowgren Жыл бұрын
Good question! Looking back, it is somewhat ambiguous. If job names are stored in its own entity, and job name is the primary key (as opposed to job id), then Job Name is a legitimate Foreign Key in the Employee entity. But.... a better way is to define Job Names using the primary key Job ID. In this case, storing job name in an employee entity is incorrect, as job name is not defined using employee id. Hope this makes sense 😄.
@luggnugg491210 ай бұрын
W. Better than my comp sci teacher
@JesperLowgren10 ай бұрын
Thank you Luggnugg 😁!
@iulianab3 ай бұрын
Hi! Thank you for this video, much appreciated! Can you please tell me if there is any rule related to one to one relationships in a Third Normal Form?
@daniyarauezkhan751821 күн бұрын
6:39 Doesn't the second table violateS the 3rd rule of normalization of the first form? It seems to me that it would be better to define the columns Employee ID, Skill Name and Skill ID in the second table. Thus, the primary key can be assigned to a combination of Emloyee ID and Skill ID
@tylerhanserd8616 Жыл бұрын
Thank you! So much!!!
@JesperLowgren Жыл бұрын
My pleasure Tyler. Thank you!
@ShmeegleSon Жыл бұрын
Thank you that helped me out
@JesperLowgren Жыл бұрын
That's great, thank you!
@highwaytoheaven473812 күн бұрын
Hi I have one question.Can I remove Employee Id Skill 1 id table? and add new employee id to skill id and skill name. So the final table will be skill id employee id skill name.
@JesperLowgren4 күн бұрын
Hi. That would violate normalization as skill name is only partially dependent on the primary key, e.g. skill id.
@centillionare4 күн бұрын
So why is Job Name not defined by Employee ID, but Address is? I got all of this video except this part.
@JesperLowgren4 күн бұрын
Because the employee ID identifies the address, and the address depends on the employee id. But job name does not depend on employee id but on job id.
@centillionare4 күн бұрын
@@JesperLowgrenthank you!
@ZawmyoHtet-lg7jn Жыл бұрын
Thank you very much, Sir.
@stevewaterfield4862 Жыл бұрын
Thanks. 😊
@mm-vv3ih Жыл бұрын
Thank you for video but I don't understand what you did at 6:26 :( what are the repeating groups here?
@alekizzu4705 Жыл бұрын
Skill ID and Skill Name are repeating, so he had to rename them into Skill ID 1 Skill Name 1 Skill ID 2 Skill Name 2 so there are no repeating columns
Жыл бұрын
@@alekizzu4705 No, he just placed the same data in a separate table, nothing changed at all. This is certainly not the repeating group issue.
@mustafasacan43733 жыл бұрын
Amazing.
@kvelez3 ай бұрын
Thanks.
@tooslow12383 ай бұрын
7:28 since the second spreadsheet has 2 skills (2 Ids, 2 names), don't we need to specify 2 skill ids in the new spreadsheet (skill 1 id/ skill 2 id)?
@novatrap19403 жыл бұрын
Great!!
@Hillgrov2 ай бұрын
Why do every book and online resources have different definitions and rules for the normalization forms.. I've just watched 3 videos and read 2 articles.. none of them are in agreement.
@TehGhostWhoPlay6 ай бұрын
I m confused as to how job name doesn’t rely on employee id. Can someone explain to me why?
@JesperLowgren6 ай бұрын
Hi Ariel, a job name might be Forklift Operator. An employee id might be 37 (John Smith). You can relate id 37 to job name Forklift Operator. But the job name Forklift Operator does not rely on employee id 37 (or any other employee id). The job name Forklift Operator can exist even if it is not related to any employee id; hence employee id does not depend on job name. Hope this makes sense. 😀
@TehGhostWhoPlay6 ай бұрын
@@JesperLowgren I think i do understand it a bit more. Thank you for the clarification.
@noelsirrom Жыл бұрын
this guys camera is crispy
@DreamsAPI Жыл бұрын
Hi @Jasper, I could not find your second video about cardinality 4t and 5th
@JesperLowgren Жыл бұрын
Hi, here is the link to the video that addresses the 4th and 5th Business Normal Form: kzbin.info/www/bejne/amqlpKWgn9GCmLs
@2684dennis8 ай бұрын
Is it aloud to have 2 foreign keys?
@JesperLowgren8 ай бұрын
Hi, yes it is allowed and necessary. For example, in a PERSON entity, you might have a Foreign Key to a PERSON-GENDER entity, and to a PERSON-PREFERENCE entity etc. Each Foreign Key brings more meaning to the entity.
@2684dennis8 ай бұрын
@@JesperLowgren oke, so only a primary key you can have once, but multiple foreign key, and candidaat keys can also be more because they are optional primary keys? im learning this cause in 2 weeks i got exame but the book i have from school, its bad, it has so much text in it and so much tekst between () that when you reed it the obviouse answer is sinking away in all the unnessesary tekst. this vid about normalisation is exctually good to follow and good to understand, im gonna write this down in my writingbook to learn.
@JesperLowgren8 ай бұрын
@@2684dennis yes there can be multiple unique keys, and each unique key is a candidate primary key. But there can only be one primary key.
@vanessabano71802 жыл бұрын
Very helpful!
@WanoFax8 ай бұрын
You beautiful human
@JesperLowgren8 ай бұрын
Thank you !!😁
@nasrhussain91267 ай бұрын
Starts 4:30
@aiautoglasscrm Жыл бұрын
Liked and subscribed
@SyncCryoАй бұрын
Can I send you a look at a moderation page I want to create but am unsure how to normalise correctly?
@JesperLowgrenАй бұрын
Of course 😄!
@SyncCryoАй бұрын
@JesperLowgren Awesome! How can I contact you so I can send my draft of the page?
@JesperLowgrenАй бұрын
@@SyncCryo jlowgren at outlook.com
@SyncCryoАй бұрын
@@JesperLowgren Great! I've dropped you an email.
@SyncCryoАй бұрын
@JesperLowgren Thank you! I've sent you the draft moderation page. Let me know when you can take a look 🙏
@user-bz4qe3gi9y8 ай бұрын
🐐🐐🐐
@percio6802 Жыл бұрын
9:17 Why is 'Job Name' not in 3NF? You can find out what job the employee works by their employee ID?
@thomaskaiser2475Ай бұрын
Can a PK have a relationship with its FK counterpart in more than one table?
@JesperLowgrenАй бұрын
Yes it can! For example, a Contact with PK contact_id can be an FK in both a Leads table and an Opportunity table.
@thomaskaiser2475Ай бұрын
@@JesperLowgren wow thanks a lot! I had such a hard time and conflicting information on that as a 2 week old initiate.
@thomaskaiser2475Ай бұрын
@@JesperLowgren Now i just need to know what those diagrams with the Diamonds and rectangles and bubbles and numbers is called so i can find out what they mean. Im just starting the textbook: Fundamentals of Database Systems Seventh Edition.
@JesperLowgrenАй бұрын
@@thomaskaiser2475 my pleasure, I get excited when others get value from my videos 😄.
@JesperLowgrenАй бұрын
@@thomaskaiser2475 I had a quick look and the book seems to use several notations, including UML (which is object modelling, not data modelling). Data modelling is based on the concept of a one-to-many relationship, which can be described using different notations. I used the crowfoot notation in the video.
@himalkhandokar76873 жыл бұрын
Keep it up
@priyaakter94973 жыл бұрын
Amazing
@rustyspottedcat8885 Жыл бұрын
"divide and conquer"
@shavirtooray3369 Жыл бұрын
Hi not sure if someone can assist here but in the 2NF stage when we work with employee id and skill id's wouldnt one of the tables be "EmployeeID | Skill1 ID | Skill 2 ID" instead of just "EmployeeID | Skill 1 ID"
@hdot26135 ай бұрын
No, because each new "skill" will be represented as a new row in the Skill table
@fgfanta2 жыл бұрын
What does it mean that a column depends on another, or that a column fully defines another? I don't get it from the examples, would like a proper definition, such that I look at a table, and can tell if a column depends on another or a column fully defines another.
@Adam-zo7nz Жыл бұрын
Did you find a good resource for understanding this? I'm in the same position as you when you made this comment.
@mohammadatik23803 жыл бұрын
Nice
@aimanabdelraziq38652 жыл бұрын
Nice illustration but needs to slow down the tempo.
@nimsamreth2 жыл бұрын
thank you, i got answer of what i what?
@syntaxerorr Жыл бұрын
Too much mouth noise. It sounds like someone is messing with a candy wrapper while you are talking.