Second Normal Form (2NF) | Database Normalization | DBMS
Вставка
- Опубліковано 3 лют 2018
- 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
you deserve my teachers salary!
lol
@@kristianusifoh9307 Are You his teacher?
Haha best reply. Ji
@@victroz-rix3601 savage
so true lol
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.
This is a better explanation imho
Thank you for this too 😇
This makes sense
Explained too better
Thanks u so much
Why am I paying my college fee, I should pay this guy
Exactly I understood more in this video than any lecture in my class
Same
this guy explained this better is 7 minutes then my professor did in a 3 hour lecture.
fact!
Same Here😂😂
hahah
i swear
You guys have 3 hour lectures? Holy
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.
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/
You have a voice of a perfect speaker. Its lucid to get every single point you want to make. Thanks for your efforts.
Thank you Rajat for the appreciation.
Perfect :
- EXPLANATION
- VOICE
- PRESENTATION
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!
You're a fantastic teacher, you covered everything someone may or may not know in one video.
I am struggling with this concept and your videos are helping tremendously. You are a great teacher! Thank you.
Thank you so much. I watch more than 20 videos about 2nd NF on UA-cam and still very confused . Yours is the only one that clearly explains 2nd NF.
Thanks for putting effort into explaining this, your style is great! From Egypt with love
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
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.
Thank you so much for your kind words and Merry Christmas :)
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
We need more good Database tutorials on youtube. I am subscribing in the hope you will make more of them! :)
Thank you, sir! Now I finally understood what the 2NF is! Great video!
Thank you for making these videos, I am studying for an exam and was not understanding normalization until I came across your videos!
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.
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.
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.
Thank you Yakoob :)
Same scenario here. Your videos are very simple and easy to understand
I'll suggest your channel to my fellow mates! Your presentation of material is just phenomenal
dude others on yt are just yapping...on this topic
you are the only one who explained prprly thanks
Thanks dude!
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 :)
crisp and clear (y) best video series on this topic
Thanks for the videos. it is like reaching from zero to a comfortable level in this topic.
Great Work :)
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...
Hello Andrico, video for 3rd Normal Form is now available on our channel :)
thank you, very clear explanation that I did not find anywhere in the internet!
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. :-)
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.
The way you are teaching is very easy to understand... Thanks for the good work. Please continue doing this
It's very helpful for me, your English so clear, this make me easy to understand, thank you very much
Awesome videos! Really helpful. Easy to understand and saves a lot of time. Keep up the great work!😀
Thank you Aditya.
Sir, Your video is honestly one of the best one. Also, that men/women perfect statement made it look prettier. :)
Love your style sir...Thank you for the upload.
Thank you Ujjwal. Do share the video with your friends.
Studytonight Sure sir
PERFECT. around 5:20, this explained the difference between 2NF and 1NF so much better than Wikipedia. great job!
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!
Me after 6 years😂
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
Your videos are very simple and easy to understand. Thank you very much❗️ 🤠👍
I really enjoy the content in its simplicity 😀
Thanks J!
your way of teaching is really clean, and the content's really amazing!
Crystal clear explanation to each detail!
Thank you so much for this videos, sir! Regards from Russia :)
Well explained and clear structure, please post more!!! And thank you for sharing with us!!!
I can simply do notes from your videos and it super good in helping me to understand this subject .
Amazing work thank you so much. God bless you ❤
It is best way to clear my concepts about DBMS thank u sir
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.
That makes it eternal
Everyone understand this easily thanks for upload sir
Its incredible . I finally untersdood the concept of normalisation by watching this video. Thanks a lot
FINALLY SOMEONE WHO KNOWS HOW TO TEACH!!!!
I like that - practice makes "man/woman" perfect - thing ,, nd the video was so helpful,, keep it up
Thank you very much sir for uploading this topics...l would like to request you, please upload all the DBMS concepts.
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
Love From Pakistan.... I just saw your video, so simple and easy to Understand. To the point video
wow sir!!!!!! this helped me a lot!!! u have a unique way of teaching!!!
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..
Thank you for your appreciation Shahid :)
Best explaination ever heard for normalization ❤️
Great videos, super useful. Keep them coming!
It is a very good explanation for students and programmers....yours english is very fluently and understanding easily............Tq so much for ur teaching...........
Your peaceful voice is enough to understand the concept. Thank you so much sir 🙌🏻🙏🏻
What a lovely man! Thanks so much for your videos, I am learning lots!
THIS THURSDAY IS MY DATABASE EXAM! THANK YOU FOR THIS WONDERFUL EXPLANATION!!!
Qasim Butt Me too . All the bestt!!!
You are honestly making me feel better for my midterm
I watching lot of video and resources but you explain easy & clear explaining ❤
Clean video, clean website, accent is not too shabby either.
you have just gained a new subscriber ,thanks
thankyou sir ur teaching way very effective
it helps alots
The way you taught us is awesome..plz keep unloading
Thank you so much Mister!
Very clear explanation video! Thanks! :)
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.....
Very Well Explained.. It will clear out all doubts..
Thank You Sir...
Thank you Manish, do share it with your friends.
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😁.
Thank you for your kind words 🤩 I just try to simplify concepts for beginners, because once I myself was a beginner 😀
best guru
whatever u teaches cross my mind .
From simple to complex,thanks a lot
Thank you Tyson for your comment.
Loveeeee your videos!!! Thank you so much for the great content!
Please keep uploading more such videos and include other subjects as well like quant & verbal
Hello Supriya, Thank you for your comment. We will definitely work on those subjects too, once we cover more of Computer Programming subjects.
channel name describes your channel best, as i am studyingtonight. hahah
'got u know ur channel by ur website'.....website is also good....
Damn man. Your explanations are very nice and clear! And you guys seem like really nice people! Good job!
Thank you for the appreciation Talha Mubashir. We are humbled :)
Thank you for this video! Very helpful!
The best explainor ever had in my lifetime 💖
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.
I really like a way you teach and way of giving examples with explanation
that was a good explanation concerning normalization. Am impressed
Great sir i am intested in your videoes you deserves the gratest teacher
Thank you very much for sharing such a nice lesson.
Thank you for this video...It was very easy to understand.
Watching this video and I'm just saying wow... Thanks for explaining this concept really well🙌
Thank you so much
Doing good job sir...
So people can do best...
this helps me a lot, thanks !
i havent met him but i feel a connection w him more than i do w my lecturer who i see 2x a week.
Straight to the point explanation 👍😃
thanks for your nice teaching .Best wishes to create more videos even better than now from you.All the best
very simple and precise... and very effective
oh my god thankyou so much, glad to know this video and the channel!!!
I'm learning thanks a lot for sharing!
Brilliant explanation.. Hats off!
Great explanation. This is very helpful. Thank you very much
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!
You are most welcome
best explanations! Thanks a lot!