3.11 Super Key, Candidate Key and Primary Key

  Рет қаралды 411,260

KnowledgeGATE by Sanchit Sir

KnowledgeGATE by Sanchit Sir

Күн бұрын

Пікірлер: 448
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM
@vijone111
@vijone111 6 жыл бұрын
Sir really GOD n aap ko but expressive skill Di h....aap ka video dek k lgta h ki DBMS bhi bhut aasaan h jab aap jse SIR ho...GOD bless u SIR....
@milanjain.2564
@milanjain.2564 6 жыл бұрын
Right
@pinkipatel7000
@pinkipatel7000 6 жыл бұрын
Sir plzz upload a video series of how to convert ER diagram in to a relational model... As soon as possible
@pritiverma845
@pritiverma845 4 жыл бұрын
Yes u r right not only DBMS operating system ... Also
@mohitsaran9193
@mohitsaran9193 3 жыл бұрын
Sir I must say that there's no better explaination and simplification in the world than this lecture. Wish you alot of blessings sir
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thank you Mohit for your valuable feedback.. Stay blessed !! Keep learning and supporting !!
@najmuzzamakhan835
@najmuzzamakhan835 3 жыл бұрын
Actually Sir, you are a primary key(unique & best) from a lot of entity(Teachers) in entity set(Teaching Field). God selected you as a primary key. ❤❤❤❤
@sandeepsahu8743
@sandeepsahu8743 6 жыл бұрын
The one and only candidate key by which we can understand all the concepts easily is SANCHIT JAIN SIR.....Thnxx a lot sir for providing such great videos🙏
@suryaajha5953
@suryaajha5953 5 жыл бұрын
This was the most correct video logically as the explanation of all these keys. I was always with these keys and thought these concepts are just to confuse readers. Thanks Sanchit Sir. As a short note Super key us the set of attributes from which you can uniquely identify a row or a tuple in the table. Key = Super Key Candidate key is the super key whose proper subset itself is not a super key. A Primary key is candidate key selected by DBA as a primary key to identify a row or a tuple in the DB
@ashwanipanchal7467
@ashwanipanchal7467 5 жыл бұрын
sir your whole playlist is amazing... its really help me out with all DBMS related doubts. keep uploading new content sir.. and at the end thanks a lot sir.
@AmitKumar-hv6hs
@AmitKumar-hv6hs 5 жыл бұрын
sir please make videos on other subjects of cse too because you are fabulous no one can teach like you , aapse padhne ke saath saath hi yaad ho jaata dimag me baith jaata hai cheeje
@jackfrost8969
@jackfrost8969 5 жыл бұрын
oh my god. This is beyond perfection.
@shwetamehrolia2848
@shwetamehrolia2848 6 жыл бұрын
the perfect teacher, as soon as i gather a doubt when u complete a sentence , in the next sentence only u clear that doubt. :) brilliant sir :)
@zarifali3255
@zarifali3255 5 жыл бұрын
One of the best keys explanation in youtube.
@anuragchowdhury4101
@anuragchowdhury4101 3 жыл бұрын
*The* Best
@afzalmehndi9911
@afzalmehndi9911 2 жыл бұрын
Sir ki jitni tareef ki jaye kam hai …..bahot asani se sab samjha dia…. ✌️👍 thank you so much
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Most welcome dear Afzal, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@aryanrathore1790
@aryanrathore1790 4 жыл бұрын
@3:17 this is something which no one tells and that's why I love Knowledge Gate:):)
@aviksarkar8997
@aviksarkar8997 5 жыл бұрын
DBMS pr confidence apke waja se he sir, thank you sir, god bless you sir
@ahadkhan6630
@ahadkhan6630 4 жыл бұрын
one of the best teacher on youtube with great teaching skills
@devinderkaur9811
@devinderkaur9811 5 жыл бұрын
You are one of the best teacher. Your capacity of repeating one thing in each video again n again do not let us to forget anything n helps in better understanding. Thank you!
@akshatjain9762
@akshatjain9762 4 жыл бұрын
Watching this again after 2 years 🤩... Remembering those college xams and ur videos
@thegopalsharma2389
@thegopalsharma2389 3 жыл бұрын
we are berozgar
@ADARSHKUMAR-bo1rj
@ADARSHKUMAR-bo1rj 6 жыл бұрын
You awesome sir jii .. the way of explaining every point is marvaoulus .. you r too good .. Maine kv DBMS and OS itne asaani s nhi samjha tha jitna Aapne smjhaya ... Thanks a lot and God bless you .
@Ankit-we8ym
@Ankit-we8ym 6 жыл бұрын
bilkul sir aapne vaada pura kiya h .thanks a lot
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
@harpreetv761
@harpreetv761 6 жыл бұрын
I ll always comment sir.. very nyce.. i understand the normalization concept for first time .. just because of you sir.. thanks sir
@narendrachoudhary6808
@narendrachoudhary6808 4 жыл бұрын
Sir you are the bestest!! I wish ki hm aapka video placement k time me dekhe hote.!
@akankshachuchra
@akankshachuchra 4 жыл бұрын
I came to your channel for just one video related to OS but i'm here, watching all videos now. Kudos! Such easy and effective explanations. One of the best on youtube.
@sangamumbarkar9544
@sangamumbarkar9544 4 жыл бұрын
Our education system needs more people like you...♥️♥️the way u give the examples is just awsm 🖤..nd one of the most important thing is that u taught us free of cost 🤙🤙🤙#Thanks a lot sir
@pranjalvyas6723
@pranjalvyas6723 4 жыл бұрын
Thank you so much for existing and sharing the knowledge with us. You are a true savior. 🙏🙏🙌🙌
@kanak1448
@kanak1448 Жыл бұрын
I wonder if anyone could teach this concept better omg he is such a great teacher ❤️
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thank you so much for your valuable feedback ❤ Keep learning & supporting! 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
@pranavtiwari1883
@pranavtiwari1883 4 жыл бұрын
Bahot shaandar tareeke se logic clear kiya h....Jai ho sir ji ki
@bhupendrasolanki6572
@bhupendrasolanki6572 6 жыл бұрын
Sir please upload a videos on SQL(Structure Query Language) and thank you sir for upload videos on DBMS
@aqsamumtaz462
@aqsamumtaz462 6 жыл бұрын
sir u make every piont so clear and easy .....that anyone can easily memorise lecture ...
@subhankardutta6054
@subhankardutta6054 5 жыл бұрын
extra ordinary for student like us.. you are making dbms,os interesting to the student like me.. at 13:56 "B" won't be there..
@sadiq4933
@sadiq4933 4 жыл бұрын
I m.speechless after seeing this lesson..Just Awesome..🌸
@brilliantboy8147
@brilliantboy8147 6 жыл бұрын
mai aapka sach mai fan ho gaya... kya paraha....jabardast
@redrose5950
@redrose5950 3 жыл бұрын
Excellent superb explanation by Sir Sancit Jain. I salute you Sir. MAY ALLAH bless you.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thank you so much.. Keep learning and supporting !!
@nandini-ec5xl
@nandini-ec5xl 5 жыл бұрын
thank u sir ,its only now I understand the difference between super key and candidate key... aap subject ko bahoothi asaani thareeki se samjaraahi ho...
@gordxrohit
@gordxrohit 3 жыл бұрын
Thanks sanchit sir 🙏🙏 For ur Nice and Easy way of explaination I'm literally finding this in KZbin and finally get it ur best playlist of dbms 🙏🙏
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
You're most welcome dear.. Stay tuned !! Do visit our website www.knowledgegate.in for more courses and contents. Keep learning !!
@arafat6578
@arafat6578 6 жыл бұрын
Aacha video hai sir. Video Bahut helpful hai... Thank you so much sir...
@sunilkumargouda6353
@sunilkumargouda6353 6 жыл бұрын
Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
@doonboy1100
@doonboy1100 5 жыл бұрын
Sir u r awesome bahuton ko bolte suna h ki me wada krta hu last tk tmhe sb smg aa jaaega pr koi smga ni ska pr apne in 21 minute me hi pura concept hi clear krwa dia thanku sir❤❤
@astikpatil5773
@astikpatil5773 Жыл бұрын
Your teaching is great sir. You go to the root of the concept 😇. thank you so much for making this video. It help me a lot.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
You're most welcome dear @Astik😍keep learning! Do like, subscribe & share our videos, you can also visit our website www.knowledgegate.in for more amazing videos & contents👍
@asitkumarojha1305
@asitkumarojha1305 3 жыл бұрын
Best teacher.....sir u r Just amazing... teaching process....just wow...🙏🏻🙏🏻🙏🏻🙏🏻
@kartickchandramanna267
@kartickchandramanna267 2 жыл бұрын
Excellent lecture on database keys. My concept is clear now. Thank you sir 🙏❤️
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Most welcome dear 😍keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
@sunandagaikwad2121
@sunandagaikwad2121 4 жыл бұрын
One of the best...video... Teaching quality is best.... 👍👍👌👌💐💐💐
@Pankajkumar-dy9ef
@Pankajkumar-dy9ef 6 жыл бұрын
God spotted
@anilpariyar19
@anilpariyar19 6 жыл бұрын
Well defined in the easiest way and very understandable. Thank you so much, sir. Appreciated your work. Love from Nepal.
@uvinodh90
@uvinodh90 4 жыл бұрын
I am glad that I found your channel. Thanks for providing free teachings.
@memonakarim6687
@memonakarim6687 4 жыл бұрын
bht bht acha lacture h Allah pak apko khush rkhn ameen
@AnubhavMadhav
@AnubhavMadhav 4 жыл бұрын
Bhai kya mast examples diye hain.....fan ho gaya!!
@bhardwajsourabh4
@bhardwajsourabh4 5 жыл бұрын
I don't have an exam neither am I a CSE student. But because of your teaching style, I am having an attraction towards DBMS. Thank You!!
@Paaaaaaaaaaal
@Paaaaaaaaaaal 3 жыл бұрын
Wtf
@RandomGuy-hv7tb
@RandomGuy-hv7tb 2 жыл бұрын
@@Paaaaaaaaaaal my reaction is also same who the hell likes this theory, coding is addictive but this theory isn't.
@Jonathan-ng4vw
@Jonathan-ng4vw 2 жыл бұрын
@@RandomGuy-hv7tb right bro🤣
@yawarahmad9899
@yawarahmad9899 4 жыл бұрын
Primary key selection through transaction example. Shandaar sir. !
@user-df9gv4ox8k
@user-df9gv4ox8k 4 жыл бұрын
Sir...DBMS me pass hone ka reason sirf aapki ye videos hai...Thank you sir
@khwahish4483
@khwahish4483 6 жыл бұрын
Sir really appreciated.. too good sir.. thanks alot
@adityabaroliya8378
@adityabaroliya8378 3 жыл бұрын
very nyc sir kabhi socha nahi tha yeah topic bhi seekh pauga but u made it possible if someone wants to learn normalization watch knowledge gate from 3.1 to 4.12 must watch
@khwaishbatish5355
@khwaishbatish5355 4 жыл бұрын
Thanku sir Kisi teacher ne aise nahi samjhaya ye concept.
@monikasharma1184
@monikasharma1184 5 жыл бұрын
god bless you sir..may you get everything in your life, whatever you want..
@vaibhav9727
@vaibhav9727 2 жыл бұрын
Thank you very much ...Really extraordinary ...Very Greatfull to you sir.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
You are most welcome dear Vaibhav, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@shubhammehra1512
@shubhammehra1512 3 жыл бұрын
Damnnnn...Sir Thanks for clearing our doubts..❤️❤️
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
You are welcome dear Shubham, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@chitrasingh8724
@chitrasingh8724 4 жыл бұрын
Mind blowing lecture
@nihalsingh5558
@nihalsingh5558 6 жыл бұрын
Awesome video sir, unforgettable explanation, thank you so much.
@NIKHIL-nv8wu
@NIKHIL-nv8wu 5 жыл бұрын
Thank you sir ek dam sari keys ka confusion dur ho gya. Keep it up sir
@shashankbhosagi
@shashankbhosagi 2 жыл бұрын
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 Bahut acchese samaja aya sir Thank you sir !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Most welcome dear.. keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing contents & courses !
@DeepakMauryaLucknow
@DeepakMauryaLucknow 6 жыл бұрын
Bhai log channel subscribe krr lo...kitna acha padhaate sir
@parasmehta7793
@parasmehta7793 4 жыл бұрын
Extra ordinary Example...🔥🔥
@sanchitjainfanclub3620
@sanchitjainfanclub3620 6 жыл бұрын
Way of explaining is wow!!!
@keshavshinde8886
@keshavshinde8886 4 жыл бұрын
Sir Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
@amey1125
@amey1125 Жыл бұрын
I gotta tell you it is perfect. Everything. Down to the last, minute details
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thank you so much dear❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing contents & complete courses 👍😊
@muhammadkhurram4221
@muhammadkhurram4221 5 жыл бұрын
best teacher I have ever listen . Love from pakistan sir.
@animeshkumar1641
@animeshkumar1641 4 жыл бұрын
Thank u for the important concept sir
@abhishekaggarwal3831
@abhishekaggarwal3831 6 жыл бұрын
sir aajtak yeh samaj nahi aata tha .. aab aa gaya .. thanks sir
@PushpendraSingh-qv8ew
@PushpendraSingh-qv8ew 5 жыл бұрын
Aapka technique bahut behtar h
@gokarnabhatt7377
@gokarnabhatt7377 2 жыл бұрын
Your teaching skill is great sir g❤️love from Nepal.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thanks a lot dear, Stay blessed ❤️❤️ Keep learning & supporting !!
@wakeelahmad7747
@wakeelahmad7747 6 жыл бұрын
excelent method to understand this concept thanks for this sir
@tahirmehmood8837
@tahirmehmood8837 5 жыл бұрын
Thank u very much sir your method is so effective ..
@sadiaafrin7143
@sadiaafrin7143 6 жыл бұрын
God bless you sir
@aditikumari3358
@aditikumari3358 5 жыл бұрын
Thanku sir...aapki video dekh ke lg rha b.tech time me kyu nhi dekhi us time to sb upar se jata tha etne achhe teacher nhi the humare pass warna aaj gate ke kisi psu me Hoti😭
@abhishekjain1438
@abhishekjain1438 3 жыл бұрын
what an explanation SIR , GREAT
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thanks Abhishek.. Keep learning !!
@PankajKumarShweta
@PankajKumarShweta 6 жыл бұрын
Very good sir aap logically Bahut achchha samjhate hai
@ShoaibKhan0701
@ShoaibKhan0701 4 жыл бұрын
Nice Sir thanks for making videos on this topic
@furqanhaider1154
@furqanhaider1154 5 жыл бұрын
wah Sir ,respect form Pakistan .... kamal kar dia ... waday k pakky hain ap :-)
@ocean_eyes
@ocean_eyes Жыл бұрын
You're the best sir ji! 🙌
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thank you for the kind words dear❤ 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
@_Pearl-vy7qn
@_Pearl-vy7qn 3 жыл бұрын
Great explaination......welll knowledgable sir
@allwell8570
@allwell8570 2 жыл бұрын
Sir, your explanation skills are excellent
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thanks a lot dear Ramesh, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@mohsin7343
@mohsin7343 Жыл бұрын
I feel relaxed when i see my favorite teachers video on the topic I'm searching for😌😌
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thank you so much dear for your valuable feedback, stay blessed❤ 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
@yashsonwane4218
@yashsonwane4218 6 жыл бұрын
Sir, Please make video on topic "Generation of permutations and combination ".
@chetanraj1950
@chetanraj1950 6 жыл бұрын
Thanku so much sir...You are really a great tecaher.
@KDTechverse
@KDTechverse 5 жыл бұрын
Someone said.. Legends are not born they're made. And Sanchit sir is a proof of that.
@adityahirwani1672
@adityahirwani1672 4 жыл бұрын
Amazing explanation , sir, you are clearing our concepts not just exams.
@SameerKumar-rm3by
@SameerKumar-rm3by 4 жыл бұрын
Sir you have got amazing teaching skills..keep supporting us.
@sauravkashyap7734
@sauravkashyap7734 5 жыл бұрын
sir aap best ho :)
@koustavdas6585
@koustavdas6585 4 жыл бұрын
You are the teacher of the teachers. Love you sir. ❤❤
@rajatkapoor7087
@rajatkapoor7087 2 жыл бұрын
Best video I have found on Keys 🔥🔥
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thank you dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
@jiveshshrivastav9722
@jiveshshrivastav9722 4 жыл бұрын
Beautifully Explained...............
@soniasmelodiousland
@soniasmelodiousland 5 жыл бұрын
Yes sir bore nai hota with ur lessons. enjoy studying best teacher
@jyotiruhela9877
@jyotiruhela9877 4 жыл бұрын
Amazing teaching skill...keep the gud work on nd keep uploading new contents...Thnx alot sir
@siddharths067
@siddharths067 4 жыл бұрын
You can use augmentation in D -> A and transform it into DB -> AB. Then transitivity can be used with AB -> C to give DB -> C which can then be unioned with DB -> ABC to give DB -> ABCD which is a super key.
@PiyushKumar-bd7uc
@PiyushKumar-bd7uc 3 жыл бұрын
sir words are not enough to describe your excellency.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thanks a lot dear Piyush, Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@-AnkitBsccomputerapplication
@-AnkitBsccomputerapplication 2 жыл бұрын
best way to understand keys........ thanks sir
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowlegdegate.in for more amazing courses & contents 👍😊
@rocktrekker3810
@rocktrekker3810 5 жыл бұрын
Awsm sir ji... Aap great hai
@infinitebeauties7253
@infinitebeauties7253 2 жыл бұрын
aapne apna wada pura kia hai video ke end tak.....:)
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thanks dear 😍 Keep supporting & stay connected 👍😊
@tusharsinghnegi1291
@tusharsinghnegi1291 2 жыл бұрын
this topic is difficult to explain but you explained very well thank you sir ❤️
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Most welcome dear Tushar, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !
@ananyabhatt2715
@ananyabhatt2715 6 жыл бұрын
Awesome sir..U really make concepts easier and interesting.
3.12 Finding Number Of Candidate Key
24:42
KnowledgeGATE by Sanchit Sir
Рет қаралды 302 М.
3.10 Keys In DBMS
16:38
KnowledgeGATE by Sanchit Sir
Рет қаралды 425 М.
How Strong is Tin Foil? 💪
00:25
Brianna
Рет қаралды 33 МЛН
Хасанның өзі эфирге шықты! “Қылмыстық топқа қатысым жоқ” дейді. Талғарда не болды? Халық сене ме?
09:25
Демократиялы Қазақстан / Демократический Казахстан
Рет қаралды 357 М.
Try Not To Laugh 😅 the Best of BoxtoxTv 👌
00:18
boxtoxtv
Рет қаралды 6 МЛН
Seja Gentil com os Pequenos Animais 😿
00:20
Los Wagners
Рет қаралды 68 МЛН
4.13 How to Identify Normal Form Practice Question Part-1
30:33
KnowledgeGATE by Sanchit Sir
Рет қаралды 480 М.
Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS
35:55
Jenny's Lectures CS IT
Рет қаралды 759 М.
MR BEAST PARODY 🤑 Ft. INDIAN CREATORS | CARRYMINATI
22:01
CarryMinati
Рет қаралды 54 МЛН
4.10 Decomposition into 3NF Third Normal Form
21:46
KnowledgeGATE by Sanchit Sir
Рет қаралды 376 М.
Keys in RDBMS
22:49
Neso Academy
Рет қаралды 356 М.
4.2 Basic Concept of Normalization
13:34
KnowledgeGATE by Sanchit Sir
Рет қаралды 739 М.
Concept of Keys in DBMS - Super, Primary, Candidate, Foreign Key, etc
9:16
Studytonight with Abhishek
Рет қаралды 517 М.
How Strong is Tin Foil? 💪
00:25
Brianna
Рет қаралды 33 МЛН