4.5 Second Normal Form 2NF

Поділитися
Вставка
  • Опубліковано 2 жов 2016
  • 📝 Talk to Sanchit Sir: forms.gle/WCAFSzjWHsfH7nrh9
    💻 KnowledgeGate Website: www.knowledgegate.in/gate
    📲 KnowledgeGate Android App: tiny.cc/KG_Official_App
    ➡ Do not miss our Bestseller Courses:
    🔴 GATE Guidance-2025: www.knowledgegate.in/learn/GA...
    🟠 GATE Guidance Plus-2025: www.knowledgegate.in/learn/GA...
    ➡ Contact Us:
    🟩 Whatsapp Chat: wa.me/918595120657
    📞Call on: +91-8000121313
    🟦 Telegram Updates: t.me/kg_gate
    🟩 Whatsapp Updates: www.whatsapp.com/channel/0029...
    📧 Email: contact@knowledgegate.in
    ➡ Our One Shot Semester Exam Videos: 👇
    ▶ Operating System: • Complete Operating Sys...
    ▶ DBMS: • Complete DBMS Data Bas...
    ▶ Computer Network: • Complete CN Computer N...
    ▶ Digital Electronics: • Complete DE Digital El...
    ▶ Computer Architecture: • Complete COA Computer ...
    ▶ Data Structure: • Complete DS Data Struc...
    ▶ Algorithm: • Complete DAA Design an...
    ▶ Software Engineering: • Complete Software Engi...
    ▶ Theory of Computation: • Complete TOC Theory of...
    ▶ Compiler: • Complete CD Compiler D...
    ▶ Discrete Maths: • Complete DM Discrete M...
    ➡ Free Subject-Wise Complete PlayList: 👇
    ▶️ DBMS: tiny.cc/kg_yt_DBMS
    ▶️ Operating System: tiny.cc/kg_yt_OS
    ▶️ TOC|Automata: tiny.cc/kg_yt_toc
    ▶️ Computer Networks: tiny.cc/kg_yt_CN
    ▶️ Digital Electronics: tiny.cc/kg_yt_Digital
    ▶️ Compiler Design: tiny.cc/kg_yt_Compiler
    ▶️ Computer Architecture: tiny.cc/kg_yt_COA
    ▶️ Data Structure: tiny.cc/kg_yt_DataStructures
    ▶️ Algorithms: tiny.cc/kg_yt_Algorithm
    ▶️ Set, Relation, Function: tiny.cc/kg_yt_Discrete_Relations
    ▶️ Graph Theory: tiny.cc/kg_yt_graphtheory
    ▶️ Group Theory: tiny.cc/kg_yt_grouptheory
    ▶️ Proposition: tiny.cc/kg_yt_prepositions
    #knowledgegate #GATE #sanchitjain
    *********************************************************

