Second Normal Form (2NF) | Database Normalization

No video

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

Рет қаралды 1,186,523

Күн бұрын

For complete DBMS tutorial: www.studytonig...
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.studytonig...
Facebook: / studytonight
Twitter: / studytonight

Пікірлер: 577

@MuhammadUmar12 5 жыл бұрын

you deserve my teachers salary!

@kristianusifoh9307 4 жыл бұрын

lol

@victroz-rix3601 4 жыл бұрын

@@kristianusifoh9307 Are You his teacher?

@GoliBodhini 3 жыл бұрын

Haha best reply. Ji

@aryanverma7800 2 жыл бұрын

@@victroz-rix3601 savage

@sabuku03 2 жыл бұрын

so true lol

@saayoo3479 4 жыл бұрын

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. Partial Dependency exists, when for a composite primary key, any attribute in the table depends only on a part of the primary key and not on the complete primary key. To remove Partial dependency, we can divide the table, remove the attribute which is causing partial dependency, and move it to some other table where it fits in well.

@bluesteel1 3 жыл бұрын

This is a better explanation imho

@peterchimbuto 3 жыл бұрын

Thank you for this too 😇

@khalifabalarabe4801 3 жыл бұрын

This makes sense

@premsainoolu8290 2 жыл бұрын

Explained too better

@widadfaisal676 2 жыл бұрын

Thanks u so much

@trevorli2697 5 жыл бұрын

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

@anubrataghosh726 4 жыл бұрын

Exactly I understood more in this video than any lecture in my class

@sajidfaruki8054 2 жыл бұрын

Same

@arijitgayen4674 4 жыл бұрын

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.

@Studytonight 4 жыл бұрын

Thank you Arijit. Share it with your classmates so that they can also learn from these videos. You can practice what you have learned in these videos here: www.studytonight.com/code/playground/sql/

@rajatjoshi6695 6 жыл бұрын

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

@Studytonight 6 жыл бұрын

Thank you Rajat for the appreciation.

@deadlyundead 3 жыл бұрын

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

@leblanc8552 2 жыл бұрын

fact!

@ahmarzia1553 2 жыл бұрын

Same Here😂😂

@tayyabshabbir8153 2 жыл бұрын

hahah

@fadikamalickchristelysee5182 2 жыл бұрын

i swear

@jamestucker4800 Жыл бұрын

You guys have 3 hour lectures? Holy

@Zeus-bc8fv 3 жыл бұрын

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.

@Studytonight 3 жыл бұрын

Thank you so much for your kind words and Merry Christmas :)

@rashi2937 4 жыл бұрын

Perfect : - EXPLANATION - VOICE - PRESENTATION

@yakoob4220 6 жыл бұрын

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.

@Studytonight 6 жыл бұрын

Thank you Yakoob :)

@Rajagopal111 5 жыл бұрын

Same scenario here. Your videos are very simple and easy to understand

@LaneChoice 4 жыл бұрын

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

@wirito 3 жыл бұрын

6:36 thank you for not ruining the tutorial by explaining one sentence in English and then doing it in another language- all throughout the video. I hate when people do this. They are just lazy and unprofessional. Thanks again. Your videos are high quality :)

@advaithrvasistha44 5 ай бұрын

dude others on yt are just yapping...on this topic you are the only one who explained prprly thanks

@Studytonight 4 ай бұрын

Thanks dude!

@HandledToaster2 4 жыл бұрын

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. Thank you for your service to students, I appreciate immensely.

@pratibhasharma5056 4 жыл бұрын

I am watching it after 2 years but the video is amazing. The best part is how you explained the relevant topics also like what is partial dependency , primary key and many more so that students can understand the basics completly. Kudos to you!

@munibaakram093 4 ай бұрын

Me after 6 years😂

@Rajivrocks-Ltd. 5 жыл бұрын

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!

@zenryyu1821 4 жыл бұрын

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

@charu317 4 жыл бұрын

It is a very good explanation for students and programmers....yours english is very fluently and understanding easily............Tq so much for ur teaching...........

@saintgermainowl4170 Жыл бұрын

This Is helping me a lot to understand the normalization of database creation. Being in a position to practically use this makes the whole priority of concern more viable.

@lazykitten4356 5 жыл бұрын

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

