Second Normal Form (2NF) | Database Normalization | DBMS

For complete DBMS tutorial: www.studytonight.com/dbms/
In this video, you will learn about the Second Normal Form of DBMS. How to design a table which follows the Second normal form? What are the rules and requirements for a table to be in the second normal form?
Introduction to Normalization: • Basic Concept of Datab...
First Normal Form: • First Normal Form (1NF...
Second Normal Form: • Second Normal Form (2N...
Third Normal Form: • Third Normal Form (3NF...
BCNF: • Boyce-Codd Normal Form...
Fourth Normal Form: • 4th Normal Form (4NF) ...
Fifth Normal Form: • 5th Normal Form (5NF) ...
We will also learn about Functional Dependency and Partial Dependency in DBMS and how to remove the partial dependency by dividing the tables.
If you LIKE this video, give it a thumbs up and do SUBSCRIBE to our channel.
Our website: www.studytonight.com
Facebook: / studytonight
Twitter: / studytonight

[@MuhammadUmar12]

you deserve my teachers salary!

[@Hinaamjadamjad]

eglish english english🤨

[@trevorli2697]

Why am I paying my college fee, I should pay this guy

[@Mr.Unknown2137]

Legend are watching this video 5 uear after 😅

[@deadlyundead]

this guy explained this better is 7 minutes then my professor did in a 3 hour lecture.

[@LuvxJacqu4li8e]

I learned DB in college more than 25 years ago but never got back to it until mysql and possibly your normalization form. I wonder if I wasted a lot of money.

[@arijitgayen4674]

A whole semester passed by as the 'experienced' professors of an 'Institute of National Importance' couldn't clear out these concepts and you made it crystal clear in less thsn 30 minutes. I'm grateful to you Sir.

[@rajatjoshi6695]

You have a voice of a perfect speaker. Its lucid to get every single point you want to make. Thanks for your efforts.

[@jeremyfields5485]

I have a question, why is student_id and subject_id a more meaningful primary key? If you just used score_id as the primary key, wouldn't the problem of partial dependency no longer exist? Because you couldn't have partial dependency when it's just one attribute for the primary key?

[@yakoob4220]

I studied about the normalization on many websites but couldn't understand. Your videos are very clear to make me understand the concept. Thanks a lot.

[@saayoo3479]

For a table to be in the Second Normal form, it should be in the First Normal form and it should not have Partial Dependency.

[@HandledToaster2]

I know you get this a lot but I have to say it too: Your explanations are much better than my professor's, I should be paying you instead of him. We need more people like you in college, the skills of making things simple, creating good videos, and being a good speaker are desperately lacking in college. I have a professor who literally tells us to study from youtube videos and doesn't teach anything himself LOL.

[@rashi2937]

Perfect :

[@wirito]

6:36

[@Zeus-bc8fv]

Great job, this video came out 2 years ago, really helped me and will keep helping students for the next years for sure! Thank you.

[@Rajivrocks-Ltd.]

Fantastic explanation my friend! I got it immediatly while when my teacher explained it I didn't understand it at all. Thanks so much for the content!

[@LaneChoice]

I am struggling with this concept and your videos are helping tremendously. You are a great teacher! Thank you.

[@zenryyu1821]

You're a fantastic teacher, you covered everything someone may or may not know in one video.

[@lazykitten4356]

Thank you so much. I watch more than 20 videos about 2nd NF on RUclips and still very confused . Yours is the only one that clearly explains 2nd NF.

[@advaithrvasistha44]

dude others on yt are just yapping...on this topic