Normalization Example

[Kostass12]

now i feel confident for my coming exam!thanks a lot!!shame on the time i spent with my notes

[DesertFox900]

Madly in luv with this voice.

[DesertFox900]

Nice lecture and also the voice is soo sweet. Thank you for this great example. Your teaching easy to understand.

[BoosteyProductions]

Shouldn't ADV_AGE be removed from the table? It's unnecessary to include the age of an advisee, as it can be calculated by substracting the ADV_DOB from the current date. 

[irishdude1988]

lovely voice

[himanshu2811]

how to determine the normalization level of given tables?

[vaibesb4u]

tan Q pashortt it was so sweet of u to upload this video it was very simple yet clear

i wish u upload more such videos and be helpful to others may god bless u

[Anonymose119]

Will you please explain the complete normalization process 2NF-4NF ?

[Anonymose119]

Great Great Great ! Thank You

[jfsolorzano]

you pretty much summarize in 9 minutes the whole complex theory written in books. Now I can get back to them with confidence ! Thanks so much!!:-)

[SuperChewychoco]

i really love your voice

[gatieis]

I was so lucky 2 watch thz vid 2days before my exam .. :D

Thnks alot for thz video and I became Normalized !!

(BTW your voice is ideal for Fairy tales ! :))

wishes from Sri Lanka....!!!

[umair8986]

if you start charging for this video, you'd be millionaire :D. amazing workk!

[ZamfirChannel]

Because a Rank record is related to more than one Employee record (e.g., EMPNUM 114 and 118 both have the same Rank of Asst. Professor), couldn't we add a fourth table called RANKS with RANK_ID as the primary key, and add RANK_ID as a foreign key in the EMPLOYEES table? Good job!

[rhythmoflife2007]

Is it NF1 or all in 1, i.e NF1 TO NF3

[rhythmoflife2007]

is that NF1 or its all in 1, NF1 to NF3?Thanks!

[iLMMFAO]

oh my gosh before this video i was CLUELESS. Thank you so much i can't believe you made me understand it all ! Exam tomorrow :D

[WebCamCartmell]

canadit key

[Markoni100]

10x a lot i finally learned it :)) I have my database cis209 exam on 6th may! :( but is this fully normalized or it can be further broken down to BCNF?

[itsmeemario89]

nice explanation!!! thank you!!!! =)

[samraj008]

thank u so much.... really so helpful for me to understand few concepts in normalization... once again thank you so much to share this video....

[mylove0mylife]

I really appreciate this video. My professor (in Intro to SQL) recommended this because when she explained it the entire class was lost. This cleared a lot of things up! I wish you were teaching this class instead, might make more sense.

[MegaPhobo]

agree, Voice is really sexy! :) is it NF1?

[metallica929]

This looks more like mapping than normalization.

[Nalminji]

thanks.

[Foaman]

<3 I love you. This video is near perfect. Please, add code in description, though. Thank you, so much!

[pa1820]

thanx a lot..this video helped me a lot.

good work!

so, guys..good work on how NORMALIZATION works..MIllions times worth watchng!!

[haterdrinkinhaterade]

you have a lot of talent for teaching. i am very impressed, this is one of the best explanations i've seen.

[degekkerus]

OMG you have one of the sexiest voices iv ever herd in my life

[hussain1858]

outstanding!!!. Your is really great and your voice is slow so everybody can understand each step you do. That was really really helpful

[willzurmacht]

Thank so much! Really helped me a lot..

[ianniedabomb]

great, clear explanation. thanks for posting. I appreciate it.

[pouyanparsi]

Prelogic Solutions Ltd

Prelogic Solutions is one of Canada's providers of advanced information technology, products, services and business consulting expertise

Data Integration, Informatica PowerCenter consultation, Enterprise business solutions, Dynamic infrastructure.

[alqatel222]

thaaaaaaaaaaaank you verrrrrrrrrrrrrry much

[stankanz07]