@SunnyKirtkar-jd8ew Жыл бұрын

Seen this video when I was in 3rd year (2019), seeing this video now (2023) as I am preparing for my MBA interview. Best explanation.

@Studytonight Жыл бұрын

That makes it eternal

@sharanpreetkaur8662 5 жыл бұрын

I like that - practice makes "man/woman" perfect - thing ,, nd the video was so helpful,, keep it up

@andricozach 6 жыл бұрын

This is such a clear explanation of the content and the other videos about RDBMS. Thank you! Too bad 3rd normal form is not out yet...

@Studytonight 6 жыл бұрын

Hello Andrico, video for 3rd Normal Form is now available on our channel :)

@ujjawalchatterjee 6 жыл бұрын

Love your style sir...Thank you for the upload.

@Studytonight 6 жыл бұрын

Thank you Ujjwal. Do share the video with your friends.

@ujjawalchatterjee 6 жыл бұрын

Studytonight Sure sir

@pratapsingtomar6507 4 жыл бұрын

It is best way to clear my concepts about DBMS thank u sir

@auroresoir1091 5 жыл бұрын

THIS THURSDAY IS MY DATABASE EXAM! THANK YOU FOR THIS WONDERFUL EXPLANATION!!!

@auroresoir1091 5 жыл бұрын

Qasim Butt Me too . All the bestt!!!

@akanshasaraswat7274 4 жыл бұрын

thanku so much sir for your explanation in brief, after 4 years from study , today i learnt normalization in brief and very clear concept, your voice is very clear. Thanks alot god fulfill your all wishes. jai hind

@GFC1337 5 жыл бұрын

FINALLY SOMEONE WHO KNOWS HOW TO TEACH!!!!

@saranraja962 Жыл бұрын

I watching lot of video and resources but you explain easy & clear explaining ❤

@Machine_Mantra 4 жыл бұрын

Thanks for the videos. it is like reaching from zero to a comfortable level in this topic. Great Work :)

@mightbenitin 2 жыл бұрын

First time I came to your channel, What are the things I like about your video: 1) Clear visual presentation 2) Not repeating same sentences multiple times to increase the video length 3) Explained all dependent concepts.

@Gamer-ec8dv 4 жыл бұрын

Thank you so much! You are really saving me, as I'm writing my final in 2 days. I really appreciate these videos. Please keep up the good work

@robertoenriquechavezrodrig731 5 жыл бұрын

Thank you so much for this videos, sir! Regards from Russia :)

@desmondsilva3313 4 жыл бұрын

Please keep up the English courses. This was very helpful and easy to learn. You're a very good teacher and your diction is great. :-)

@premsainoolu8290 2 жыл бұрын

Amazing content in just 5 minutes

@Rajagopal111 5 жыл бұрын

The way you are teaching is very easy to understand... Thanks for the good work. Please continue doing this

@ArtOfBeingNerd Жыл бұрын

Bro explained better than rest of top channels

@Studytonight Жыл бұрын

Thank you. Subscribe to the channel :)

@radharanipanda3784 Жыл бұрын

Your peaceful voice is enough to understand the concept. Thank you so much sir 🙌🏻🙏🏻

@SamyD23 3 жыл бұрын

PERFECT. around 5:20, this explained the difference between 2NF and 1NF so much better than Wikipedia. great job!

@jraymer9141 6 жыл бұрын

Your videos are very simple and easy to understand. Thank you very much❗️ 🤠👍 I really enjoy the content in its simplicity 😀

@Studytonight 6 жыл бұрын

Thanks J!

@_outcyrptolist 4 жыл бұрын

I'll suggest your channel to my fellow mates! Your presentation of material is just phenomenal

@quanticrobotics6467 4 жыл бұрын

I love to watch your channel's content. You are one of the best worldwide. Your content is clear and easily understandable. Thank you very much for sharing your knowledge with us.

@ngahuynh9912 6 жыл бұрын

It's very helpful for me, your English so clear, this make me easy to understand, thank you very much

@shikhargupta2841 4 жыл бұрын

Really man!! This video helped me a lot. The usp is it's short and targets even the basic points. Thank u so much and keep up the good work

@stevekemgang3585 3 жыл бұрын

that was a good explanation concerning normalization. Am impressed

@10-madhumitamanikmahapatra73 Жыл бұрын

