2.6 Mapping Cardinalities and Cardinality Ratio in ER diagram

Поделиться
HTML-код
  • Опубликовано: 13 дек 2024

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

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

    For complete DBMS, check out this video: ruclips.net/video/YRnjGeQbsHQ/видео.html

  • @PriyanshuPareek
    @PriyanshuPareek 6 лет назад +55

    Hatsoff to you sir! You are an amazing teacher. You reduce all these big scary topics to just basics which only need some practice before main exams like GATE, NET and these are always helpful in B.Tech and many other fields. I would like to help you in every aspect possible because I want you to really get paid off of the hard work you have done. I've been sharing all your videos with all my friends. I thank you from the bottom of my heart.

  • @sauravranjansharma1592
    @sauravranjansharma1592 4 года назад +7

    The way you teach is very unique 🙏🙏🙏🙏🙏

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

    Example of Many to One - Religion (Hindu, Muslim, Sikh, Christian) ----------- -----------> INDIAN

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

      Bro it's more of a one to many relationship

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

    Every topic you cover gets crystal clear. hats off Sir 🙌🙏❤️

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

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

  • @saurabhgupta7785
    @saurabhgupta7785 6 лет назад +15

    Sir, Please upload lectures on B and B+ trees.

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

    I have seen the best explanation of this topic .................. thank you sir

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

      You are most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

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

      @@KNOWLEDGEGATE_kg sir, i am preparing for IBPS SO IT OFFICER and SEBI IT OFFICER........ is this playlist helpful for...... these exams???

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

    something

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

    Sir thanks a lot and please complete this series as early as possible 😀✌️

  • @lsuremusic3787
    @lsuremusic3787 6 лет назад +3

    I m preparing for my exams
    .. and KG rocks🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥

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

    Best teacher in the world

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

      Thanks a lot Roman.. Keep learning and supporting. Do visit our website www.knowledgegate.in for more courses and contents.

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

    Nice lecture sir, your lectures are so meaningful 👌👌👌👌👌👌👌👌

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

    "something"

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

    At 14:10 m:n should be in the middle and 1:1 should be on the outer rectangle

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

    Thank you sir for better understanding 🤗

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

      You're most welcome Ankit.. keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

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

    Sir, you are awesome. Very good explanation. 👌👌

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

      thak hoyeche

  • @akakop
    @akakop 6 лет назад +10

    Sir pls make a video on how to find minimum no of tables for an er diagram type questions

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

    Concept is crystal and clear
    😌

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

      Glad you liked it, @harshavardhankakade9036. Stay connected & keep learning👍

  • @dheerajtiwari9923
    @dheerajtiwari9923 6 лет назад +3

    Nc lecture tdy. I'm waiting for next lecture..

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

    Such a wonderful explanation ❤️
    Love from Pakistan 🔥❤️🔥

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

      Thank you so much! Keep supporting & stay connected for more amazing contents👍😊

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

    At 11:30 it is said that every one to one is one to many or many to one ...... how can that be?? It can be agreed that every one to many or many to one is one to one!

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

    Sir, can you please make video on EER Model?

  • @yaad-e-madina4992
    @yaad-e-madina4992 3 года назад +3

    I need the examples of ERD but in play list there is no vedio 😑
    But your teaching method is amazing 👍👌
    Your examples are very simple and interesting
    In one day i understand ERD
    Jazakallah ❣

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

      Thanks a lot dear student.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

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

    sir superb vidoes..hats off to you..i have only one small doubt.. at 11:27 min ..you said every one to one is many to one or one to many...how is that possible sir...in many to one we will have one entity from one set which have relation with 2 or more entities in other set..while one to one it can have relations at most one..then how is that statement valid..i didn't get this only in whole lecture

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

      sorry in advance for my bad english.... in one to many u have one entity relating to 2 or more and in many to one u have 2or more entities relating to one ... so in every scenario ... one entity must relate to one entity... thus one to one exists in both of them....

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

    awesome series . Thank you so much

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

    just a reminder sir, you are awesome

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

      Thanks a lot dear for your generous words, keep learning & stay connected for more amazing contents👍😊

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

    14:12 since there are going to be multiple select questions in 2021, will we have to select all the 4 options ( 1:1 , 1:n , n:1 , n:m ), if the answer is (1:1) ??? can anyone expalin this...........

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

    'something'

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

    Sir u r the best😇 teacher 👍

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

      Thanks a lot dear yawar.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

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

    sir you are amazing teacher
    love from pakistan

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

    you have explained very well. can you please explain hashing in dbms..

  • @AhamedKabeer-wn1jb
    @AhamedKabeer-wn1jb 4 года назад

    Well explained...

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

    Bhut ache sir ji

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

    Recursive and none or zero is also part of the type of relationship of cardinality

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

    6:05 best action....

  • @ms.shivanithakur2841
    @ms.shivanithakur2841 10 месяцев назад

    Sir ye series complete krdo..aap bht acha krwate ho

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

    Ye dekhne ke bad 2008 ka GATE question clear ho gya, jo ab tak mujjhe galat lag rha tha. thanks

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

    What a teacher

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

    Video starts at 3:00

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

    Best lecture sir

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

      Thanks,Visit tiny.cc/yt_kgwebsite for more helpful content and courses👍

  • @NishaSharma-nd1dk
    @NishaSharma-nd1dk 3 года назад +1

    Thanks sir g

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

    wow sir, really concepts clear kr dete hain ap Puri tarah .... tq

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

    Nice sir🙏🙏

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

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

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

    Good job!

  • @rkstories-z2e
    @rkstories-z2e 6 лет назад

    Sir, your explanation is beautiful keep it up.. Group theory ke or parts kanha hai.... Homomorphism, quationt ratio etc

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

    thank you very much ! .

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

    I wish I could give 1000 likes to your video ♥♥♥♥

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

    Thank you so much sir for giving ur time to us by these awesome lectures
    U r a very good teacher ❤️
    May ur subscribers rise and rise more

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

    Op Explanation Sir ❤️❤️❤️❤️❤️❤️❤️

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

    thank you very much sir for this video

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

    sir aap ki wajah se bach gaye iss year.... uffff!!!!
    thank you so much...

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

    Sir DBMS ka practical tutorials bhi banaiye na.

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

    sir,
    Relational calculus peoblems are quitr tricky in dbms....
    Do make videos over problem solving of relational calculus....

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

    Dear Sanchit, Will u make the Videos on System Analysis And Design Concepts along with Programming Conceptson Java!

  • @SID-nh7gb
    @SID-nh7gb 6 лет назад

    Thanks

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

    sir u r best

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

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

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

      Sure sir i will definitely visit 🥰🤗

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

    thank you sir🙏

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

    Thanks!

  • @AbhishekKumar-rq4rt
    @AbhishekKumar-rq4rt 5 лет назад

    Thnku so much sir 🙏🙏

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

    chaliye shuru karte he

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

    Is this DBMS playlist cover all topics of GATE??

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

    Sir weak entity set and strong entity ka video dalo sir

  • @ashishpathak3980
    @ashishpathak3980 9 месяцев назад

    Sir if you continue creating such video one day you will be like physics wallah and unacadmy ❤❤

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

    Sir mapping constraints nd mapping cardinalitiea same hain ?

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

    What will be the cardinality for follower following system like in twitter? If I have 2 separate table for users and followers?

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

    sir please continue the er diagram lectures please

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

    Are these videos sufficient for preparation of gate ?

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

    Thxu sir!

  • @bossmemes3308
    @bossmemes3308 11 месяцев назад

    thankyou sir, just curious to know how the duster is getting attached to board?

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  11 месяцев назад

      Because its a magnetic duster for white board.

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

    GREAT

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

      Thank you! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

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

    hello sir,
    you content and method of explanation is very good but there is too much ads in video

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

    Thanx..

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

    What's the example for N:1(many to one).

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

    sir shayad apne 14:26 par galti se galat samja diya gaya kya ??
    kyuki m:m also 1:1 but vice versa is not possible take your adahar card exmple vo to galat hoga na plz sir explain
    aur agar ap rid karte ho to comment pin kar dena taki dusaro ko confusion na ho isi liye

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

      Dear Dhruv, we have checked it at our end, everything is fine in the video.

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

    Thanks sir😆

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

    Sir I am cs 1st year student and saw your lecture so how I have to prepare or make notes or how to make notes and similar query please make a vedio how I have study to crack gate

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

    Sir apne bola ki koi relationship 1 to 1 hai to wo many to many ho sakta hai... Par wo to aadhar card ki example me work nahi karta???

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

    Sir, great lecture as always but u have used Aadhar Number as an entity in your example that doesnt seem right to me. Aadhar Number can be an attribute of an indian citizen and not an entity

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

    Sr plzz upload reccurence relation and sequence sr

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

    great

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

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

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

    Exelant

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

    Jidhar n hota h....udhar arrow lgegaa naa sir?

  • @FarhanAhmed-cm2ry
    @FarhanAhmed-cm2ry 6 лет назад

    vip sir tusi great hooooooooooo

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

    आपका मतलब है वन टू वन relationship ko many to many bhi kaha ja sakta hai?

  • @riabhardwaj8
    @riabhardwaj8 5 лет назад +7

    Why is there no video on ER diag practice questions

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

      Haan sahi bole hai....yes sir plz make some practice vds

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

    Shouldn't mobile number be an attribute? in previous videos, mobile number was considered as an attribute (multi-attribute).

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

    strong and weak relationships?

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

    Some have 1:M, some have 1:N what is correct?

  • @Tprakh-iw6qt
    @Tprakh-iw6qt 6 месяцев назад

    Awesome

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

    Adhar number cannot be an entity, it is consider as attribute.. so please don’t write Adhar no as entity as students might get confused

  • @ch.ali7shahzad657
    @ch.ali7shahzad657 4 года назад

    J2EE k lectures plzzz

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

    Good 'ol days when Aadhar determined citizenship of an Indian 😂😣

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

    Can anyone tell me... How every one to one relation is many to one or one to many??

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

    Fnatic Ftw ❤️❤️❤️❤️❤️❤️❤️

  • @AmeerHamza-cy6km
    @AmeerHamza-cy6km 5 лет назад +1

    sir 1 to 1 jo he wo many to many nahi ho skta
    sirf many to many 1 to 1 ho skta he

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

    Every MANY to MANY can be ONE TO ONE but ONE to ONE can't be MANY to MANY
    I think he said the opposite...

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

      NO. every ONE TO ONE can be called many to many. But any MANY TO MANY can't be ONE TO ONE as it will violate the definition of ONE TO ONE.

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

    Sir your lecture is somehow missing something...like without explaining what is cardinality you started teaching cardinality mapping...you taught foreign key without explaining

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

    i see english words in the whiteboard, but listen tonguetwister... have any dubbed or subbed video?

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

    1 to 1 as in first example can not be one to many