What is Normalization in SQL? | Database Normalization Forms - 1NF, 2NF, 3NF, BCNF | Edureka

🔥 MySQL DBA Certification Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): www.edureka.co/search
This Edureka video on 'What is Normalization' will help you understand the basic concepts of Normalization in SQL and Databases and how it helps in organizing data and data redundancy in SQL with examples. Below are the topics covered in this Database Normalization tutorial:
What is Normalization?
1st Normal Form (1NF)
2nd Normal Form (2NF)
3rd Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)\
-------------------------------------
To subscribe to our channel and hit the bell icon to never miss an update from us in the future: goo.gl/6ohpTV
SlideShare: www.slideshare.net/EdurekaIN
Instagram: / edureka_learning
Facebook: / edurekain
Twitter: / edurekain
LinkedIn: / edureka
#edureka #edurekasql #sqlnormalization #sqltutorialsforbeginners #sqldbms
-----------------------------------------------------------------
How does it work?
1. This is a 4 Week Instructor-led Online Course.
2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
3. At the end of the training, you will be working on a real-time project for which we will provide you with a Grade and a Verifiable Certificate!
--------------------------------------------------------------------
About The Course
MySQL is the most popular open-source database. This training is your first step towards gaining a strong foundation and hands-on experience in using and administering this open-source relational database.
You will gain an understanding of the core concepts and advanced tools and techniques to manage data and administer the MySQL Database. Through this training, you will gain the ability to create and administer your own MySQL Database and manage data.
----------------------------------------------------------------------
Who should go for this course?
This course can be beneficial for people having the below professional background:
• Database Developers
• Application Developers
• Database Designers
• Database Administrators
-----------------------------------------------------------------------
Why learn MySQL DBA?
Edureka's MySQL Administration training is based on the MySQL Database 5.6 version. This is your first step in getting to know this open-source relational database with extensive hands-on learning.
You will get a general understanding of relational databases and techniques to design an efficient database system. You will learn the powerful Structured Query Language (SQL) to build a database and manipulate data. You will also learn the various administration skills required to manage the database.
-----------------------------------------------------------------------
Got a question on the topic?
Please share it in the comment section below and our experts will answer it for you.
Please write back to us at [e-mail] or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information.

[@edurekaIN]

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka MySQL DBA training curriculum, Visit our Website: bit.ly/2B5EwLJ

[@DavidEspinosa21]

1NF: 4:16 2NF: 5:37 3NF: 7:37 BCNF: 9:52

[@alexandrospanag]

jesus christ you took 15 minutes when my teacher took more than 6 hours and i still hadnt learned anything from! You are a genius sir thank you for the video!

[@edurekaIN]

Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.

[@haniffaris8917]

But wasn't the table in the 3NF example not yet in 2NF? Isn't Subject (Non-prime attribute) is partially dependent on Subject Id (candidate key)?

[@StateEnemy01]

I have a textbook that 'explains' this subject. That book could have been written in hieroglyphs and it would make more sense to me. Thank you so much for the very clear explanation! Helps me a lot!

[@shatakshipandey3942]

When my professor was teaching I couldn't understand what was even the need for normalisation let alone itself but u made it clear in the very start. Now my all doubts are clear regarding this. Grateful that I came through this video. Helped alot 👍

[@edurekaIN]

Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)

[@andrewkoh9678]

I understand much clearer now, Thank you!!

[@mahimsd7645]

Congratulations for 1 million subscribers ...

[@kratikakothari6848]

Great explanation in jus 13 minutes 🙌👏 Understood the whole concept

[@sneharay60]

The video was really very helpful to me. It's because of the presence of teachers like you that students can understand the topics instantly especially those who don't have tutors

[@edurekaIN]

We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@franzbiberkopf9179]

Thank you very much for this from Rome.

[@gretelgomezrodriguez4006]

Great explanation. Thank you!

[@vaishnaviv7113]

It's my exam today and that was really helpful thank you very much

[@himanshupande3707]

awesome explanation...clear and precise..

[@pranavwagh9350]

what is difference between 2NF and BCNF ?

[@sajidmanzar]

What about 4NF and 5NF? Are these two NF really needed in real scenario?

