Database Design 36 - 1NF (First Normal Form of Database Normalization)

Подписаться 643 тыс.

Просмотров 147 тыс.

50% 1

Start your software dev career - calcur.tech/de... 💯 FREE Courses (100+ hours) - calcur.tech/al...
🐍 Python Course - calcur.tech/py...
✅ Data Structures & Algorithms - calcur.tech/ds...
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/ne...
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/sub...
👨🏻‍🎓 Courses - www.codebreakt...
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com...
🅿 Patreon - calcur.tech/pat...
🅖 GitHub Sponsors - github.com/spo...
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/cr...
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/cr...

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

28 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 142

@bensboats-b9t 7 лет назад

Wow a video on Normalization by an American! Finally!

@cindycee9956 7 лет назад

it's always indians yooo

@zairoxs 6 лет назад

plot twist, he is actually Google Duplex o.0 created by an Indian!!!!! :O

@ryleyalexander8097 6 лет назад

bruh

@unavailavle123 6 лет назад

Yeah, indians are very knowledgable but their english is a pain to understand.

@maheshanilakshi4620 6 лет назад

I had the same reaction Buddy. FINALLY......

@NicCorbett 6 лет назад

"As you can see there is no solution to this problem....alright guys thanks for watching", LOL!

@adamcallinan3125 9 лет назад

So I've an exam in this tomorrow and boom you pop these up. Absolute life saver! Thanks man!

@marinm3869 3 года назад

How did the exam go?

@azarrari 8 лет назад

I get excited when i see your videos appear in my search results. I love your in depth explanations, which shows that you really relate to others and understanding what it is that we don't understand form our point of view. So for that I thank you.

@centurion09 8 лет назад

Can we crowd source him a dry erase board?

@xalamon 7 лет назад

a chalk board is more expensive than a dry erase board, this guys knows what he's doing

@heracleummantegazzianum5586 5 лет назад

@@xalamon chalk talks but marker's starker

@xzotic92 9 лет назад

why cant you be our teacher we have those teachers receiving tons of money and they cant even explain anything

@fistupmyass1705 4 года назад

All my teachers are foreigners who can barely speak english

@j0hnnycache 6 лет назад

Dude... You're doing better than my college professor at explaining this stuff to me. THANK YOU

@microsoftwii 8 лет назад

Man I laughed at his jokes

@widdabeats8393 7 лет назад

Because he knows!

@ahmadbahrami9437 4 года назад

You are great Caleb and that "Ok guys thanks for watching" in the middle was very funny :))

@RedJoker9000 6 лет назад

I don't want to be racist, but finally a non-South Asian guy doing a vid. Though I might be of South Asian background, I know they use personal examples, hard to understand to non-speakers, will do their videos in their language etc. Glad we got at least 1 person who took time to make a vid. Also, OMG he's left handed just like me and 9-13% of the rest of the world

@aagantuk7370 5 лет назад

Lol

@Partyylover 7 лет назад

You help me with my studies so much! Thank you sir!

@codebreakthrough 7 лет назад

Thank you for watching! :)

@sopaipillapesadilla7023 5 лет назад

This is a great video it's only increasing my already existent anxiety due to my approaching deadline because I'm constantly worried about your nails making contact with the chalkboard

@LucasofAppalachia 9 лет назад

Very clear and also entertaining, keep it up! You are definitely helping a lot of people.

@sidneyeubanks8224 5 лет назад

youre explanations are always super clear and helpful. keep making videos buddy!

@drew1035 6 лет назад

email_id isn't required. Just use (user_id, email) as the PK

@codebreakthrough 6 лет назад

Good thought. But there are arguments against natural keys and composite keys when not needed, so it’s fairly subjective.

@drew1035 6 лет назад

Thanks for the reply. I will keep that in mind.

@mhamadharmush4278 7 лет назад

thank you bro. your way in explaining is very clear, simple and funny.

@mmmmSmegma 8 лет назад

Straight into my favorites.

@MohannadAdham 8 лет назад

I know this is not practical but, theoretically, the third table is not violating the 1NF if we consider the combination of user_id and email as the primary key.

@TysonKamak 9 лет назад

Thank you for such a clear and concise explanation. The best I've seen!