КОМЕНТАРІ • 663

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  9 місяців тому

    For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.html

  • @thebitlearner4080
    @thebitlearner4080 6 років тому +633

    Skip to 2:10 ,if you have exams tomorrow.

  • @exclusiveshailen
    @exclusiveshailen 7 років тому +183

    "B yaha par neta ban raha", this dialogue is now famous in whole class 😂😂😂
    Very nice stuff sir, thanks 🙏

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому +26

      haha.......thanks buddy, and we are glad that we could be helpful. :)

    • @SachinSharma-br3hx
      @SachinSharma-br3hx 7 років тому +6

      it was epic.. 😀greatly explained stuff

  • @himanshuparmar1719
    @himanshuparmar1719 7 років тому +320

    Sir.... Even my IIT professors can't match your level of teaching. #Respect .../\....

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому +84

      Hello Himanshu, thanks for such a delightful comment and appreciation,
      we'll always give our best. :)

    • @johangabrielson2098
      @johangabrielson2098 6 років тому +22

      I totally agree. I had really hard understanding normalization and 1/2/3 nf. Now I grasp it. This guy should teach at some ivy league school

    • @networkmarketingandfun2712
      @networkmarketingandfun2712 5 років тому

      @@johangabrielson2098 yes same here, i thought i could never understand it q k poory semester m hi nhi smjh ai thi to b kese a skti but thank you so much sir

    • @vaibhavkansal834
      @vaibhavkansal834 4 роки тому +19

      bhai glt iit mai hai tu 😂

    • @viditsinghbrahmania1476
      @viditsinghbrahmania1476 3 роки тому +1

      Mann, it feels good to hear that. Didn't get a chance to be in IIT, at least I am able watch sir's videos.

  • @JjackFrost
    @JjackFrost 7 років тому +6

    Sir I cannot thank you enough. You just saved me. we really need more teachers like you cause that is exactly what we are missing.

  • @siri3359
    @siri3359 3 роки тому +4

    The excellence of teaching is clearly depicted when he repeats the important concept every time and at the end of the video it just gets into the head without making an effort to remember.Thank you sir.

  • @vamsithotlapalepu7395
    @vamsithotlapalepu7395 7 років тому +13

    Sir, I am from IIT Ropar, we need teachers like, I must honestly say this is one best lectures I have heard on entire youtube.... Really hats off... I must say I subscribed right away...

  • @vijaypandey5371
    @vijaypandey5371 7 років тому +1

    Thanks for your valuable concept....u know due to this video i got 10 pointer .....bcz i shown your video one day before my project substitution...and my role was on database activity......and my teacher asked cross question regarding functional dependency and 2 Normal Form....i just explain your as you have explain in this video....after explanation....my teacher smiled and very very very impressed with me...and finally i got 10 pointer...thanks sir....thanks a lot...:)

  • @ankishashrivastava1249
    @ankishashrivastava1249 7 років тому +28

    The best DBMS teacher is here. 👌🙏🙏 Thanks a lot, sir. U r clearing everyone's doubts. Keep up the great work.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому +5

      Hi Ankisha, Thank you so much for your encouraging and delightful words, it really means a lot to us :)
      We are happy that we could be helpful :)

    • @pratik4080
      @pratik4080 3 роки тому

      No Jenny lecture is best than this actually

  • @Nikita-xk9fc
    @Nikita-xk9fc 4 роки тому +1

    now it seems why the hell i even tried to understand normalization somewhere else .U r truely a legend sir.I wonder how the subscribers hv not crossed a million.I have been struggling to understand this partial dependency for so long.And now I will never forget the concepts.Thanks a lot

  • @JashRadia
    @JashRadia 6 років тому +1

    wow! i knew how to compute to 2NF but when u said why!!! now i know how good you are conceptually!

  • @hadijaffri9856
    @hadijaffri9856 6 років тому

    Sir u are a gifted teacher..ur skills transcend most of the teacher in many institutions
    These 10 minutes vs a 30 min lecture
    Hell of a difference ..
    Hats off to u sir..thankyou

  • @asifnawaz-lk7uu
    @asifnawaz-lk7uu 6 років тому +6

    Sir.... Even my IIT professors can't match your level of teaching
    you are my passionate teacher you are my best teacher GOD Bless you

  • @sushmitanigam4979
    @sushmitanigam4979 7 років тому

    sir I can never find a teacher who can teach like u. u are beyond words. it's my humble request to upload more videos in all cs subjects for gate plzzz plzzzzz

  • @jacquelinecahill4836
    @jacquelinecahill4836 7 років тому

    Thank you! This finally made it clear when you broke down what partial dependency was again.

  • @eimaldorani
    @eimaldorani 7 років тому +5

    Salute SIR!
    You summarize all concept of the 2NF in a single word: नेता

  • @tarangranpara5913
    @tarangranpara5913 6 років тому +2

    Whole DBMS subject was like really hard for me but now I'm lovin' it !
    thank you so much !

  • @rairai6202
    @rairai6202 7 років тому

    Really I'm trying to understand 2nd Normal form from long time...but no one make me understand.... And you do this in 10 min .... and now this explanation is unforgettable ... Guys like you make internet a valuable resource... Thanks you #Sir .. We #Respect you

  • @praveshshukla2232
    @praveshshukla2232 7 років тому +1

    Sir you are great.This is the first time i ever understood partial dependency.Today this morning i have watched all your dbms video , importatnt thing is without getting boared, in an eager to learn new concepts.And thanks for uploading the 3NF video now :-)

  • @monikagawde7020
    @monikagawde7020 6 років тому

    Simple n nice explanation sir...... I was stucked in this 2NF from last 4-5 hrs.... But after watching your video it has been in cleared in just 5 min... Thanks a lot sir

  • @sangamkedilaya4079
    @sangamkedilaya4079 5 років тому +2

    You are truly a LEGEND

  • @16princea
    @16princea 5 років тому

    Lots of respect Sir ...... I can feel my concepts becoming clearer ...... and I can imagine the situation quite clearly ...... Great work !

  • @sarimjalil6690
    @sarimjalil6690 7 років тому

    Sir you are great...you have given the best explanation available on Internet..
    your entire Series on FD and Normalization is Excellent.

  • @mahadevankrishnan8874
    @mahadevankrishnan8874 5 років тому

    It took So many years for me to Demistify the Normalization Concepts until I watched Your video.. Cheers Dude.. Keep up the good work..

  • @yashpandey6887
    @yashpandey6887 5 років тому +12

    here is my contribution to u sir..... I clicked on the ad.... (its small though, it is the only thing I can do frm. my side)
    and I also appeal my follow comrades to click on the ad and wait in the website for atleast 20 secs.
    he is helping us, we must help him in return.....
    tq so much sir....
    .... ❤❤❤

    • @varadthokal1406
      @varadthokal1406 4 роки тому

      mere bhai, ads dont work that way/.

    • @yogeshpandey1444
      @yogeshpandey1444 3 роки тому

      @google user I see you've got a pretty great sense of humour

  • @zubuv9189
    @zubuv9189 6 років тому +1

    You are my best teacher than my text book and my professors.Great help!Thanku Sir.

  • @anu86979
    @anu86979 2 місяці тому

    Best ever explanation in whole you tube 2nf's video

  • @poojapandey7085
    @poojapandey7085 6 років тому +1

    Thanku so much sir...
    Your way of teaching is awesome ❤ I want to become a professor...I hope I will explain like you..we Indians need more teachers like you..:)

  • @rahulchaubey8988
    @rahulchaubey8988 7 років тому +3

    You very great teacher sir. Your concept is crystall clear. Also you are down to earth that make me stick to your videos.

  • @shoonyaroach
    @shoonyaroach 7 років тому +1

    Such concise and compiled information of all the topics! You are a savior! :)

  • @ChoosingPeaceOverDrama
    @ChoosingPeaceOverDrama 6 років тому +1

    Excellent.It will help a lot for me in preparing for some applied jobs.Your videos are a precise and smart study material.graet sir.thanx a lot.

  • @anusuyar627
    @anusuyar627 7 років тому +1

    doing a great job sir .after 4 years I have finally learnt.thank you, sir.

  • @vinaybr750
    @vinaybr750 3 роки тому +1

    Sir, Great explanation from last 2 years I was struggling with this concepts and this video clears that in 10 min .

  • @BilalAhmed-vi3rd
    @BilalAhmed-vi3rd 6 років тому

    Your videos helped me for OS, now i'm here!
    I can't thank you enough

  • @shikhargupta7552
    @shikhargupta7552 2 роки тому +2

    Over the years I have watched this series 3-4 times to revise the concepts.
    Excellent stuff👌🏻👌🏻

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  2 роки тому +1

      Thanks a lot dear Shikhar, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

  • @ishankhobare22
    @ishankhobare22 5 років тому +2

    11:22 - Love the way you talk about the one of the prime attribute namely 'B': ''yaha pe neta ban raha hai'' :D This is like Munna bhai style waah waah.. Cheers

  • @anjurawat9274
    @anjurawat9274 5 років тому

    Your way to explaining is outstanding ,I can't stop me to do comment whenever I watch your videos...thanks a lot sir.

  • @snehilmaliwal4554
    @snehilmaliwal4554 7 років тому +1

    Sir, you are an awesome teacher. Thank you for contributing your time to help us. You teach extremely well. Thank you. #Respect

  • @sauravahikari8166
    @sauravahikari8166 4 роки тому

    Man hats off to your teaching skill. So simple and detailed.

  • @ashishjindal2677
    @ashishjindal2677 6 років тому +1

    I watched all the 10 video in a row, in a single sitting. They are amazing, thnx :)

  • @technicalmilan895
    @technicalmilan895 6 років тому +1

    sir ...............I fully understand it within 12:38 minute ........thank you !!
    keep on going.......
    support from Nepalese student.......

  • @jatindranathpattanaik2421
    @jatindranathpattanaik2421 7 років тому +6

    Sir, your OS lecture was excellent,
    sir I need the lecture of ADVANCE OS

  • @ishratfatima7816
    @ishratfatima7816 6 років тому

    Sir your teaching method sooooooooo perfect ..........brilliant..... I don't know why people dislikes vedios... I think you are perfect teacher....for students...

  • @sameekshamishra4702
    @sameekshamishra4702 6 років тому +2

    Great! keep posting and helping students worldwide! :)

  • @JAPjoshua
    @JAPjoshua 6 років тому +1

    Your lectures clear up every concept... Thank you

  • @spbe-qb3wp
    @spbe-qb3wp 4 роки тому

    Kamal Kar diya bhai ap ne, kya samjhaya hay, kya body language ahy, kya style hay, kya rhythm hay.

  • @hardikpoudel3011
    @hardikpoudel3011 4 роки тому

    this stuff what you are explaining here make it so simple that I topped the exam of the database. Extraordinary explanation.

  • @shashi_kamal_chakraborty
    @shashi_kamal_chakraborty 7 років тому +1

    Daroon!! Daroon explanation... Thanks Sir :) U made it so easy to follow

  • @aishwaryaray5341
    @aishwaryaray5341 5 років тому

    Your level of teaching is awesome. Thank you so much. #Respect.

  • @ManishSingh-kb9rt
    @ManishSingh-kb9rt 6 років тому

    every other video revolved in air without concepts but you started with concept and took it where to land..i.e our minds!

  • @sunainasunainasamuel662
    @sunainasunainasamuel662 4 роки тому

    Thanku so much sir GOD will give you good health and long life . Stay blessed

  • @ranitsinha6424
    @ranitsinha6424 6 років тому

    The best ever tutor on the net.. Thanks a lot. :)

  • @SandhyaVadhana
    @SandhyaVadhana 7 років тому

    Hats off to your teaching Sir! every topic is explained in the easiest way.

  • @rimpihatibaruahgogoi4424
    @rimpihatibaruahgogoi4424 5 років тому

    Omg
    .how can u explain so nicely...1st time Understood normalisation

  • @ravilodhi6343
    @ravilodhi6343 6 років тому +169

    Watching all the videos in 2x speed

  • @Scrapewithbots
    @Scrapewithbots 7 років тому +34

    i don't see a reason for 22 dislikes on such an awesome video... thanks sir

  • @goutamdas3505
    @goutamdas3505 7 років тому +2

    Nicely explained, Sir.Thank You

  • @gauravbhardwaj1053
    @gauravbhardwaj1053 7 років тому

    Hello sir,
    you have given the best teaching on 2 normal form.

  • @vishalpoudel6712
    @vishalpoudel6712 6 років тому

    i hope u get lot of money out of this channel and u get millions of subscribers soon brother, u teach minute details too within such a short period AMAZING!!

  • @gouravjain07
    @gouravjain07 7 років тому +1

    Sir, your way of teaching is good....the one thing I like the most that are, you use Hindi & English both that makes the thing very clear & understandable for those who are not good in English but want to learn.
    Best Wishes!!!!

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому

      Hello Gourav, Thank you so much for your encouraging words, we are glad we could help you. We upload more topics every week, Please subscribe this channel for best GATE tutorials.

  • @sportscity5487
    @sportscity5487 4 роки тому

    I have subcribed most famous channel of dbms series but ap ny to aik mint me concept clear kr dia.
    Kindly upload video on Adv Algo.
    Love from 🇵🇰🇵🇰🇵🇰🇵🇰

  • @siddhantkumar7257
    @siddhantkumar7257 7 років тому +1

    awesome sir seriously awesome.......................your are the best......i will pray for you. You will achieve what you want more in your life. thank you.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому

      Hi siddhant, Thank you so much for your encouraging and delightful words.We upload more topics every week, Please subscribe this channel for best GATE tutorials.

  • @sonukothari5581
    @sonukothari5581 7 років тому

    Thankyou sir bcoz of u I could clear my basic concept and also I m able to solve problems of normalization

  • @shortbetaexcellent5679
    @shortbetaexcellent5679 3 роки тому

    wow, sir. I'm thankful to you for clearing my confusion. your videos are very helpful for me.

  • @vasupatel6932
    @vasupatel6932 6 років тому

    Sir this method is perfect for me I have seen lot of videos and tutorials on you tube
    but from this video, i got everything in just 10 min and without any confusion
    thanks a lot
    And one question where have you been before???:):)

  • @talatdubloo8571
    @talatdubloo8571 7 років тому

    Was struggling with my uni exam, now it is all making sense! Thank you from Australia

  • @yuvashree7079
    @yuvashree7079 6 років тому

    👏👏👏👏👏tq so much sir first of all I have lot of confusion in dis bt now I am very cleared..eventhough i dont know hindhi ur English was very easily understandable tq soooooooooo much once again......☺

  • @omparkash6460
    @omparkash6460 6 років тому +1

    I loved your teaching sir,thank you soon much I was soo confused in normalization

  • @SaipraveenSeva
    @SaipraveenSeva 7 років тому +1

    Sir, people like you make this world a better place to live

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому +1

      Thank you so much Saipraveen for such a delightful comment . :)

  • @ashutoshranjan4644
    @ashutoshranjan4644 Рік тому +1

    In one shot I understood the concept. Amazing👏👏

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Рік тому

      Glad to know this❤Keep learning & supporting! Stay connected for more amazing videos & upcoming contents 👍😊You can also check out our CS bundle course for complete preparation of Computer Science subjects, sharing course link below:
      www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

  • @TheLeanProgrammer
    @TheLeanProgrammer 6 років тому +1

    Thanks a lot sir. Your videos helped a lot.

  • @Jyoti_Trivedi
    @Jyoti_Trivedi 3 роки тому +1

    Thank you so much sir... you makes us easily understand this with your great logics.....😇🙏👍

  • @akashjain4184
    @akashjain4184 7 років тому

    Sir,I never understood the reason before why we avoid partial dependancy,but now I hv understood completely..great work.. _ / \ _

  • @chetanarajole2978
    @chetanarajole2978 6 років тому +1

    Excellent......explanation loved it sir thanks alotttt!!!!!

  • @harshitrai6322
    @harshitrai6322 7 років тому

    Holy Mother... :D I tried to understand this concept for like 4-5 months and I reached nowhere...and now, I am awesome at finding 2NF....Thanks a lot... :)

  • @ImGamerGuy
    @ImGamerGuy 7 років тому +1

    thanks sir this video very help full to me :) totally impressed...

  • @salmananjum-thestoryteller1515
    @salmananjum-thestoryteller1515 6 років тому +1

    you can post subtitles to your videos so that those who're complaining about language can also take advantage of your awesome skills :)

  • @ravipratp76
    @ravipratp76 7 років тому

    Thank you so much sir. Your videos are very helpful in clearing all my basics which i could not understand during my b.tech :).
    Superb teaching.

  • @manishmaharjan3726
    @manishmaharjan3726 6 років тому +1

    Thank you so much. I have learnt so much from your help.

  • @sameerkumar3948
    @sameerkumar3948 6 років тому

    hats off you are really awsm best lecture ever i have gone through

  • @rajshreegavel5966
    @rajshreegavel5966 5 років тому +1

    thankyou so much sir! the topics which u discuss are really point to point and upto the mark. keep going!!!

  • @subhabratamukherjee6453
    @subhabratamukherjee6453 3 роки тому

    It's awesome, just awesome. Thanks a lot.

  • @parthh3963
    @parthh3963 3 роки тому

    Literally the best explanation, THANK YOU.

  • @raoshehroz3823
    @raoshehroz3823 5 років тому

    sir you are a wonderful teacher i could ever seen in my life

  • @varunvarun6022
    @varunvarun6022 7 років тому +1

    Sir...First of all HUGE thnksss For ur Hard work on making us understand DBMS with such a ease...........my TEacher, book are all penny like in front of ur teaching talent

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 років тому

      Hi Varun
      It is just a small contribution from our side. Although Thank you so much for appreciation and showing interest.
      Please subscribe the channel for more GATE tutorials.

  • @abhaynaik2832
    @abhaynaik2832 6 років тому

    Sir, i am very grateful to you..your teaching is very good...

  • @shafilshanu6172
    @shafilshanu6172 4 роки тому

    awesome sir. too good. cleared all my confusion

  • @gurtej5821
    @gurtej5821 7 років тому

    best videos on these topics. thank you a lot sir. And please keep on uploading other videos also. Its a humble request.

  • @vikask3655
    @vikask3655 6 років тому +1

    #respect you sir. Awsome level of. Teaching It used. In my BCA education

  • @susmitab1411
    @susmitab1411 7 років тому

    thank u sir for videos ...it has helped me a lot

  • @saisrikar7987
    @saisrikar7987 6 років тому +1

    Great explanation ..Thanks sir!

  • @ennimayah4142
    @ennimayah4142 5 років тому

    I'm from Africa but still understands very well even though you mixed it with your language. 👏👏👏👏👏👏

  • @a_72_saquibsheikh44
    @a_72_saquibsheikh44 2 роки тому +1

    The best explanation I ever got.
    Thank you so much Sir for such a wonderful explanation...

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  2 роки тому

      Most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowlegdegate.in for more amazing courses & contents 👍😊

  • @vaidehipatel7647
    @vaidehipatel7647 7 років тому +4

    thank you so much sir ! you explained everything very well!!! :)

  • @Educationadda6
    @Educationadda6 6 років тому

    Awesome....u r just awesome....
    Or b to yaha PE beta ban Raha hai.hahaha.. this type of teaching is just lovable

  • @TheShakthirvd
    @TheShakthirvd 7 років тому

    Thanks man! It's very useful.

  • @abdulbasituntoo1704
    @abdulbasituntoo1704 7 років тому

    Thanyou..
    You're amazing and sobber.
    Respect.

  • @ataurrahaman6576
    @ataurrahaman6576 4 роки тому

    Thank you sir for making things understand in proper manner

  • @ritviksinghal359
    @ritviksinghal359 5 років тому

    Your content was very helpful !!

  • @saurabhkarakoti8739
    @saurabhkarakoti8739 5 років тому

    Sir u are amazing i liked your way of teaching