Lec-10: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- 👉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 & BIG ...
►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 TH-cam: / 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
Sir ... I am learning whole DBMS from this playlist. Thank you ☺️☺️
hlo❣️◼️
I am watching all 102 of your videos, I conclude, you are a GOD! sorry for spamming all your videos.
What a teacher 🙇♂️
I rarely subscribe to a channel...but your explanation forced me to do so...keep up the good work...
nawab hai kahika kya?
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
@@HARSHITKUMAR-wj4ex it's her choice 😂😂😂
@@YashSalunkeCR7 XD ; )
@@HARSHITKUMAR-wj4ex you got no chill..😂😂
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
bhai tu shayar banja
@@mayuresh_07 😂😂😂
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!
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 .
@HYBRID SOL when two or more attributes are used to uniquely identify tuples in a table that will be a compound pk
Thanks a lot sir g
@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.
th-cam.com/video/p0gL1pAhGZE/w-d-xo.html
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
😭😭😭tysm needed that piece of motivation 😀😀😀
Thankyouuu
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Got exams bruh I'm binging last minute ;-;
th-cam.com/video/p0gL1pAhGZE/w-d-xo.html
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 ❤️
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Dedication hai sir ka 💯♥️
The man is burning his sweat just to clear a concept of ours 😊🙏
LOVE AND RESPECT FROM PAKISTAN DEAR SIR.
me to
@@mrmagnanimous3775 😂😂
@@mrmagnanimous3775 😂😂😂😂
@@mrmagnanimous3775 Don't make fun of it bro what you said is not funny 🙁
Are bhai pakista bhi apne Bharat ka hi beta h
Thank you dear
Not only students but teachers also use your channel for clarity.. Thank you again ❤
I would say that sir, you teach better than my college teacher.
Thank you for such efforts.
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.
Please show some respect to him. You should call him sir.
Please don't request for your channel to get subscribed ... jo nahi kar rahe unka hee loss hai ... ab koi khud apna loss karna chahata hai to .. ham log kya kare 😂😂
😂😂
Amazing Content ..Hats off to you Sir ❤️
Best teacher ever!! Love from Pakistan...🇵🇰
Atif aslam was the foreign key for India and Pakistan
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.
how much in gate
awsome sir....ur way of explanation is so simple and easy......very well .sir......good work...
Exactly 👍
with the revision, Subject gets stronger.
Learning helps always... early learning has always an edge.
sir when u says the word "barabbar" it feels like next level,,, love your videos sir,,,great explanation,,,
Sir apka padhai bahut acha lagta hai ,samjhnese bahut easy hai
amazing explanation, cleared all of my doubts
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
Nice explanation ❤..
Thank you so much sir..... You're exam saviour. My whole class is just Appreciating your teaching skills.🔥🔥🔥
❤
Honestly you are just an amazing teacher, explaining each and everything far better than my teacher. thanks for making these videos
Idk about others , but as a student of class 10 , I found this video very helpful ... Thank you sir
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.
Tomorrow is my exam of DBMS and you save me sir thank you 😊
Vikram University ki hai kya behn
This is the best explanation. The content is really amazing :D
Thank you so much Sir
You are most welcome
Your course is the awesome, mind blowing ,🔥🔥🔥💯💯💯👌👌👌
After watching your first video lect. nobody can't forget to subscribe ur channel bz ur quality shows everything..love u sirji..👌👌👌
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.
thankyou sir for all these videos and salute to u you are literally putting so much efforts for all of us... THANKYOU❤❤❤❤
❤️
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.🌺🌺🙏❣️😇
So nice of you
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
More attributes into one key
Best of the best thanks sir for your hard efforts
You are greatest Teacher , I saw ever . Best of luck man :)
Thanq so much sir.. U have cleared my doubts.. Keep it up
Continuously watching ur vdos for my Ibps rrb po mains preparation... Really helpful... Tqqq brother...!!
Thank you Renu ji..when is your exam?
@@GateSmashers 13 October
The most important feature of your lectures is accurate content, good explanation 👍👍
Your teaching method is too Good , sir
your teaching skill is very good keep it up😊
Great Sir you are doing good and teach us in a better way..Thanks 😇
After 4 years of this video you actually crossed the 1M followers sir
Congratulations 🎉
Best quality content for learning DBMS♥
This foreign key reminds me of inheritance. Just like base class and child class are in the programming languages 😁.
Wah bhai. Concept clear ho gaya😊😊. Thank you
My keys concepts have been clear now.Thanks for explaining in details.
Thanks sir for making a very clear and detailed tutorial.
Thank you so much sir ... If I get good marks it will be your sweat and blood.
Thanks alot sir for giving us amazing lectures 💕God bless Yuu.. we rr heartily thankful to Yuu.. ❤
Sir very nice.
Good explanation
There is no words to explain your video❤️
Your videos are very helpful. Thank you sir
just amazing...explained nicely..
zabardast g. Aaasaan ker diya bilkul. thank you sir.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Thank you sir you are good teacher and best of luck
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
can you please change your profile/channel picture? i almost shit myself seeing that scary ass face. thanks in advance.
Sir bht acha smjhate ho ap....dimag me set hojata hai
thank u so much...you teach in very easy way.. it helps to a lot of students..
Thanks for teaching quality
Sir excellent explanation I liked your videos most and I liked only your videos of os and DBMS and your teaching skills are super ❤️👍👌
I am pakistani
And watching your lectures
Amazing content 😇
Pura India hi amazing hai
@@mrmagnanimous3775 luv u jani
Nice way of teaching, love from Pakistan.....
Thanks sir! DBMS looking easy now
Thank you sir for such a simple explanation with deep digging of every topics.
Amazing!!!
New subscriber From Pakistan .. thank you so muchhhh sir
Sir ..upload more videos of CN ...(atleast weekend par CN ka video upload kar diya karo sir..)..
Thanks in advance..ur videos are very very good..
Thank you for your suggestion . will try my best...
as usual ur teaching is good i would have subscribed ur channel.....from at least 10 -15 accounts......ur subscribers count kind a saturated.........(not in a negative way)i have done my best to increase ur subscriber's count.....but that won't make huge difference but yep..........i did my best.....also thank you sir for ur teaching
Thank you sir apki vajase mera interest DBMS me boht bad gaya hai
Thanks Sir for your efforts that you are taking for all of us...
00:01 Foreign key in database
01:08 Primary key always references another table
02:14 The primary key helps in uniquely identifying entries in a student table.
03:20 The primary key and foreign key concept in tables.
04:23 New courses are coming
05:37 How to make a foreign key in Oracle
06:37 How to apply a foreign key in SQL tables?
07:45 The primary key in the referenced table is the roll number.
Very nice explain in dbms syllabus
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 🙏🎀
Sir I got job.... Almost all these questions asked thank you sir SO much............
Love from Pakistan 🇵🇰❤️🇵🇰
Thank you so much for your effort sir..Your way of explaining a topic is too good and simple🙏🙏🙏😇😇😇
Sweat is releasing from your body but still you are teaching. Thanks a lot♥
App her video kay baad thank you bolte ho magar thanks karna to hamara banta hai. Thanks for such a nice tutorial.
This is one of the best lectures on TH-cam of dbms
My college teacher is such a boring
LOVE AND RESPECT FROM AMERIKA DEAR SIR ❤ 🇺🇸🇺🇸🇺🇸🇺🇸🇺🇸🇺🇸
Great Explanation !Thanks For videos
Namesty sir , your videos so helpfull for gate n net xam, academic Xam ......... please make videos of DM and information of JNU Mtech Computer science
sir i'm from pakistan your teaching method is great
Thank u sir❤
so basically the foreign key is used to join two tables using the primary key.
Thank You :)
sahi hai.. itni si baat ko itna lmba khinchta hai. pta ni logo ko iska samj kese aa jata hai
thanks your teaching and knowledge exprince is so adorable ,,,,,,,
It is so easy to understand the concepts through ur videos sir....love from kerala
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Such a.. great lecture...it's very helpful 4 me😊😊
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Great work sir ❤🔥
Sir you are sweating and looking tired still you are teaching just for us 🙏🙏🙏
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 🇵🇰
Your style of explaining is wonderful
thanks sir you deliver way of lecture is inspiring
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Waaah... kya baat... Samajh gaya... Thank you so much!
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Thanku so much sir love from my small village
Sir apne toh is topic me bhi maze dila diye... Aweaome sir...❤️❤️❤️❤️👍👍👍👍
Just wanted to say thank uhh sir ...your explaination is just straight and easy!!
Thanks sir for your continuous support 🙏🏻
Thankyou sir . Your efforts = our success. Hats off sir ❤️God bless you ❤️
Ye bhaut important video thi thanks😊😊😊😊😊😊
Thanks, Sir Your teaching method is so good and I understand it easily and frequently
Big Salute to you.