@SupremeTeamify 7 лет назад

Explained very well, thank you so much Caleb!!

@alexhong794 8 лет назад

better than my professor

@TimerUchiha 6 лет назад

Amazing, a great video! Thank you for uploading :)

@jimmy020815 8 лет назад

Very useful and straightforward !!

@nghnino 7 лет назад

this video s educating and cool, thank you Mr.Caleb

@tabbypp 7 лет назад

You would make a perfect high school teacher or college professor.

@widdabeats8393 7 лет назад

You're a good teacher!

@eldojoseph8718 8 лет назад

Hi Caleb, In the second table couldn't we make it into having two colomns, email1 and email2 instead of creating an email table entirely? Is this approach better or worse?

@Arganoid 7 лет назад

What if you wanted 3 email addresses, or 10?

@SupachaiAbusali96 7 лет назад

no one would want that much

@xalamon 7 лет назад

look into recursive db entities for data loops

@ramchandar8335 Год назад

after watching this i came to know ed sheeran can make awesome videos on db design too....

@10010011001100110101 3 года назад

Thankyou sid from Ice Age!

@YisraelDovL 5 лет назад

So, why use an email id instead of using just the email as the key? One less column and more verbose, no ?

@ejalqueza7584 8 лет назад

uhm, is it possible to have another example of your solution?or thats the only aswer?

@somiashobo8359 6 лет назад

O m g ur way of teaching jst love it dude

@ker0jo486 8 лет назад

Nicely done, good explanation.

@scotthartman8390 8 лет назад

Caleb, why wouldn't you just make another column "2ndemail" in the user table, instead of making a completely separate table....? I'm not understanding "why" you're doing it this way for the solution. Insights are much appreciated!!

@nhiap6 8 лет назад

+Scott Hartman what if you wanted to add third email, forth email and so on.. You would have to constantly change your table attributes(meaning adding more email columns). This way you don't have to do anything and user can have as much emails as he likes.

@robertfox1975 8 лет назад

+Scott Hartman Imagine about a thousand users with just one email id. In that case it would be such a waste. a thousand fields ..just blank.

@silkerahbari7853 5 лет назад

Totally new to this, but couldn’t you break it down with two columns like email1 and email2? Just wondering.

@codebreakthrough 5 лет назад

This is exactly what we don’t want to do, but is commonly thought of as a solution. Then everybody who doesn’t have a second email would have NULL and those who have 3 emails wouldn’t be able to fit. Although this is usually fine for small number of columns (email1 and 2 wouldn’t be the end of the world), if it’s something that may have 3+ values, it’s gonna get ugly quick.

@linguisticsgrad404 5 лет назад

A full address CAN be atomic --it depends on whether it is appropriate to handle it as such for the problem at hand.

@codebreakthrough 5 лет назад

Agreed.

@hassanayub5599 5 лет назад

dont know y we pay £9k fee to uni when have to learn from caleb curry Good job mate!

@chenchen2308 8 лет назад

Thanks so much! It really helps!!

@sonwabolloyd7473 8 лет назад

Thank you

@andrewgrass2082 6 лет назад

Couldn't you have also combined user_id with email as a composite key? That way, you wouldn't need a second relation.

@andywang2483 4 года назад

Why are you creating an email key since the email address is already unique? but good video none the less

@arlogodfrey1508 5 лет назад

Two values in one? Sanitize your inputs

@jfedererj 7 лет назад

Cracking video, lad

@t.g2089 6 лет назад

You are the best!

@MyRandomNick 6 лет назад

What is the reason for having an `email-id`?

@jonesrz 8 лет назад

Good work. Looking at variations of examples.

@jonesrz 8 лет назад

+jonesrz Spoke too soon. Can be better, but at least looking at more examples.

@marcusmatamua4213 9 лет назад

How would you put a invoice into 3nf?

@tahahasan6600 5 лет назад

Thank you so much

@cherrybloom22 4 года назад

I'm watching all your videos for my exam when my lecturer at uni uses all these fancy words which confuses me. ty for uploading

@Pointdexter07 8 лет назад

You....are awesome!!!

@spacepod100 9 лет назад

what did you say we should do with the address situation?

@codebreakthrough 9 лет назад