Ahhh!!! Thank you so much!!! It really helped me a lot.There are some channels for every subject which makes student life more easier and you are the one from them😁.

@Studytonight Жыл бұрын

Thank you for your kind words 🤩 I just try to simplify concepts for beginners, because once I myself was a beginner 😀

@fahmifarhat7076 4 жыл бұрын

thank you, very clear explanation that I did not find anywhere in the internet!

@vaskrneup 5 жыл бұрын

Sir, Your video is honestly one of the best one. Also, that men/women perfect statement made it look prettier. :)

@varsha2743 Жыл бұрын

your way of teaching is really clean, and the content's really amazing!

@StrangerDanger1429 4 жыл бұрын

You are honestly making me feel better for my midterm

@adeelsiddiqui9250 4 жыл бұрын

Love From Pakistan.... I just saw your video, so simple and easy to Understand. To the point video

@fromdil6470 2 жыл бұрын

Thanks for providing those materials for free. Your teaching style is very clear, and you pinpoint our doubts and clear them very nicely. Please keep up the excellent work. Please always provide lessons in English also. I think it is a good way for anybody to learn terms quickly. I need to kindly ask you to not abandon the international language, please. Namaskar!

@Studytonight 2 жыл бұрын

You are most welcome

@ganesh5a360 4 жыл бұрын

Everyone understand this easily thanks for upload sir

@aminasidky7751 5 жыл бұрын

Thanks for putting effort into explaining this, your style is great! From Egypt with love

@GNAFerreira 6 жыл бұрын

Thank you, sir! Now I finally understood what the 2NF is! Great video!

@stunningkd4487 Жыл бұрын

Its incredible . I finally untersdood the concept of normalisation by watching this video. Thanks a lot

@priyankac7478 5 ай бұрын

really ur vedios are so usefull and u explained clearly thank you

@Studytonight 4 ай бұрын

You are welcome 😊

@arsalalam5998 10 ай бұрын

i'm pursuing mtech, and this video has given more understandable content on 2NF+partial dependency, than shitty college 2-hour class.

@Studytonight 10 ай бұрын

Hehe! Thanks for your comment. When I was in college, I faced the same and decided to learn everything and make good content to help others understand.

@manishtomar6511 6 жыл бұрын

Very Well Explained.. It will clear out all doubts.. Thank You Sir...

@Studytonight 6 жыл бұрын

Thank you Manish, do share it with your friends.

@mihirnaidu5211 Жыл бұрын

The best explainor ever had in my lifetime 💖

@coelhorita 4 жыл бұрын

Thank you for making these videos, I am studying for an exam and was not understanding normalization until I came across your videos!

@shahidfazl8385 6 жыл бұрын

The most precise explaniation even a begiiber can master database by watching studytoinght videos..thanks a lot sir.. loved this videos n hope,Studytonight team makes more videos on different basic subjects of computer science.. it helps a lot..

@Studytonight 6 жыл бұрын

Thank you for your appreciation Shahid :)

@mariakelly237 2 жыл бұрын

What a lovely man! Thanks so much for your videos, I am learning lots!

@nspal 6 жыл бұрын

Thank you very much sir for uploading this topics...l would like to request you, please upload all the DBMS concepts.

@tysonsalama5367 6 жыл бұрын

From simple to complex,thanks a lot

@Studytonight 6 жыл бұрын

Thank you Tyson for your comment.

@wubethiopia982 2 жыл бұрын

the video is very clear so i would like thank you

@Studytonight 2 жыл бұрын

You are welcome :)

@auroresoir1091 5 жыл бұрын

I can simply do notes from your videos and it super good in helping me to understand this subject .

@jeremyfields5485 4 жыл бұрын

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?

@shameenrana6723 2 жыл бұрын

did you find out why??

@MayanaHebaKhanam 6 жыл бұрын

Thanks a lot.your way of explanation is just awesome but I want more videos on all the topics of DBMS,i will be thankful 2 u if u do so.once again salute 2 your excellent explanation

@Letsbetog 2 жыл бұрын

best ever explanation that i got.

@arpitac9481 Жыл бұрын

The best explanation heard ever....

@Studytonight Жыл бұрын

That's what everyone says :) ;)

@studypointspoffical 4 жыл бұрын

I really like a way you teach and way of giving examples with explanation