[@hopeislife1651]

Understood sir, thank you

[@marc4594]

Thank you man, you are great!

[@vidyabukitgar]

Thank you so much sir nice explanation !!

[@Peeves22]

Amazing breakdown of a complex concept - thank you!

[@pavanputluru3417]

What is the difference between 2nd and 3rd? By looking at the examples in the video both looks same. Please let me know thanks

[@edurekaIN]

To make sure that the database must in 2NF, the database should be 1NF and should also have a single-column primary key. Also, to make sure that the database must in 3NF, the database should be in 2NF and must not have any transitive functional dependencies. If you want an example on Normalization, refer to the following article:www.edureka.co/blog/sql-tutorial/#normalization

[@moulimallina7501]

Tq edureka, tq professor

[@afsardesign]

Really it is very helpful for me to get clarity about this topic for my upcoming exam Thanks a lot for giving us knowledge 👍👍👏

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@burcukaradag2975]

Thank you, you are awesome this is the fifth video that I ve been watching for normalizations, I just understood with your video, thank you very much

[@edurekaIN]

You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@ayamohammed7655]

Thank you !!

[@djgulston]

What a man! Brilliant explanation! Thank you for this!

[@edurekaIN]

Thank you so much for the review ,we appreciate your efforts : ) We are glad that you have enjoyed your learning experience with us .Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@bhanupriya2244]

I had left only 1hr for xam I jst saw this video twice nd written the same question, the explanation was very clear can understand easily

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@sowmyasunkara7136]

Thank You sir.

[@jeevitham205]

Clear explanation is super Sir. We need more concept i.e. about keys db commands. How to write queries and also 4nf...

[@edurekaIN]

It is great to know that our contents are helping you learn better and learn easy ! We are super glad to know and have learners like you with us. We'll definitely take your suggestion to the team and create content on this ! Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@arsha0206]

well explained

[@aj7ttt]

when I need to understand some topic, I just search topic name + Edureka ✨

[@edurekaIN]

Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)

[@mayanksoni214]

And this is how I feel in love with the DBMS Subject.

[@edurekaIN]

You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@Zed.1836]

this was very helpful thank you for making this!

[@maryamfatima5882]

very clean and clear session

[@edurekaIN]

Glad you think so! Keep learning with us..

[@mahesh97413]

Very Nice explanation tq.

[@Abhi_JW999]

Thank you

[@arshiya_83]

thank you so much for amazing session sir 🙂

[@edurekaIN]

Most welcome

[@nvkchannel8201]

thanks Sir...too good

[@jackieboi321]

Excellent video

[@pavankumarreddykattameddi8385]

Can u please explain bcnf and super key

[@mudassiribad2910]

Thank you sir very grateful explanation in simple method very helpful for me by these explanation i had cleared all the doubts regarding this concept

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@jpoezi]

sir you are a genius

[@dakaninongpluh4556]

thank you sir ,very simple and clear explanation

[@edurekaIN]

You're welcome 😊 Glad it was helpful!!! Keep learning with us..

[@navnathbhure3789]

One of the best lecture video i have ever watched ..

[@edurekaIN]

Glad it helped

[@complexity8851]

I wish I had this video when I was in College

[@anshumanster]

Excellent

[@badhavaththukaram9538]

good 👍

[@saltech2024]

Great explanation!! This may come in handy and clearly understood the concept when you've got a project at hand

[@edurekaIN]

Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@flipflop5189]

very informative, thank you for posting this!

[@edurekaIN]

You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@dhaneshpt8641]

Thank you...

[@Vishnu-ix2di]

Thanx for the video. I got clarity on this topic by this video.

[@edurekaIN]

You're most welcome :) Glad it was helpful !!

[@mumbaikachallenge5526]

Superb simple and short!❤️

[@edurekaIN]

Thank you 🙂

[@surya.k7793]

thank you

[@mohdzarrar2793]

Great explanation.

[@livefootballmondiale2302]

very interesting and explicite and easy to understand

[@edurekaIN]

Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )

[@manojreddy444]

Thanks

[@amanbhargava2702]

Thank you😊😊😊

[@kapilkarki1696]