+spacepod100 You could split it up into street address, city, State, Area code...Split it up as much as you like.

@General111100 6 лет назад

that humor! hello from 2017! lols

@hirankosala123 2 года назад

Man ur a GOD =)

@abdulmoizahmer9770 7 лет назад

I would have made a composite key with the email id with the primary key instead of making a new table.

@jerichabradley4715 5 лет назад

THANK YOU!!!!

@darthbleen984 7 лет назад

Hey man!!! that was funny

@conlzn2921 6 лет назад

likeable guy. nice job dude thanks

@isaiahmcgee1336 5 лет назад

your are amazing!

@runman1271 7 лет назад

Great Vid Thanks\

@anyapekoe-u 8 лет назад

love u

@happylittlemonk 7 лет назад

Teaching computer science on a black board with chalk. That's what I call progress.

@jointglobalceo 8 лет назад

Bool video!

@tredbailey 6 лет назад

man if i could email you this table ive been working on you think you could tell me if it is in 2NF or not. Lol ive been working it for like 3 hours and Im in the same spot. I think I'm nuking it but then again I'm just not sure.

@codebreakthrough 6 лет назад

Does it have a primary key consisting of two+ columns?

@tredbailey 6 лет назад

CalebTheVideoMaker2 no but when I broke the table up I would have a primary key that repeats.

@BruT4LMC 5 лет назад

This video came into my recommended ... after the exam. xD

@codebreakthrough 5 лет назад

RIP 💀

@Lyftic 6 лет назад

His jokes are so stupid it makes me laugh. Does that mean he got good jokes? Yeah, no? Well informative and funny video

@lubokanev7436 7 лет назад

You look like a movie star to me

@ashkrallen9495 6 лет назад

dude

@CJKile 6 лет назад

u should be a teacher man

@XYReason 4 года назад

Huh, we have a funny guy here while he's making tutorial. Maybe he will make people laugh in youtube's Gulag.

@buttbuttyawn3280 9 лет назад

Could you just make the email table have a composite primary key of a user_id and email? This would allow you to relate an email to a user without using another column.

@THISSHOWNEEDSMORETITS 8 лет назад

the end is not near so there

@shawncho3385 8 лет назад

lol you are hilarious. great video!

@young9534 8 лет назад

My professor tried to explain data normalization to us and he over complicated it so much. Thank you for keeping it so simple.

@abdullahalarfaj4930 8 лет назад

I love night before exam short video. thank you.

@knightjia97 6 лет назад

watched this when i take level 1 database and came back when im taking level 2 database xd

@ensar6803 6 лет назад

finally found a not indian guy.

@ChristopherFranko 4 года назад

chalk on a chalkboard... asmr af.

@jefflong1799 4 года назад

Question:. You are calling the FINAL solution 1NF, correct? (ie., Not what you had to begin with, right)?

@lyndonhinge4272 6 лет назад

Really help me bro.tHANK YOU.

@TheSkepticSkwerl 5 лет назад

Now that i have learned as much as i Have, i hate database designers that are lazy. LOL i have a hyphenated last name, so they usually deny that... :(

@johnrobledo9597 4 года назад

I know this is one of his older videos, but I'm I the only one who noticed the ghost at 4:12 into the video?!! lol

@publicstaticvoid1 8 лет назад

this is my first time hearing and seeing chalk against a chalk board since i was in middle school in 09 and that shit made me cringe every time

@pappabear7617 4 года назад

lol what happened to the camera at 4:12

@evandawson1037 4 года назад

Thanks for your tutorial

@stdrum-nb6qr 8 лет назад

t y

@noobantimonitor1014 4 года назад

Why am I laughing 😂😂😂

@risausa4796 Год назад

Thanks Caleb!

@christanmiddleton8580 6 лет назад

Caleb is the Goat

@arthursimons6511 3 года назад

real aficionado

@denizdemir9255 3 года назад

ur cool

@rickeyrudey 9 лет назад

Frikking awesome. simpler than my University Lecturer could ever explain.

@robm1374 4 года назад

I'm so grateful that English is your first language. Finding database help in English, that doesn't have a thick accent has been difficult! Thanks for the video! I typed "explain full functional dependency" to find this video.