@taufiqsept 5 жыл бұрын

Clean video, clean website, accent is not too shabby either.

@govindraokulkarni 5 жыл бұрын

crisp and clear (y) best video series on this topic

@supriyakachroo5158 6 жыл бұрын

Please keep uploading more such videos and include other subjects as well like quant & verbal

@Studytonight 6 жыл бұрын

Hello Supriya, Thank you for your comment. We will definitely work on those subjects too, once we cover more of Computer Programming subjects.

@shadmanahmed3666 4 жыл бұрын

thanks for your nice teaching .Best wishes to create more videos even better than now from you.All the best

@simondolapo1567 2 жыл бұрын

Watching this video and I'm just saying wow... Thanks for explaining this concept really well🙌

@Studytonight 2 жыл бұрын

Thank you so much

@sumedhakumar1771 5 жыл бұрын

The tutorials are very helpful, but i am looking forward ,if you could upload a video about functional dependencies....hope you come up with it as soon as possible.....

@muthulakshmir4307 3 жыл бұрын

Thank you so much for your clear explanation

@Studytonight 3 жыл бұрын

Welcome 😊

@vijaykumarhosur715 4 жыл бұрын

Doing good job sir... So people can do best...

@shivkr205 6 жыл бұрын

channel name describes your channel best, as i am studyingtonight. hahah 'got u know ur channel by ur website'.....website is also good....

@syd4747 7 ай бұрын

You're a life saver🛐🔥

@deeepdhaliwal8393 5 жыл бұрын

thankyou sir ur teaching way very effective it helps alots

@largibolala2691 5 жыл бұрын

i havent met him but i feel a connection w him more than i do w my lecturer who i see 2x a week.

@jackym7734 2 жыл бұрын

I have an interview tomorrow, thank you!!

@Studytonight 2 жыл бұрын

All the best for your interview :)

@amaranneji 10 ай бұрын

thank you for this clarification made on this normalisation

@Studytonight 9 ай бұрын

You are most welcome, glad you liked it!

@rooparamesh9851 11 ай бұрын

Hi. Thanks so much for the clarity that you have set in for us in Normalization. I am keen to build my skills in Python & SQL. I shall look forward to your support.

@Studytonight 9 ай бұрын

Ok. I will try to come up with more videos to help you out 😇

@franklintartnda2387 5 ай бұрын

I read books 📚 and books plus teacher's explanation but I couldn't get this easier.. you deserve my teacher salary 😂

@AdityaJain24 6 жыл бұрын

Awesome videos! Really helpful. Easy to understand and saves a lot of time. Keep up the great work!😀

@Studytonight 6 жыл бұрын

Thank you Aditya.

@abhishekabhi1122 10 ай бұрын

Great teacher! Thank You😊

@Studytonight 10 ай бұрын

My Pleasure ☺

@maryamrakin834 2 жыл бұрын

Love from afghanistan 🇦🇫 , i am 3rd semester student and i hv exams thanks to u …

@nirajbhattrai5999 5 жыл бұрын

The way you taught us is awesome..plz keep unloading

@samirpatel9846 Жыл бұрын

You teach to good it help me a lot

@Studytonight Жыл бұрын

Thanks for your comment 🤩

@dharmikgohel2663 3 жыл бұрын

Great explation very simple thanks

@Studytonight 3 жыл бұрын

Glad it helped

@CatOfCulture Жыл бұрын

This video was brilliant. Good job.

@Studytonight Жыл бұрын

Glad you enjoyed it!

@Marius-vw9hp 5 жыл бұрын

We need more good Database tutorials on youtube. I am subscribing in the hope you will make more of them! :)

@nandinimhamane6405 6 жыл бұрын

wow sir!!!!!! this helped me a lot!!! u have a unique way of teaching!!!

@ouassimbehlil3557 Жыл бұрын

Good work, I was really struggling to Understand this.

@Studytonight Жыл бұрын

Glad it helped you. Now help me by sharing and liking it and subscribing to the channel

@codinginframes 4 жыл бұрын

best guru whatever u teaches cross my mind .

@charliezhang4586 6 жыл бұрын

Crystal clear explanation to each detail!

@dsa_tutorial 11 ай бұрын

really mindblowing video

@Studytonight 11 ай бұрын

Thank you so much 😀