Lec-10: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi

Поделиться
HTML-код
  • Опубликовано: 7 фев 2025
  • 👉Subscribe to our new channel: / @varunainashots
    ►Foreign Key part-2: • Lec-11: Insert, Update...
    ► Database Management System(Complete Playlist):
    • DBMS (Database Managem...
    Other subject-wise playlist Links:
    --------------------------------------------------------------------------------------------------------------------------------------
    ►Design and Analysis of algorithms (DAA):
    • Design and Analysis of...
    ►Computer Architecture (Complete Playlist):
    • Computer Organization ...
    ► Theory of Computation
    • TOC(Theory of Computat...
    ►Artificial Intelligence:
    • Artificial Intelligenc...
    ►Computer Networks (Complete Playlist):
    • Computer Networks (Com...
    ►Operating System:
    • Operating System (Comp...
    ►Structured Query Language (SQL):
    • Structured Query Langu...
    ►Discrete Mathematics:
    • Discrete Mathematics
    ►Compiler Design:
    • Compiler Design (Compl...
    ►Number System:
    • Number system
    ►Cloud Computing & BIG Data:
    • Cloud Computing (Compl...
    ►Software Engineering:
    • Software Engineering
    ►Data Structure:
    • Data Structure
    ►Graph Theory:
    • Graph Theory
    ►Programming in C:
    • C Programming
    ►Digital Logic:
    • Digital Logic (Complet...
    ---------------------------------------------------------------------------------------------------------------------------------------
    Our social media Links:
    ► Subscribe to us on RUclips: / gatesmashers
    ►Subscribe to our new channel: / @varunainashots
    ► Like our page on Facebook: / gatesmashers
    ► Follow us on Instagram: / gate.smashers
    ► Follow us on Instagram: / varunainashots
    ► Follow us on Telegram: t.me/gatesmash...
    ► Follow us on Threads: www.threads.ne...
    --------------------------------------------------------------------------------------------------------------------------------------
    ►For Any Query, Suggestion or notes contribution:
    Email us at: gatesmashers2018@gmail.com
    #foreignKey#Constraints#ReferentialIntegrity#DBMS#GATE#ugcNet

Комментарии • 689

  • @riyapandey3511
    @riyapandey3511 2 года назад +102

    Sir ... I am learning whole DBMS from this playlist. Thank you ☺️☺️

  • @fashionzone.
    @fashionzone. 5 лет назад +62

    I am Oracle developer once I saw ur video accedentily litterly Sir I am fan of your teaching style which is very unique and very much better than college professor I love it .

    • @persevere0605
      @persevere0605 5 лет назад +3

      @HYBRID SOL when two or more attributes are used to uniquely identify tuples in a table that will be a compound pk

    • @namitsharma3449
      @namitsharma3449 4 года назад +1

      Thanks a lot sir g

    • @akasharora2386
      @akasharora2386 4 года назад

      @HYBRID SOL i think when we join 2 primary keys to make a single primary key that should be a compund primary key..but i am not sure...i think it should be like this.

    • @rameshmalhotra9525
      @rameshmalhotra9525 3 года назад

      ruclips.net/video/p0gL1pAhGZE/видео.html

  • @prasangsinghal262
    @prasangsinghal262 6 лет назад +35

    I rarely subscribe to a channel...but your explanation forced me to do so...keep up the good work...

  • @saint_lunatic
    @saint_lunatic 4 года назад +175

    I am watching all 102 of your videos, I conclude, you are a GOD! sorry for spamming all your videos.

  • @well_join_the_club
    @well_join_the_club 2 года назад +43

    ur sweat .....makes our exam sweet for us...........thanking you from bottom of my heart.....not just words.....believe me even now a dummy account is what i am using just bcoz to boost ur subscriber as possible from my side......thank you sir

    • @mayuresh_07
      @mayuresh_07 2 года назад +3

      bhai tu shayar banja

    • @shivamya9579
      @shivamya9579 2 года назад +2

      @@mayuresh_07 😂😂😂

    • @arzoorai2509
      @arzoorai2509 2 месяца назад

      creepiest way of saying bhai tf

  • @twist3dgUt4219
    @twist3dgUt4219 3 года назад +85

    As an ece student, his and knowledge gate's videos has prepared me way better for technical interview rounds better than any college faculty ever could. Thank you sir!

  • @Official-tk3nc
    @Official-tk3nc 4 года назад +246

    If you are watching in lockdown believe me you are one of the rare species who is ready to sacrifice everything to achieve their goals : all the best

  • @JaiPrakash-jl2gy
    @JaiPrakash-jl2gy 2 года назад +14

    The man is burning his sweat just to clear a concept of ours 😊🙏

  • @ItsJyoti
    @ItsJyoti 4 года назад +143

    Big salute to your dedication Sir...I can see sweat while preparing lectures,how much efforts u put to make concepts simple n east.You are just Amazing Sir....Hats off to you Sir ❤️

  •  3 года назад +132

    College : Give us fees and taught us very poorly
    Gate smashers: Take it for free and taught us perfectly 💯💯

  • @YADAVANKITMAHESHKUMAR
    @YADAVANKITMAHESHKUMAR 2 года назад +8

    I would say that sir, you teach better than my college teacher.
    Thank you for such efforts.

  • @AnirbanDatta-r6i
    @AnirbanDatta-r6i Год назад +8

    Hi Varun, You are amazing in explaining about RDMS concepts. All my doubts are clarified after watching your videos. Please keep up the good work going.

  • @nabilarehman6201
    @nabilarehman6201 2 года назад +16

    Thank you dear
    Not only students but teachers also use your channel for clarity.. Thank you again ❤

  • @emanimtiaz7528
    @emanimtiaz7528 3 года назад +8

    Best teacher ever!! Love from Pakistan...🇵🇰

    • @adityavats2298
      @adityavats2298 3 года назад +1

      Atif aslam was the foreign key for India and Pakistan

  • @Sheebakhanam-y4e
    @Sheebakhanam-y4e Год назад +1

    Honestly you are just an amazing teacher, explaining each and everything far better than my teacher. thanks for making these videos

  • @studentsheaven-d8v
    @studentsheaven-d8v 4 года назад +131

    LOVE AND RESPECT FROM PAKISTAN DEAR SIR.

    • @thrones2.032
      @thrones2.032 3 года назад +2

      me to

    • @akashnaveen7475
      @akashnaveen7475 3 года назад +3

      @@mrmagnanimous3775 😂😂

    • @DEVILKING-ss5cp
      @DEVILKING-ss5cp 2 года назад +2

      @@mrmagnanimous3775 😂😂😂😂

    • @rahanajai6467
      @rahanajai6467 2 года назад +9

      @@mrmagnanimous3775 Don't make fun of it bro what you said is not funny 🙁

    • @TheVivekexpress
      @TheVivekexpress 2 года назад +9

      Are bhai pakista bhi apne Bharat ka hi beta h

  • @suryadakua5886
    @suryadakua5886 6 лет назад +5

    Sir apka padhai bahut acha lagta hai ,samjhnese bahut easy hai

  • @swayamsiddharath2224
    @swayamsiddharath2224 4 года назад +55

    Amazing Content ..Hats off to you Sir ❤️

  • @pradipshendage2212
    @pradipshendage2212 5 лет назад +2

    After watching your first video lect. nobody can't forget to subscribe ur channel bz ur quality shows everything..love u sirji..👌👌👌

  • @vartikasinghania9723
    @vartikasinghania9723 4 года назад +6

    This is the best explanation. The content is really amazing :D
    Thank you so much Sir

  • @siddharthchakraborty9134
    @siddharthchakraborty9134 5 лет назад +8

    amazing explanation, cleared all of my doubts

  • @time1702
    @time1702 7 месяцев назад +1

    with the revision, Subject gets stronger.
    Learning helps always... early learning has always an edge.

  • @yatishmalik
    @yatishmalik 5 лет назад +3

    Sir, bht acha samjhate ho aap..pls keep posting more videos on advanced DBMS topics like - Bridge Tables, types of dimension tables, surrogate keys etc.

  • @shoaibpatwe7999
    @shoaibpatwe7999 День назад

    Sir Thankyou so much I m learning whole DBMS from your playlist

  • @mahalakshmim2756
    @mahalakshmim2756 3 года назад +4

    My complete gate preparation is being guided by you sir. And I know many whom you're guiding without knowing. Every playlist of yours is very detailed and helpful.
    I finished OS playlist of yours, it was very very helpful for me to solve practise qs, now I am here for dbms and every concept is very clear. Thank you so much sir, you are helping us a lot. Than you sir.

  • @sangeetasingh7286
    @sangeetasingh7286 3 года назад +2

    Just mind blowing. I never understood SQL queries better than these days after following your videos sir. God bless you and super easy and amazing explanation.

  • @mr--999
    @mr--999 4 года назад +1

    Sir I am watching you all videos Mana paper ka 1din phele apki video dhekhe aur agla din Mara paper forgien keys Aya kasa banata ha ya Aya aur Kal apki video dhekhe the Mana apki video ko samaja fir jab Mara result Aya to forgen Wala ma Mara pura mask Aya 10/10 thank you sir apka jasa sir milta kaha ha

  • @ChayonShaahOfficial
    @ChayonShaahOfficial 3 года назад +1

    You are greatest Teacher , I saw ever . Best of luck man :)

  • @jaggibawa8390
    @jaggibawa8390 4 года назад +2

    Your teaching method is too Good , sir

  • @ace.tech_10
    @ace.tech_10 4 года назад +4

    thankyou sir for all these videos and salute to u you are literally putting so much efforts for all of us... THANKYOU❤❤❤❤

  • @peralacharanraj7699
    @peralacharanraj7699 2 года назад +1

    After 4 years of this video you actually crossed the 1M followers sir
    Congratulations 🎉

  • @tithiagarwal8264
    @tithiagarwal8264 3 месяца назад

    Hats off to you sir!!🫡We couldn't have a better teacher!!

  • @Smartybaby23
    @Smartybaby23 5 лет назад +2

    Continuously watching ur vdos for my Ibps rrb po mains preparation... Really helpful... Tqqq brother...!!

    • @GateSmashers
      @GateSmashers  5 лет назад +1

      Thank you Renu ji..when is your exam?

    • @Smartybaby23
      @Smartybaby23 5 лет назад

      @@GateSmashers 13 October

  • @sabaakhtar1159
    @sabaakhtar1159 6 лет назад +13

    awsome sir....ur way of explanation is so simple and easy......very well .sir......good work...

  • @raonitish1597
    @raonitish1597 5 лет назад +2

    Wah bhai. Concept clear ho gaya😊😊. Thank you

  • @anshulbansal8828
    @anshulbansal8828 5 лет назад +5

    sir when u says the word "barabbar" it feels like next level,,, love your videos sir,,,great explanation,,,

  • @meenakshigarg340
    @meenakshigarg340 4 года назад +2

    Thanq so much sir.. U have cleared my doubts.. Keep it up

  • @roshanmhatre8810
    @roshanmhatre8810 4 года назад +3

    Best quality content for learning DBMS♥

  • @DevDiscover
    @DevDiscover 4 года назад +1

    Great Sir you are doing good and teach us in a better way..Thanks 😇

  • @niloybarua6414
    @niloybarua6414 Год назад +2

    Best of the best thanks sir for your hard efforts

  • @gsk5328
    @gsk5328 3 года назад +1

    Your course is the awesome, mind blowing ,🔥🔥🔥💯💯💯👌👌👌

  • @danishsheikh6038
    @danishsheikh6038 5 лет назад +2

    My keys concepts have been clear now.Thanks for explaining in details.

  • @huzaifamumtaz5157
    @huzaifamumtaz5157 Год назад +1

    your teaching skill is very good keep it up😊

  • @pooja_998
    @pooja_998 6 лет назад +1

    Sir bht acha smjhate ho ap....dimag me set hojata hai

  • @priyanshusharma-it9rh
    @priyanshusharma-it9rh 2 года назад +2

    Sir very nice.
    Good explanation
    There is no words to explain your video❤️

  • @ehtishamkhan421
    @ehtishamkhan421 3 года назад +6

    There can be more than primary keys in a table but we consider that to be one key. Sometimes we need two primary combines into one for uniqueness

  • @shivamchansoriya4460
    @shivamchansoriya4460 2 года назад +11

    Thank you so much sir..... You're exam saviour. My whole class is just Appreciating your teaching skills.🔥🔥🔥

  • @bintefarooqbintefarooq7755
    @bintefarooqbintefarooq7755 Год назад +1

    Thanks alot sir for giving us amazing lectures 💕God bless Yuu.. we rr heartily thankful to Yuu.. ❤

  • @adityabansal3615
    @adityabansal3615 4 года назад +11

    The most important feature of your lectures is accurate content, good explanation 👍👍

  • @vikas0398
    @vikas0398 4 года назад +1

    Thank you sir for such a simple explanation with deep digging of every topics.

  • @duddleworld
    @duddleworld 2 месяца назад +1

    SIR IAM LEARNING DBMS FOR MY Galgotias University EXAMS FROM YOUR PLAYLIST THANKYOU FOR SIR

  • @akstyl723
    @akstyl723 2 года назад +1

    Your videos are very helpful. Thank you sir

  • @Shruti811_p
    @Shruti811_p Год назад +2

    Tomorrow is my exam of DBMS and you save me sir thank you 😊

    • @Shraddha1980
      @Shraddha1980 Год назад +1

      Vikram University ki hai kya behn

  • @lochansharma956
    @lochansharma956 3 года назад

    Sir excellent explanation I liked your videos most and I liked only your videos of os and DBMS and your teaching skills are super ❤️👍👌

  • @ankitatripathi9743
    @ankitatripathi9743 5 лет назад +2

    The way you teaching is good and the best part ,i never watch in hindi ,first time i m watching and understanding very easily as very difficult in hindi to get ..Thanks

    • @georgeschlumberger9814
      @georgeschlumberger9814 5 лет назад +1

      can you please change your profile/channel picture? i almost shit myself seeing that scary ass face. thanks in advance.

  • @Hitesh_Patil079
    @Hitesh_Patil079 3 года назад

    thank u so much...you teach in very easy way.. it helps to a lot of students..

  • @PR_Pavan
    @PR_Pavan 10 месяцев назад +1

    Nice explanation ❤..

  • @asashortspakistan
    @asashortspakistan 5 лет назад +1

    zabardast g. Aaasaan ker diya bilkul. thank you sir.

    • @anilamurtha2034
      @anilamurtha2034 4 года назад

      ruclips.net/video/rRmI16IkqG0/видео.html

  • @PreetiPokale-bs2vy
    @PreetiPokale-bs2vy 11 месяцев назад

    This is one of the best lectures on RUclips of dbms
    My college teacher is such a boring

  • @Aamna2408
    @Aamna2408 2 месяца назад

    Thank so , you explained it very nicely , I was confused before

  • @Kp-pn1pz
    @Kp-pn1pz 3 года назад

    Just wanted to say thank uhh sir ...your explaination is just straight and easy!!

  • @abrardesai8326
    @abrardesai8326 3 месяца назад

    Sir, yr teaching style is 😊outstanding, 👍 I love you sir 💙, keep it up....✨

  • @rizwanali-is8nd
    @rizwanali-is8nd 3 года назад

    Thanks, Sir Your teaching method is so good and I understand it easily and frequently
    Big Salute to you.

  • @Akshay_tarle
    @Akshay_tarle 3 года назад +1

    Thanks sir! DBMS looking easy now

  • @sachinkarn3057
    @sachinkarn3057 5 лет назад +1

    Thank you sir you are good teacher and best of luck

  • @poojatiwari6290
    @poojatiwari6290 4 года назад +17

    Thank you so much for all your efforts.Ur way of explaining is too good and simple which helps to understand hard topic in easy way . Your sweat ,while preparing lecture for us is just heart touching. #ThankYouAgain.🌺🌺🙏❣️😇

  • @vandananegi8967
    @vandananegi8967 4 года назад +1

    Thank you so much for your effort sir..Your way of explaining a topic is too good and simple🙏🙏🙏😇😇😇

  • @jaffrizahra3796
    @jaffrizahra3796 2 года назад

    Your style of explaining is wonderful

  • @nouzainahassan5623
    @nouzainahassan5623 3 года назад +3

    I am pakistani
    And watching your lectures
    Amazing content 😇

  • @Raj_Panchalll
    @Raj_Panchalll Год назад +1

    Thanks Sir for your efforts that you are taking for all of us...

  • @mitedu5523
    @mitedu5523 3 года назад

    Amazing!!!
    New subscriber From Pakistan .. thank you so muchhhh sir

  • @NaziaBashir-y8y
    @NaziaBashir-y8y Месяц назад

    You are the best sir 💞 I never seen before 💞

  • @dsstudy2111
    @dsstudy2111 4 года назад

    Sir apne toh is topic me bhi maze dila diye... Aweaome sir...❤️❤️❤️❤️👍👍👍👍

  • @shrishtikushwah7915
    @shrishtikushwah7915 3 года назад

    Sir aapko request krne ki jarurat nhi h subscribe krne ke liye.....coz you deserve subscribers cz of your teaching ability 🙌🙌❤️

  • @pratipsarkar8921
    @pratipsarkar8921 6 лет назад +1

    Waaah... kya baat... Samajh gaya... Thank you so much!

    • @anilamurtha2034
      @anilamurtha2034 4 года назад

      ruclips.net/video/rRmI16IkqG0/видео.html

  • @billypentester
    @billypentester 4 года назад +1

    thanks sir! videos are really amazing. I'm learning whole DBMS from this playlist. It's convenient because language is probably urdu or hindi

    • @anilamurtha2034
      @anilamurtha2034 4 года назад

      ruclips.net/video/rRmI16IkqG0/видео.html

    • @yogesh41048
      @yogesh41048 3 года назад

      Actually its hinglish(Hindi + english) or you can call urdu+english

    • @rameshmalhotra9525
      @rameshmalhotra9525 3 года назад

      ruclips.net/video/p0gL1pAhGZE/видео.html

  • @nikhilguleria4313
    @nikhilguleria4313 Год назад

    Sweat is releasing from your body but still you are teaching. Thanks a lot♥

  • @peppermintdior
    @peppermintdior 3 года назад

    Always cleans and concise information, thank you sir

  • @6goyal
    @6goyal 6 лет назад +1

    Great Explanation !Thanks For videos

  • @SagarKumar-gh2kp
    @SagarKumar-gh2kp Месяц назад

    Thank you so much sir ❤❤❤
    For well explained

  • @jaygajera1235
    @jaygajera1235 5 лет назад +1

    Very nice explain in dbms syllabus

  • @AI_VideosGen
    @AI_VideosGen 3 года назад

    Thank you sir apki vajase mera interest DBMS me boht bad gaya hai

  • @innovateankit3897
    @innovateankit3897 4 месяца назад

    just amazing...explained nicely..

  • @devByDash
    @devByDash 2 года назад +1

    Thank you so much sir ... If I get good marks it will be your sweat and blood.

  • @hafizimran3737
    @hafizimran3737 6 лет назад

    I m from Pakistan... Sir apka prhany ka method bht hi axa h...

  • @khurramkhan6595
    @khurramkhan6595 3 года назад

    Nice way of teaching, love from Pakistan.....

  • @soniyajinu6578
    @soniyajinu6578 4 года назад

    It is so easy to understand the concepts through ur videos sir....love from kerala

    • @anilamurtha2034
      @anilamurtha2034 4 года назад

      ruclips.net/video/rRmI16IkqG0/видео.html

  • @manyagupta8490
    @manyagupta8490 3 года назад +1

    Thankyou so much sir ,u made learning this very much simpler and easy to understand💯

  • @amanbhargavaofficial
    @amanbhargavaofficial 3 года назад

    Sir very nice explanation thanks, many time interviewer ask this question.

  • @saifulislamsuvo1360
    @saifulislamsuvo1360 5 лет назад +1

    Thanks for teaching quality

  • @shivanivishwakarma9079
    @shivanivishwakarma9079 5 лет назад +1

    Such a.. great lecture...it's very helpful 4 me😊😊

    • @anilamurtha2034
      @anilamurtha2034 4 года назад +1

      ruclips.net/video/rRmI16IkqG0/видео.html

  • @anishchar4282
    @anishchar4282 2 года назад +1

    Thanks sir for your continuous support 🙏🏻

  • @AK-us1by
    @AK-us1by 3 года назад

    App her video kay baad thank you bolte ho magar thanks karna to hamara banta hai. Thanks for such a nice tutorial.

  • @shrutimishra8957
    @shrutimishra8957 3 года назад +1

    Thank uhhhhh so much sir ❤️ means alot ❤️this videos are really very useful ❤️i can't even explain how much I've respect for you.... thank uhhhhh so much for your help sir 🙏🎀

  • @Vega004
    @Vega004 3 года назад

    Sir you are sweating and looking tired still you are teaching just for us 🙏🙏🙏

  • @devpatel20
    @devpatel20 4 года назад

    Thank You Very Much. You Have made learning for us very easy

  • @losergamer9387
    @losergamer9387 Год назад

    sir i'm from pakistan your teaching method is great
    Thank u sir❤

  • @faisaljamil4932
    @faisaljamil4932 3 года назад

    I HAVE NEVER SEEN A TEACHER LIKE YOU.

  • @mugheesulislam8470
    @mugheesulislam8470 6 лет назад +2

    I think if you don’t say to subscribe then everyone will subscribe your channel due to your well explanation. Bundle of thanks for making these videos. I covered Operating System and networking through this channel.
    Again Thanks.
    From Pakistan 🇵🇰

  • @diksha5665
    @diksha5665 3 года назад +8

    This foreign key reminds me of inheritance. Just like base class and child class are in the programming languages 😁.