4.5 Second Normal Form 2NF

Sdílet
Vložit
  • čas přidán 2. 10. 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
    *********************************************************

Komentáře • 663

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  Před 10 měsíci

    For complete DBMS, check out this video: czcams.com/video/YRnjGeQbsHQ/video.html

  • @exclusiveshailen
    @exclusiveshailen Před 7 lety +184

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

  • @thebitlearner4080
    @thebitlearner4080 Před 7 lety +635

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

  • @himanshuparmar1719
    @himanshuparmar1719 Před 7 lety +318

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

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Před 7 lety +83

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

    • @johangabrielson2098
      @johangabrielson2098 Před 6 lety +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 Před 5 lety

      @@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 Před 4 lety +19

      bhai glt iit mai hai tu 😂

    • @viditsinghbrahmania1476
      @viditsinghbrahmania1476 Před 3 lety +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 Před 7 lety +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 Před 3 lety +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.

  • @vijaypandey5371
    @vijaypandey5371 Před 7 lety +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...:)

  • @vamsithotlapalepu7395
    @vamsithotlapalepu7395 Před 7 lety +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...

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  Před 10 měsíci

    🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
    🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

  • @hadijaffri9856
    @hadijaffri9856 Před 6 lety

    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

  • @Nikita-xk9fc
    @Nikita-xk9fc Před 4 lety +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

  • @yashpandey6887
    @yashpandey6887 Před 5 lety +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....
    .... ❤❤❤

  • @16princea
    @16princea Před 5 lety

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

  • @monikagawde7020
    @monikagawde7020 Před 6 lety

    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

  • @JashRadia
    @JashRadia Před 6 lety +1

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

  • @technicalmilan895
    @technicalmilan895 Před 6 lety +1

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

  • @praveshshukla2232
    @praveshshukla2232 Před 7 lety +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 :-)

  • @asifnawaz-lk7uu
    @asifnawaz-lk7uu Před 6 lety +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 Před 7 lety

    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 Před 7 lety

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

  • @ChoosingPeaceOverDrama
    @ChoosingPeaceOverDrama Před 6 lety +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.

  • @rairai6202
    @rairai6202 Před 7 lety

    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

  • @ankishashrivastava1249
    @ankishashrivastava1249 Před 7 lety +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  Před 7 lety +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 Před 3 lety

      No Jenny lecture is best than this actually

  • @rahulchaubey8988
    @rahulchaubey8988 Před 7 lety +3

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

  • @spbe-qb3wp
    @spbe-qb3wp Před 4 lety

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

  • @sarimjalil6690
    @sarimjalil6690 Před 7 lety

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

  • @mahadevankrishnan8874
    @mahadevankrishnan8874 Před 5 lety

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

  • @poojapandey7085
    @poojapandey7085 Před 6 lety +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..:)

  • @zubuv9189
    @zubuv9189 Před 6 lety +1

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

  • @tarangranpara5913
    @tarangranpara5913 Před 6 lety +2

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

  • @vinaybr750
    @vinaybr750 Před 3 lety +1

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

  • @anu86979
    @anu86979 Před 3 měsíci

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

  • @shoonyaroach
    @shoonyaroach Před 7 lety +1

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

  • @anusuyar627
    @anusuyar627 Před 7 lety +1

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

  • @ishratfatima7816
    @ishratfatima7816 Před 6 lety

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

  • @ashishjindal2677
    @ashishjindal2677 Před 6 lety +1

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

  • @eimaldorani
    @eimaldorani Před 7 lety +5

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

  • @ishankhobare22
    @ishankhobare22 Před 5 lety +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 Před 5 lety

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

  • @shikhargupta7552
    @shikhargupta7552 Před 2 lety +2

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

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Před 2 lety +1

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

  • @snehilmaliwal4554
    @snehilmaliwal4554 Před 7 lety +1

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

  • @sangamkedilaya4079
    @sangamkedilaya4079 Před 5 lety +2

    You are truly a LEGEND

  • @BilalAhmed-vi3rd
    @BilalAhmed-vi3rd Před 6 lety

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

  • @ranitsinha6424
    @ranitsinha6424 Před 6 lety

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

  • @siddhantkumar7257
    @siddhantkumar7257 Před 7 lety +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  Před 7 lety

      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.

  • @vishalpoudel6712
    @vishalpoudel6712 Před 6 lety

    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!!

  • @shashi_kamal_chakraborty
    @shashi_kamal_chakraborty Před 7 lety +1

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

  • @vasupatel6932
    @vasupatel6932 Před 6 lety

    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???:):)

  • @sameekshamishra4702
    @sameekshamishra4702 Před 6 lety +2

    Great! keep posting and helping students worldwide! :)

  • @sunainasunainasamuel662

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

  • @jatindranathpattanaik2421

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

  • @gouravjain07
    @gouravjain07 Před 7 lety +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  Před 7 lety

      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.

  • @sauravahikari8166
    @sauravahikari8166 Před 4 lety

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

  • @ManishSingh-kb9rt
    @ManishSingh-kb9rt Před 6 lety

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

  • @rahulchaubey8988
    @rahulchaubey8988 Před 7 lety +1

    Jio super.... jabarjast.. sandar..

  • @hardikpoudel3011
    @hardikpoudel3011 Před 4 lety

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

  • @SandhyaVadhana
    @SandhyaVadhana Před 7 lety

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

  • @aishwaryaray5341
    @aishwaryaray5341 Před 5 lety

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

  • @rimpihatibaruahgogoi4424

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

  • @JAPjoshua
    @JAPjoshua Před 6 lety +1

    Your lectures clear up every concept... Thank you

  • @sameerkumar3948
    @sameerkumar3948 Před 7 lety

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

  • @yuvashree7079
    @yuvashree7079 Před 6 lety

    👏👏👏👏👏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......☺

  • @rajshreegavel5966
    @rajshreegavel5966 Před 5 lety +1

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

  • @sportscity5487
    @sportscity5487 Před 4 lety

    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 🇵🇰🇵🇰🇵🇰🇵🇰

  • @navrajsingh2300
    @navrajsingh2300 Před rokem +1

    Wow sir thankew so much muje smjh nhi AA RHA aapka thanks kaise karu Maine CZcams pr almost saari videos dekh li thi normalization pr apki best hai

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Před rokem

      Thanks a lot for your valuable feedback & kind words❤ Keep supporting & stay connected for more amazing contents👍😊
      You can also check out our course for all Computer Science subjects, sharing the link below:
      www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

  • @shortbetaexcellent5679

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

  • @omparkash6460
    @omparkash6460 Před 6 lety +1

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

  • @chetanarajole2978
    @chetanarajole2978 Před 6 lety +1

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

  • @sonukothari5581
    @sonukothari5581 Před 7 lety

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

  • @ImGamerGuy
    @ImGamerGuy Před 7 lety +1

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

  • @raoshehroz3823
    @raoshehroz3823 Před 5 lety

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

  • @Scrapewithbots
    @Scrapewithbots Před 7 lety +34

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

  • @gurtej5821
    @gurtej5821 Před 7 lety

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

  • @subhabratamukherjee6453

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

  • @talatdubloo8571
    @talatdubloo8571 Před 7 lety

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

  • @ravipratp76
    @ravipratp76 Před 7 lety

    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.

  • @susmitab1411
    @susmitab1411 Před 7 lety

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

  • @gauravbhardwaj1053
    @gauravbhardwaj1053 Před 7 lety

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

  • @Shubhipc
    @Shubhipc Před 6 lety

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

  • @Tourtheindia321
    @Tourtheindia321 Před rokem +1

    Thanku bhaiya aapke vedios bohot zyada helpful h.Thanku so much.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Před rokem

      Thanks a lot dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

  • @tintin-qu4gs
    @tintin-qu4gs Před 6 lety

    Wah Kya explain kiya hai apne.👌👍🤘

  • @crazeeealgorithms3236
    @crazeeealgorithms3236 Před 7 lety

    super explanation sir, hats off to your work which helps students like me, could you please upload the tutorials for transaction and concurrency control

  • @manishmaharjan3726
    @manishmaharjan3726 Před 6 lety +1

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

  • @goutamdas3505
    @goutamdas3505 Před 7 lety +2

    Nicely explained, Sir.Thank You

  • @akashjain4184
    @akashjain4184 Před 7 lety

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

  • @Jyoti_Trivedi
    @Jyoti_Trivedi Před 3 lety +1

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

  • @varunvarun6022
    @varunvarun6022 Před 7 lety +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  Před 7 lety

      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.

  • @raghavbansal3871
    @raghavbansal3871 Před 5 lety

    kamaal kar diya yaar ......

  • @TheLeanProgrammer
    @TheLeanProgrammer Před 6 lety +1

    Thanks a lot sir. Your videos helped a lot.

  • @shafilshanu6172
    @shafilshanu6172 Před 4 lety

    awesome sir. too good. cleared all my confusion

  • @vikask3655
    @vikask3655 Před 6 lety +1

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

  • @danishmunir9721
    @danishmunir9721 Před 6 lety

    Thnx for upload this video..it's really helpfulllll... and your way of teaching is very well... Give it up... Allah bless u sir :)

  • @devashish887
    @devashish887 Před 5 lety

    really appreciable.!

  • @parnikatyagi503
    @parnikatyagi503 Před 6 lety

    Hats off to you sir!

  • @saisrikar7987
    @saisrikar7987 Před 6 lety +1

    Great explanation ..Thanks sir!

  • @muzharhusain8691
    @muzharhusain8691 Před 4 lety

    Thank you sir ap k lecture buhat helpfull hota hain👍

  • @VivekYadav-hn5ow
    @VivekYadav-hn5ow Před 5 lety

    very well explained... superb

  • @PrashantSharma-fj1sx
    @PrashantSharma-fj1sx Před 6 lety +1

    Hahah Sir first tym i am able to understand dbms . Thank you so much sir! :)

  • @vedantsharma9206
    @vedantsharma9206 Před 7 lety +2

    Sir...Very..Very..Very Nicely Explained..... :)

  • @salmananjum-thestoryteller1515

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