Thank you for this beautiful and clear explanation bro

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@017gowthamarajaam8]

thanks a lot

[@lorenzoliswaniso591]

Thanks🙏🏽

[@pravallikamanepalli1061]

Thank you edureka

[@edurekaIN]

You're welcome 😊

[@muhammadkamranjaved2424]

Man you are great!!!

[@edurekaIN]

Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fullqfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@matthewdodson9422]

THANK YOU for the concise and clear examples!

[@edurekaIN]

Glad it was helpful!

[@user-ux4sp3ot2c]

Very nice.

[@s.r.chockklingam3991]

What's about 4nf & 5nf

[@aatmakumar4631]

Nice class

[@pcgmotorsport9299]

Thank you so much, awesome video

[@edurekaIN]

Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fulfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@TheCraftMasterChronicles]

My exams tommorow, this video really helped alot.

[@edurekaIN]

Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@azmatkhan3895]

Good explaination Sir...!

[@edurekaIN]

Thank you so much for your review on our channel  Great to hear that Edureka is helping you learn better . We’ll strive to make even better learning contents/courses in the future ! Do subscribe the channel for more updates : )

[@aniketrajapure8251]

Thank You

[@priyanshu6465]

jeez thankyou

[@mohanreddy2404]

I think no one can explain better than you..

[@edurekaIN]

Thank you 😊 Glad it was helpful!

[@sarmmadd]

vv good. explained ccoly. aprreciate it boss.

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@binoyaravind1025]

Great session with examples

[@edurekaIN]

Glad you liked it!

[@jishajustin9523]

Good explanation. I got it.

[@edurekaIN]

Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)

[@shivaprasad-kn3kw]

can a table have two primary keys

[@edurekaIN]

We can have only one Primary Key on a table. Keeping this in consideration and to enforce database normalization (third normal form) databases don't allow multiple primary keys on a table. You can create primary key spanning multiple columns. You can also create a UNIQUE constraint on a NOT NULL column.

[@shaikmohammed9981]

Good explanation👏🏻👏🏻👏🏻👏🏻

[@edurekaIN]

Thank you 😊 Glad it was helpful!!

[@maneeshapathipati2084]

Thank u sir it's very ...nice

[@edurekaIN]

Most welcome 😊 Glad it was helpful!

[@karrisateesh7938]

very good explanation.

[@edurekaIN]

Glad you think so!

[@shravyashetty3115]

thank you so much

[@edurekaIN]

You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@anexusthanatos4021]

Great video!! 👍

[@edurekaIN]

Thanks for the visit

[@delanocripps4339]

Idea!! Keep going bro

[@edurekaIN]

Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@someshwarans2889]

awesome session sir but i need 4nf and 5nf..

[@edurekaIN]

Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update

[@latieshsai5192]

sir pls put a video on cyber forensics sir the branch of future cyber security way that proves to be the correct way

[@edurekaIN]

Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update

[@gauravarora8405]

difference between 2nd and 3rd normal form

[@edurekaIN]

In 2NF non-prime attributes are allowed to be functionally dependent on non-prime attributes. In 3NF non-prime attributes are only allowed to be functionally dependent on Super key of relation. No partial functional dependency of non-prime attributes are on any proper subset of candidate key is allowed. Hope that solves your query.

[@chodingninjas7415]

best explanation

[@edurekaIN]

We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@alvarobusquets]

Edureka is the best school 👍

[@edurekaIN]

Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )

[@ekant1992]

And then come NoSQL DB which difies all these ... tech world is bizzare..

[@edurekaIN]

SQL and NoSQL are used to store different formats of databases. So, both of them stand good against each other and you have to choose which type of database can help you and your organization.

[@anushanelevalli1407]

🙏 srir

[@vadlapudirajesh4183]

❤❤❤❤❤❤❤

[@harshitsrivastava9903]

😇😇

[@prajwalbhat275]

Nice sir

[@kashyapdamodar7338]

I couldn't get past the distraction caused by the instructor pronouncing Data as Deeeta. Seemed like a good tutorial otherwise, so truly its my loss.

[@evnraja]

well explained

[@rainboww1515]

Thank you

[@masadamsahid]

Thanks