Keys in DBMS | Super Key| Candidate Key| Primary Key| Foreign Key |DBMS Lect 14| Shanu Kuttan |Hindi

Поділитися
Вставка
  • Опубліковано 28 сер 2024
  • #DBMSKeys #SuperKey #CandidateKey #PrimaryKey #ForeignKey #AlternateKey #CompositeKey #Keys in DBMS
    This video explains: Keys in DBMS or DBMS Keys or Types of Keys in DBMS or Keys in ER Model, DBMS Keys in Hindi, Keys in DBMS in hindi or Types of Keys in DBMS:
    Super Key,
    Candidate Key,
    Primary Key,
    Foreign Key,
    Alternate Key and
    Composite Key
    This is a lecture 14 for Database Management System (DBMS) unit 1 according to CSVTU bhilai.
    For more videos on DBMS follow the given link :
    DBMS Playlist: • DBMS Playlist
    ER Model Playlist: • ER Model in hindi
    Relational Model Playlist: • Relational Model & Rel...
    SQL Playlist: • SQL
    Lecture 1: Database Management System (DBMS) Introduction • Database Management Sy...
    Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence • View of Data in DBMS |...
    Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model • Data Models | Relation...
    Lecture 4: Database Languages | DDL, DML, DCL, TCL • Database Languages | D...
    Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL • Database Access from A...
    Lecture 6: Database Users and Administrators • Database Users and Adm...
    Lecture 7: Transaction Management & Storage Management • Transaction Management...
    Lecture 8: Database System Structure, Query Processor, Storage Manager • Database System Struct...
    Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture • DBMS Architecture | 1-...
    Lecture 10: History of Database Systems • History of Database Sy...
    Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships • Introduction to ER Mod...
    Lecture 12: Types of Attributes in ER Model • Types of Attributes in...
    Lecture 13: Mapping Cardinalities & Participation Constraints • Mapping Cardinalities ...
    Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key • Keys in DBMS | Super K...
    Lecture 15: Strong Entity & Weak Entity in DBMS • Strong Entity & Weak E...
    Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS • Strong Entity & Weak E...
    Lecture 17: Converting ER Diagrams to Tables with Examples | Rules • Converting ER Diagrams...
    Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 - • Questions on Conversio...
    Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 - • Questions on Conversio...
    Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations • How to draw ER Diagram...
    Lecture 21: Relational Model in DBMS | RDBMS • Relational Model in DB...
    Lecture 22: Relational Model Mathematical Structure in DBMS • Relational Model Mathe...
    Lecture 23: Integrity Constraints • Integrity Constraints ...
    Welcome to this youtube channel "Shanu Kuttan CSE Classes " by Shanu Kuttan. This is a technical educational channel for subjects of computer science and engineering subjects (CSE) as per university syllabus and also cover GATE topics. It provides Computer Science and engineering classes in Hindi. This channel’s video helps Computer Science and Engineering students to understand different subjects like Computer System Architecture (CSA) i.e. Computer Organization and Architecture (COA) or simply Computer Architecture, Database Management System (DBMS), Advance Computer Architecture (ACA), Parallel Processing and Computing (PPC) unit wise as per the CSVTU syllabus i.e. Chhattisgarh Swami Vivekanand Technical University, Bhilai
    Contact Link in Facebook :
    / shanukuttan.cseclasses