You did good job on presentation, but sound is so low. I cannot hear you very well at all.

[neotenolo]

Thanks. I've read loads on this, and not been able to get my head around it before. Now I get it!

[raouldev]

thanx a lot!!!

[ryotNZ]

Very useful tutorial. I wish my instructor had explained the concept of normalization this clearly. Thank you so much!

[vamsik58]

THank u...very easy to understand,....

[danielsciberras]

Great video... can someone help me understand the last word of the first statement "Normalization is the process of breaking a table down into multiple tables until each has only one _____". Thanks...

[ZamfirChannel]

@danielsciberras "thing"

[CttBCory]

@danielsciberras "theme"

[TheSkepticalAtheist]

Great video. Thanks. You should do some videos on 1st, 2nd and 3rd Normal form.

[ZamfirChannel]

@TheSkepticalAtheist She just did.

[DrCOMPUT3R]

Thanks that was a very simple and easy to understand...

[pjarratt]

You explain in in such a clear wayI understand after just 10 minutes of video, something that I have struggled with all semester. Cheers boss.

[purerabbit]

Thanks a lot. You just cleared my mind for a moment. It was filled with gush when I thought of 3NF normalization. Thanks mate!

[GTigerAK47]

Thank you so much.

[hjaliliutube]

This is great!

Thank you very much.

[DjGalm]

thank you very much, i have a final in 3 hours and i finally got it... may i point out that you remind me of Emily Procter who plays Calleigh Duquesne in CSI Miami :P

[pashortt]

Thank you for the compliment. I am not far from Raleigh, so I guess the accent comes with the territory.

[colloredbrothers]

I wish you were my sql teacher :(

[MmansoorM]

I can't hear!

[chikotube]

I prefer the idea of keeping my foreign keys as the last fields, as to indicate they are repeated on another table.

[astroboy0969]

Wow!!!

You're so much better than my prof..

[drjoe51]

Wow great video. Very impressed.

THANK YOU SO MUCH!!!!

[BallisticBob123]

Thankyou soooo much ! awsome video that really helped me ! I cant really express my gratitude to you on a youtube comment, but i hope this is thanks enough because you thouroughly deserve it ! :D

[danish786hotmailcouk]

ooooooooo now i get it.. .well kinda.. good video.

[cookinganytimes]

This tutorial is perfectly precise and clear with the slow explaination.

Thanks so much!

[grandia2006]

Good video, better than what my prof is teaching.

Anyone who knows who is taking OMIS 4710 and see this msg, give me a message! :)

[RyuNagashima]

Wow! I finally get it now! Awesome vid! ^_^v

[banule]

You teach well... dummies have no problem. thanks

[gntshali]

i'm a dba and i've never understood normalization as well as i do now...from a 9 minute video! thank you!

[crookedson]

Thanks. I was completely lost before I watched this. Now I have a better understanding of whats going on in my database class. 5 stars.

[Claviale]

Your amazing!!

[therompalace]

very good tutorial. now i actually know how to normalize as opposed to just talking about it. thanks!

[bibchen23]

Join the club, my lecturers never explain it this well

[roller81]

Great videos. More informational from these few short videos than my professor was during a whole semester

[ogrishgirl]

Thank you!You helped me a great deal.Thanks youtube too.Without youtube I will never have chance to watch this video in China.

Anyway,great tutorial,thanks!

[sayyes400]

Thank you

[sayyes400]

Very Very Good & thank you

[AlanAlex5000]

Very Very good tutorial! Thank You!

[myoldreteacher]

Thanks for the video - it was very helpful!

[Koontaj]

Wow! no need for tutoring I have a better understanding..thanks your great. You have any videos on data modeling with the entity-relation model

[kingofiit]

you got a nice slow n steady voice ... and ur explanation is also sound .. if you are not a teacher you should consider tat as an option :)

[pashortt]

Thank you. I am a college instructor...guess I'm in the right profession after all.

[tqedgar]

Exemplary!