Тёмный

Database Normalisation: First Normal Form 

Computer Science
Подписаться 215 тыс.
Просмотров 114 тыс.
50% 1

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.

Опубликовано:

 

26 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 92   
@richardarmstrong-finnerty3140
@richardarmstrong-finnerty3140 3 года назад
Your 3 videos on 1NF, 2NF & 3NF are the clearest I've seen. Thank you for making them.
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
Thank you - much appreciated :)KD
@exxodas
@exxodas Год назад
All computer science videos should be in this accent
@ComputerScienceLessons
@ComputerScienceLessons Год назад
:)KD
@serdarcan3363
@serdarcan3363 3 месяца назад
agree
@MichaelDonat1
@MichaelDonat1 11 месяцев назад
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.
@ComputerScienceLessons
@ComputerScienceLessons 11 месяцев назад
Thank you so much :)KD
@inhMinhNguyen-ge9cv
@inhMinhNguyen-ge9cv 5 лет назад
Thanks for your videos, it is so clear when i watch a video with an English accent
@Maen963
@Maen963 3 года назад
Indeed
@valderramalamay2965
@valderramalamay2965 Год назад
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!
@ComputerScienceLessons
@ComputerScienceLessons Год назад
You're very welcome :)KD
@royreisenleiter8260
@royreisenleiter8260 5 лет назад
You Sir, are a champion! clear and concise, many thanks.
@AS-ih8jj
@AS-ih8jj Год назад
clearest videos I've seen about the Normalization in YT, Thank you sir
@yugenedits9538
@yugenedits9538 3 месяца назад
Saving my A levels. I didn't understand normalisation until now. Appreciate the video :)
@aksantibahizireactif7235
@aksantibahizireactif7235 5 месяцев назад
These videos 1,2,3 make me understand this notion well.
@ComputerScienceLessons
@ComputerScienceLessons 5 месяцев назад
Glad to help :)KD
@rezasoleimanzadeh7141
@rezasoleimanzadeh7141 3 года назад
Thank you so much, I appreciate the time that you spent for us.
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
You're most welcome. Thank you :)KD
@chrisbautista9433
@chrisbautista9433 7 месяцев назад
Well done, I've watched several of videos on this subject yours were the best.
@ComputerScienceLessons
@ComputerScienceLessons 7 месяцев назад
Thank you :)KD
@mesfinhaftu6206
@mesfinhaftu6206 2 года назад
Thank you for the videos(1NF,2NF,3NF) they are loud and clear
@littlecatboybuddy
@littlecatboybuddy 2 года назад
this is a great tutorial! You explained the concept very clearly. It really helped me. Thank you!
@kutsandribbons
@kutsandribbons 2 года назад
Absolute savage video, can't thank you enough for the playlist!
@ComputerScienceLessons
@ComputerScienceLessons 2 года назад
You are most welcome :)KD
@noahrubin375
@noahrubin375 4 года назад
Definitely the best video I've seen on 1NF
@BUBBA4428
@BUBBA4428 4 года назад
y dnt teachers expalin gud like u do do Also you have a lovely, lovely voice.
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
You are very kind. :)KD
@Metayounis
@Metayounis 4 года назад
You made it so easy to understand. Thank you.
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
KISS :)KD
@bobray342
@bobray342 4 года назад
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.
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
I'll take another look at the way I'm packaging my videos. I don't think I'm using RU-vid to its full potential yet. Thanks for the comment :)KD
@afrosan3769
@afrosan3769 5 лет назад
Very elegantly explained!
@ComputerScienceLessons
@ComputerScienceLessons 5 лет назад
Very kind - thanks. :)
@rufina305
@rufina305 2 года назад
Awesome video with clear explanation
@ryanhuang3875
@ryanhuang3875 4 года назад
This channel deserve more views!
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
Kind of you to say so. Please spread the word. :)KD
@bitduelist
@bitduelist 3 года назад
This series of videos helped alot, thank you ps - you sound like the ninth doctor from doctor who
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
You're telling me I sound like Christopher Eccleston - FANTASTIC. :)KD
@GojoUltra-l5p
@GojoUltra-l5p 5 лет назад
nicely explained, please give him a thumbs ups
@pipertripp
@pipertripp 5 месяцев назад
Nice Simpsons reference in the table at 1:50. Well played sir.
@ComputerScienceLessons
@ComputerScienceLessons 4 месяца назад
Everything’s Coming Up Milhouse. Thank you :)KD
@patrickmcauliffe7162
@patrickmcauliffe7162 4 года назад
great video! really cleared up some confusion for me thankyou
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
Glad it helped :)KD
@Salah.K.A
@Salah.K.A 2 года назад
What an amazing and clear explanation
@chrisgiles5877
@chrisgiles5877 3 года назад
Excellent video(s), very clear explanations.
@manutanyanyiwa496
@manutanyanyiwa496 5 лет назад
Thanks a lot it's a whole lot more clear now
@rshad4ever
@rshad4ever 3 года назад
i swear this video is way better than my professor class :)
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
Thank you :)KD
@trr12
@trr12 3 года назад
nice explanation, well done
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
Thank you :)KD
@BoBo-yn4xf
@BoBo-yn4xf Год назад
I lkike your datases teaching.
@DenseNinja
@DenseNinja 4 года назад
Thank you, this was very useful.
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
You're welcome. :)KD
@sudiptoghosh5740
@sudiptoghosh5740 3 года назад
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?
@jeffreytello589
@jeffreytello589 4 года назад
best explanation of normalization on the internet! thank you
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
Kind of you to say so. Thanks :)KD
@y2j209
@y2j209 3 года назад
nice video but how the hell do we do that string split in tbe sql server ?
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
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
@johndunham6791
@johndunham6791 3 года назад
Great videos. My class is a little confusing sometimes.
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
I hope I helped to clear things up :)KD
@conlandavies6922
@conlandavies6922 4 года назад
you have a really nice voice
@MrClaymore9000
@MrClaymore9000 4 года назад
yes i think it is very nice
@naumanshafique1745
@naumanshafique1745 4 года назад
i am not able to understand difference between atomicity and repeating group ...please clear it too ,thanks
@artemkazakov7072
@artemkazakov7072 4 года назад
And what about primary key? Isn't it necessary for 1NF table to have the primary key(either single or composite)?
@anyammbuya6349
@anyammbuya6349 4 года назад
it does have a composite primary key consisting of the ID and course title
@lahirujeewantha5208
@lahirujeewantha5208 Год назад
bEST nORMALIZATION EXPLANATION VEDIO SET..SUPERB!@❗❗❗❗❗
@ComputerScienceLessons
@ComputerScienceLessons Год назад
Thank you so much :)KD
@allin6074
@allin6074 4 года назад
omg this guy is amazing for real this is the best explanation ever on the whole planet earth forget it on the galaxie
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
Well that made me smile. Thanks for the comment :)KD
@LoveScreamTrue
@LoveScreamTrue 4 года назад
Thank you!
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
You're welcome :)KD
@RameeshaVihan
@RameeshaVihan 4 года назад
Thank you
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
You're welcome :)KD
@saccamadiqeu2600
@saccamadiqeu2600 7 месяцев назад
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.
@ComputerScienceLessons
@ComputerScienceLessons 7 месяцев назад
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
@seunjonathan
@seunjonathan Год назад
For John, the number could even be his wifi password 😀
@meow-pk5gq
@meow-pk5gq Год назад
thank you
@zarry252
@zarry252 4 года назад
i wish that ure my teacher
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
I wish you were my student :)KD
@ScottTynna
@ScottTynna 3 года назад
@@ComputerScienceLessons what does KD mean? Is it initialism of your name? English is not my native language, so I can't figure it out :)
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
@@ScottTynna Hi. my name is Kevin Drumm :)KD
@cohenbore7124
@cohenbore7124 4 года назад
how do u normalise an invoice having multiple subtotal fields for a particular customer
@issahmidan5821
@issahmidan5821 3 года назад
60 minutes class < 7 minutes youtube
@ComputerScienceLessons
@ComputerScienceLessons 3 года назад
Glad it was useful. Of course, a 7 minute video represents a few hours of preparation. :)KD
@issahmidan5821
@issahmidan5821 3 года назад
@@ComputerScienceLessons it's been almost 2 years of that video and still liking and commenting what a legend !
@mattymo841
@mattymo841 Год назад
when you see it
@DaKingKojo
@DaKingKojo 7 месяцев назад
Good video but why does bro talk so aggressively ☠
@ComputerScienceLessons
@ComputerScienceLessons 7 месяцев назад
Sorry about that. I used a rubbish microphone and probably over compensated - or maybe I had a bad day at work that day! :)KD
@EduardKaresli
@EduardKaresli 4 года назад
Very good explanation. As a DB design refresher in just few minutes. Thanks a lot!
@ComputerScienceLessons
@ComputerScienceLessons 4 года назад
Glad it was helpful. :)KD
@EduardKaresli
@EduardKaresli 4 года назад
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.
@tactiletech1111
@tactiletech1111 3 года назад
great tutorial. very articulate. 10/10
Далее
Database Normalisation: Second Normal Form
9:21
Просмотров 156 тыс.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Brilliant Budget-Friendly Tips for Car Painting!
00:28
Database Normalization 1NF 2NF 3NF
10:26
Просмотров 164 тыс.
1st, 2nd and 3rd Normal Form (Database Normalisation)
11:42
Database Design Tutorial
17:10
Просмотров 954 тыс.
How to do database normalization
21:42
Просмотров 304 тыс.
Normalization - 1NF, 2NF, 3NF and 4NF
19:02
Просмотров 2,2 млн
Database Indexing for Dumb Developers
15:59
Просмотров 60 тыс.
Brilliant Budget-Friendly Tips for Car Painting!
00:28