КОМЕНТАРІ • 650

  • @babapatra3735
    @babapatra3735 2 роки тому +285

    The simplest and best explanation of keys on UA-cam.

  • @aman78.50
    @aman78.50 6 місяців тому +13

    Pehli koi teacher mili jinse DB Keys ache se smjh m aayi h🙏🏻🙏🏻🙏🏻❣️🙂

  • @LoneAnsa9019
    @LoneAnsa9019 5 місяців тому +95

    Legends are watching this before one day of exam 😂.. Like and write your names 😂

    • @rakshyawagle
      @rakshyawagle 5 місяців тому +12

      Ultra legend is watching this video before 3 hrs of exam😂

    • @user-ql3tz4se9k
      @user-ql3tz4se9k 5 місяців тому +7

      3 h before 😂

    • @arifafatima7599
      @arifafatima7599 4 місяці тому +8

      Pro legends are watching while standing out of the exam hall 😂

    • @rajasbarve
      @rajasbarve 4 місяці тому +4

      1 hr before exam bro 🤡😂

    • @HamzaKhan-qd4df
      @HamzaKhan-qd4df 4 місяці тому +1

      Who are watching before 3h of exam 😂

  • @Ips_Modi
    @Ips_Modi Місяць тому +2

    Amazing mam you are great. ....super explanation of key
    Aaj mere partical hai viva ke liye ye topic cover ho gya ..Thank you ❤❤

  • @ravirajbhar2896
    @ravirajbhar2896 2 роки тому +7

    I am using UA-cam since 6 years . First time I like a channel on UA-cam 🤗. Your channel and your educating experience is too good....

  • @smrutiranjan2921
    @smrutiranjan2921 2 роки тому +42

    One of the best DBMS course
    👀🔥
    Thanks for the playlist
    Much appreciated 👍🏿

  • @ishrarchowdhury4850
    @ishrarchowdhury4850 Рік тому +5

    Love your accent! Well explained tutorial.

  • @jigyashukeshari9378
    @jigyashukeshari9378 2 місяці тому +2

    ma'am you have the best voice and easy to understand teaching pedagogy.

  • @sunilkumarsingh6023
    @sunilkumarsingh6023 2 роки тому +12

    Thank you ma'am , I am trying to understand it from so many months but always I didn't got cleared about my doubts. After watching your video, I had finally understood it easily with the help of your given examples

  • @muskangarg1107
    @muskangarg1107 Рік тому +7

    You explained this topic in the easiest way. I was not able to understand the difference between the keys but now my concept is clear. Thankyou ma'am❤️

  • @raunaksingh1016
    @raunaksingh1016 2 роки тому +28

    Thank you ma'am for such a nice explanation our school teacher doesn't teach us anything and in these kind of situations teachers like you are not less than angels... 😇

  • @meditationandrelaxingsound2779
    @meditationandrelaxingsound2779 2 роки тому +10

    No one has explained like you...You are amazing...

  • @vlogs0484
    @vlogs0484 2 роки тому +7

    This is simplest and very helpful explanation on key I have ever seen on UA-cam thank you mam really appreciated ✌️😎

  • @harishanker9741
    @harishanker9741 8 місяців тому +1

    Fabulous explanation. Very detailed and with examples.
    One of the best resources on UA-cam to study DBMS

  • @priyajswl
    @priyajswl 3 роки тому +5

    Ma'am your communication n way to speak is nice.. Sweet to hear u

  • @YousafMehar-ti1wy
    @YousafMehar-ti1wy 4 місяці тому +1

    i have seen many videos to cover this topic but I could finally understand it completely in this one

  • @choubeybiharwala7703
    @choubeybiharwala7703 5 місяців тому +2

    Literally the very simplest way to explain Thank you so much ma'am

  • @joksjoke
    @joksjoke 2 роки тому +4

    i fall in love with this subject after watching yours videos. Thanks a lot Mam !!

  • @prasadpatil6139
    @prasadpatil6139 2 роки тому +4

    Thank u ma'am for making such helpful videos. Simple language , simple explanation from your side has made it easy to understand

  • @user-du5zs8bl4r
    @user-du5zs8bl4r 6 місяців тому +3

    Best explanation ever I have seen in youtube🎉❤

  • @vinz_clickz
    @vinz_clickz 2 роки тому +5

    have an exam in few hours and needed this badly thanks alot :)

  • @maaleem90
    @maaleem90 Рік тому +2

    What kind of explanation is that. I don't understand how you guys are liking it, I just love it beautiful explanation simplest possible

  • @mehakarora7399
    @mehakarora7399 6 місяців тому +1

    Best content + clear explanation + point to point understood ❤ thank you

  • @ashuking7172
    @ashuking7172 3 місяці тому +2

    One of the best and simplest explanation of keys❤️

  • @Ratneshkavlogs
    @Ratneshkavlogs 9 місяців тому +1

    बहुत ही शानदार स्पष्टीकरण है. मैं BPSC शिक्षक नियुक्ति परीक्षा के लिए आपका वीडियो देखता हूँ और संक्षेप नोट्स तैयार करता हूँ

  • @ArvindKumar-gx8eq
    @ArvindKumar-gx8eq 8 місяців тому +2

    Finally I understand the concept of keys. 🙏

  • @MARVEL-DCclips
    @MARVEL-DCclips 7 місяців тому +3

    Finally keys ka concept clear hua
    Thank u mam ❤

  • @bhawnavig4606
    @bhawnavig4606 11 місяців тому +2

    Thankiu mam❤️
    Bst explanation
    Itne ache se🥹❤️smjayeya
    Thankiu so much

  • @jagvirsingh160
    @jagvirsingh160 3 місяці тому +2

    Today is my DBMS exam ❤ this video help me a lot 🙏🏻

  • @akashprasad7316
    @akashprasad7316 8 місяців тому +2

    Mam ur voice is so crisp and clear love ur voice ❤

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

    Easiest and simple explanation of keys Thank You ! love from Pakistan ❤️

  • @forrdist._999
    @forrdist._999 5 днів тому +1

    Thank you so much ma'am. Loved it ! ❤

  • @mithunkr6925
    @mithunkr6925 4 місяці тому +1

    Thank you so much mam. aapka explain karne ka way bahoot badhiya hai. aur sath main zo aapna ppt banaya hai wo bhi bhoot accha hai aur aapne sabhi point ko clear bhi kiya.

  • @devrajsingh4680
    @devrajsingh4680 6 місяців тому +3

    Bohot bura lag raha h ki itne acche videos bana se bhi itne kam subscribers
    Subscribe karo dosto kya kar rahe ho
    Love you mam ❤
    Lagta h mam aap pehle singer thi ❤

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

    This is simplest and very helpful explanation on key in simple language , Thank You Mam

  • @vanshika14_
    @vanshika14_ 2 роки тому +3

    Best video of different keys over the internet till yet 😍

  • @atulagrahari9102
    @atulagrahari9102 2 роки тому +4

    Thank you very very much ma'am, 🙏🙏👍 great explanation.

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

    Aaj phli baar itne ache se video dekhi and mam apne jo example lykar explain kra na , mujhe lgta h aaj ke baad mai kbhi nhi bhulunga ye keys😅😅

  • @SomvirMalikkalkha
    @SomvirMalikkalkha 3 роки тому +10

    absolutely brilliant way of explaining the concept. (step by steps, concept after concept).
    Very Impressive

    • @SomvirMalikkalkha
      @SomvirMalikkalkha 3 роки тому +2

      As I see,
      No one have any query left after the explanation. Since there is nothing left to explain

  • @ritikyadav1112
    @ritikyadav1112 Рік тому +2

    Yes mam aapki videos DBMS ki kaafi helpful hain😊

  • @denzelsmith1961
    @denzelsmith1961 Рік тому +32

    8:59 candidate key
    12:41 primary key
    15:56 alternate key
    16:38 foreign key

  • @mansoorrana4063
    @mansoorrana4063 3 роки тому +2

    Thanks Ma'am Bohat acha Explain kia aap ney.
    #Respect from Pakistan.

  • @ANKIT_55555
    @ANKIT_55555 5 місяців тому +1

    Ma'am has done tremendous job. Well done Ma'am! Keep doing it 👏

  • @sankalpjoshi1166
    @sankalpjoshi1166 2 роки тому +4

    Wonderful to learn such a tough topic in sach a easy way. Thank you so much. ☺️

  • @priyankathakare2760
    @priyankathakare2760 2 роки тому +4

    Simple and short explanation.Thank you Madam 🙏

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

    Mam i got tied in finding the person who make me understand this content...thank got finally i got u ...like ur lecture mam

  • @Abdurrahman-ew1rw
    @Abdurrahman-ew1rw 3 роки тому +9

    Maybe i don't need to go college for lectures......what a teaching outstanding 🔥🔥🔥

  • @mananambani6858
    @mananambani6858 Рік тому +2

    Good explanation, Thank you mem 🙏🙏

  • @ankitasantape1063
    @ankitasantape1063 3 роки тому +7

    Thanks a lot ma'am:) May god bless uh 🙏

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

      My pleasure......For latest videos u can subscribe the channel and can share the videos to others

  • @shoaibakhtar5889
    @shoaibakhtar5889 2 роки тому +3

    Ma'am, I have gone through almost every tutorial of DBMS i haven't found a good one but the way you teaches is mind blowing.Thank u so much.

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

    Thank You very much mam I have been watching videos released keys but I didn't understood from anywhere, but I think your video helped me alot 🙏🏼

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

    Thanks u so much 🥰
    Shortest way to explain all key 🗝️
    How relate all keys you clearly clear concept 🙏🙏

  • @user-uh6oc4qv2n
    @user-uh6oc4qv2n 4 місяці тому +2

    Thxs mam tomorrow mera exam h ess video ko dakhna sa mera concept clear hogya😊😊😊😊

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

    Thankyou so much ma'am tomorrow is my IP paper and I have doubt, aur mene aapka video dhekha aur mujhe sab samaj aaya thankyou so much ☺️😊

  • @SACHINKUMAR-ye8dc
    @SACHINKUMAR-ye8dc 2 роки тому +1

    bhoot sare video dekh liya tha but smjh nhi aa rha tha but apke video bhoot aache hain ek bar me hi smjh aa gya thnxs

  • @deerisefitness4736
    @deerisefitness4736 3 роки тому +3

    Ahh finally I got what I needed..
    surely this video gonna help me...in my upcoming prctcl...😝
    Ty for this inf.✨wd yur soothing voice..which helps me to concentrate more nd more.. 😍

  • @vipulkushwaha7883
    @vipulkushwaha7883 2 місяці тому +1

    Badhiya smjhata mm, sb smjh aaya dhire or aaraam se smjhata aapne,

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

    No one has explained better than you thank you so much mam for making this video with great explanation ❤

  • @sankariroy9554
    @sankariroy9554 Рік тому +2

    Thank you for the explanation ma'am.....

  • @adityachandrasourav3236
    @adityachandrasourav3236 3 роки тому +3

    Thank you so much maim your teaching way is so beautiful

  • @AnujKumar-tt5md
    @AnujKumar-tt5md 2 роки тому +5

    Refreshing topics after 12 yrs of engineering. Thanks🙏

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

    Described in a very Simple way and easy to understand. G8! work !!!

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

    I love with ur teaching and speaking skills ❤️. Thanks alot ❤️

  • @pushanbasu7192
    @pushanbasu7192 3 роки тому +8

    Excellent explain. Besides, I must say, your voice has something that helped me concentrate better. 💛

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

    Mam realy one of tha best teacher in india 🥰🥰
    nice explation

  • @rupendraediting
    @rupendraediting Рік тому +2

    In the best language you gave me explained thank u so much mam🙏

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

    Aap ki explanation bohut hi badhia tha ak bar samajh mai aa jayega

  • @pratikkumarsahoo523
    @pratikkumarsahoo523 2 роки тому +5

    Best explanation For Bigneers 😮

  • @web_with_gautam94
    @web_with_gautam94 9 місяців тому +1

    Thank you Mam 😊
    Your teaching way is very understandable 🎉

  • @ghanshyamyadav1475
    @ghanshyamyadav1475 4 місяці тому +1

    Fantastic explaning and great experience 🎉❤

  • @Shubhamdhanda111
    @Shubhamdhanda111 8 місяців тому +1

    My DBMS exam is day after tomorrow and your explanation is really appreciable..😊

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

    One of the best explanation on keys ♥️...
    Thanks alot mam💐💐

  • @WinnerOrLosser-zn4ms
    @WinnerOrLosser-zn4ms 8 місяців тому +1

    ma'am god bless you. i have no words to appritiate you. Thank You

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

    What a Video "Best".........ton of information with simplicity......liked it!!!!!!!!

  • @meghanareddy2197
    @meghanareddy2197 3 роки тому +5

    A perfect video.. I was searching for.. great explanation ma'am.. Thank you

  • @berozgaar_creator
    @berozgaar_creator 3 місяці тому +1

    maam aapne bahut easily samjhaya bahut acche se samajh aaya mujhe thank for this Helpful video🙏☺

  • @MukeshKumar-ko2xc
    @MukeshKumar-ko2xc 4 місяці тому +1

    Thank you very much mam❤ it helped me a lot for my sem exam

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

    The simplest and easy way explain thankqqq so much mam,♥️♥️🥰♥️♥️♥️

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

    Excellent way of explaining mam, I am from Lahore Pakistan and may Allah bless you and enlighten you also grant you health wealth and success ameen regarding

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

    thnku mam😇
    aap bhut ache se explain krate hoo 😊

  • @someone0825
    @someone0825 5 місяців тому +11

    Tomorrow is my exam and today I m watching this in 2x😂

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

    aap really bahut hi achha samjhti ho i understood easily

  • @vipulkushwaha7883
    @vipulkushwaha7883 2 місяці тому +1

    Asa badhiya smjhaya ki mn Kiya like or subscribe krne ka

  • @kaju4925
    @kaju4925 8 місяців тому +1

    Thanku so much mam making this vdo your explanation is so very amazing 😍

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

    Wonderful explaination I get whole concept easily thanku very much mam👍

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

      My pleasure.........do subscribe and share to others also that they can be benefited

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

      @@ShanuKuttanCSEClasses I had shared it already with my friends but I forget to subscribe but I will do it right now😊

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

      🙏🙏

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

    Thankyou mam ,nice explanation kaphi easily samjh me aa gaya

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

    Thanks mam this is very useful information about key in DBMS 👍🙏

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

    Thank you ma'am for the clear explanation
    you have a great voice

  • @md.jubair8893
    @md.jubair8893 3 роки тому

    কত সুন্দর সহজ প্রাঞ্জল ভাবে বুঝিয়ে দিল। আহা আহা!

  • @UmarHashmi-sf8cf
    @UmarHashmi-sf8cf 3 місяці тому +1

    Mam very beautifull explaination❤❤

  • @ujjwalbhardwaj5595
    @ujjwalbhardwaj5595 3 роки тому +6

    Finally got the video with clear explaination ! Thank uh Ma'am

    • @ShanuKuttanCSEClasses
      @ShanuKuttanCSEClasses  3 роки тому +5

      My pleasure......for latest videos u can subscribe the channel and share to others also

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

    Awesome explanation. Thank you so much

  • @user-iy4zd5mu2o
    @user-iy4zd5mu2o 5 місяців тому +1

    Thanks mam❤❤❤ your teaching method very best

  • @SanjayKumar-yh8fd
    @SanjayKumar-yh8fd 2 роки тому +1

    thanks ma'am today my this concept clear now, this always make me confuse

  • @bibhanjalidubey8430
    @bibhanjalidubey8430 10 місяців тому +1

    Thankkk u soo much mam, bohot easily topic ko cover kiya h aapne🙏🥰

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

    best video for concept clearings

  • @user-tk2xk6uh1j
    @user-tk2xk6uh1j 9 місяців тому +1

    One of the best DBMS course

  • @user-ke1xw3gz8y
    @user-ke1xw3gz8y 4 місяці тому +1

    Maam bohtttttttt achaa smjhaya boht shukaria ❤❤❤

  • @1907nh
    @1907nh Рік тому +3

    Very nice explanation ✨

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

    To gain great knowledge within a short time go for Shanu mam!!!!!!