Database Normalisation: First Normal Form
ฝัง
- เผยแพร่เมื่อ 12 ม.ค. 2019
- This video is part of a series about database normalisation. It explains how to transform a database into first normal form by working through an example. It covers the criteria for the first normal form including ensuring that a table does not contain composite or multi-valued attributes and that a table does not contain any repeating groups of attributes.
All computer science videos should be in this accent
:)KD
agree
Your 3 videos on 1NF, 2NF & 3NF are the clearest I've seen. Thank you for making them.
Thank you - much appreciated :)KD
Saving my A levels. I didn't understand normalisation until now. Appreciate the video :)
Thank you for the quality, clear, and concise database normalization videos that you have provided to the public. They show mastery of the content. Have a pleasant day.
Thank you so much :)KD
Outstanding breakdown! I love how you showed that you can look for 4 things to identify whether or not it's in 1NF and used an example to illustrate that! Thanks so much!
You're very welcome :)KD
clearest videos I've seen about the Normalization in YT, Thank you sir
You Sir, are a champion! clear and concise, many thanks.
best explanation of normalization on the internet! thank you
Kind of you to say so. Thanks :)KD
this is a great tutorial! You explained the concept very clearly. It really helped me. Thank you!
Thanks for your videos, it is so clear when i watch a video with an English accent
Indeed
Definitely the best video I've seen on 1NF
These videos 1,2,3 make me understand this notion well.
Glad to help :)KD
Absolute savage video, can't thank you enough for the playlist!
You are most welcome :)KD
Thank you so much, I appreciate the time that you spent for us.
You're most welcome. Thank you :)KD
Well done, I've watched several of videos on this subject yours were the best.
Thank you :)KD
Excellent video(s), very clear explanations.
Thank you for the videos(1NF,2NF,3NF) they are loud and clear
Awesome video with clear explanation
great tutorial. very articulate. 10/10
What an amazing and clear explanation
y dnt teachers expalin gud like u do do
Also you have a lovely, lovely voice.
You are very kind. :)KD
nicely explained, please give him a thumbs ups
Thanks a lot it's a whole lot more clear now
You made it so easy to understand. Thank you.
KISS :)KD
Very elegantly explained!
Very kind - thanks. :)
Nice Simpsons reference in the table at 1:50. Well played sir.
Everything’s Coming Up Milhouse. Thank you :)KD
This channel deserve more views!
Kind of you to say so. Please spread the word. :)KD
Very good explanation.
As a DB design refresher in just few minutes.
Thanks a lot!
Glad it was helpful. :)KD
Your explanation was short and clear.
I think if you create a complete course on database design then it would definitely be a success. Thanks again.
Thank you for the video, would be helpful if under your description you linked to the rest of the database normalisation lessons - or linked to a playlist where you gathered all the lessons together.
I'll take another look at the way I'm packaging my videos. I don't think I'm using TH-cam to its full potential yet. Thanks for the comment :)KD
This series of videos helped alot, thank you
ps - you sound like the ninth doctor from doctor who
You're telling me I sound like Christopher Eccleston - FANTASTIC. :)KD
Thank you, this was very useful.
You're welcome. :)KD
great video! really cleared up some confusion for me thankyou
Glad it helped :)KD
i swear this video is way better than my professor class :)
Thank you :)KD
I lkike your datases teaching.
Thank you!
You're welcome :)KD
nice explanation, well done
Thank you :)KD
For resolving the problem of a student taking multiple courses, instead of including different entries for each course, would it have been a good idea to One - Hot - Encode the course titles?
Thank you
You're welcome :)KD
thank you
you have a really nice voice
yes i think it is very nice
Great videos. My class is a little confusing sometimes.
I hope I helped to clear things up :)KD
bEST nORMALIZATION EXPLANATION VEDIO SET..SUPERB!@❗❗❗❗❗
Thank you so much :)KD
And what about primary key? Isn't it necessary for 1NF table to have the primary key(either single or composite)?
it does have a composite primary key consisting of the ID and course title
nice video but how the hell do we do that string split in tbe sql server ?
You could write a stored procedure that employs some of the string manipulation functions of T-SQL
docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=sql-server-ver15
:)KD
i am not able to understand difference between atomicity and repeating group ...please clear it too ,thanks
omg this guy is amazing for real this is the best explanation ever on the whole planet earth forget it on the galaxie
Well that made me smile. Thanks for the comment :)KD
For John, the number could even be his wifi password 😀
i wish that ure my teacher
I wish you were my student :)KD
@@ComputerScienceLessons what does KD mean? Is it initialism of your name? English is not my native language, so I can't figure it out :)
@@ScottTynna Hi. my name is Kevin Drumm :)KD
how do u normalise an invoice having multiple subtotal fields for a particular customer
60 minutes class < 7 minutes youtube
Glad it was useful. Of course, a 7 minute video represents a few hours of preparation. :)KD
@@ComputerScienceLessons it's been almost 2 years of that video and still liking and commenting what a legend !
I learned nothing, trying to figure this out the last 5 days. I'm stuck at choosing the primary key and identifying the repeating group.
It may be worth moving on to later videos in the series to get a feel for it first, then coming back to the theory later. I think learning database normalisation is a bit like learning to ride a bike - it's not easy to put into words but on day it clicks. Sometimes the terminology gets in the way of understanding :)KD
when you see it
Good video but why does bro talk so aggressively ☠
Sorry about that. I used a rubbish microphone and probably over compensated - or maybe I had a bad day at work that day! :)KD