RELATIONSHIP AND TYPES OF RELATIONSHIPS IN DBMS || ONE TO ONE || ONE TO MANY || MANY TO MANY

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 ส.ค. 2022
  • RELATIONSHIP IN DBMS
    Relationship is used to relate different tables in RDBMS
    TYPES OF RELATIONSHIPS
    1) One to One Relationship
    * One record of Table-1 is relates to One record of Table-2 and vice-versa.
    2) One to Many Relationship
    * One record of Table-1 is relates to Multiple records of Table-2 and One record of Table-2 relates to Only One record of Table-1.
    3) Many to Many Relationship
    * One record of Table-1 is relates to Multiple records of Table-2 and vice-versa.
    --------------------------------------------------------------------------------------------------------
    DATABASE MANAGEMENT SYSTEM
    • DATABASE MANAGEMENT SY...
    PYTHON PROGRAMS
    • PYTHON PROGRAMS
    C PROGRAMMING
    • 01 - VARIABLES & CONST...
    CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
    • CORE JAVA TUTORIAL FOR...
    HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
    • HTML TUTORIALS WITH IM...
    LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
    • LEARN CSS IN 3 HOURS |...
    JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
    • JAVA SCRIPT FOR BEGINN...
    PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
    • PYTHON TUTORIAL FOR BE...
    PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
    • PYTHON - OOPS CONCEPTS...
    PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
    • PYTHON NUMPY TUTORIAL ...
    PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
    • PYTHON PANDAS TUTORIAL...
    MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
    • MATPLOTLIB LIBRARY - P...
    PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
    • PYTHON DATABASE CONNEC...
    DATA STRUCTURES USING PYTHON (ENGLISH)
    • DATA STRUCTURES USING ...
    ----------------------------------------------------------------------------------------------
    Instagram : / sundeepsaradhikanthety

ความคิดเห็น • 24

  • @saicharanchepuri8145
    @saicharanchepuri8145 9 หลายเดือนก่อน +2

    A great explanation of relationships and cardinalities, Sir. Thank you.

  • @sanjanasomika5953
    @sanjanasomika5953 ปีที่แล้ว

    Awesome explaination sir 🙏

  • @abubakarizhar5608
    @abubakarizhar5608 2 หลายเดือนก่อน

    Very well description. Lots of likes.

  • @nagateja9554
    @nagateja9554 ปีที่แล้ว +1

    greatest video about relationships.

  • @satyanagavinaypathada32
    @satyanagavinaypathada32 ปีที่แล้ว +2

    Nice explanation sir ... Thanks a lot

  • @ganeshjaggineni4097
    @ganeshjaggineni4097 ปีที่แล้ว +1

    NICE SUPER EXCELLENT MOTIVATED

  • @oyimangtatin2038
    @oyimangtatin2038 9 หลายเดือนก่อน

    Superb explanation sir.. thank you so much 🙏

  • @murugaperumal2819
    @murugaperumal2819 11 หลายเดือนก่อน

    Excellent teaching sir🙏

  • @Nurukkan
    @Nurukkan ปีที่แล้ว +2

    Thank you much sir♥️

  • @user-hl4kn7pe8r
    @user-hl4kn7pe8r 3 หลายเดือนก่อน

    Great explanation 🥰.
    Sir tnx

  • @oluwatuyiayomide5385
    @oluwatuyiayomide5385 ปีที่แล้ว

    This is very satisfying

  • @suyashshrouti
    @suyashshrouti 5 หลายเดือนก่อน +1

    Thank you sir

  • @Anelka465
    @Anelka465 22 วันที่ผ่านมา

    Master

  • @fog2640
    @fog2640 10 หลายเดือนก่อน

    finished watching

  • @annadurai375
    @annadurai375 ปีที่แล้ว

  • @G_Kaur_Ramgrdiya
    @G_Kaur_Ramgrdiya 4 หลายเดือนก่อน +2

    Thanks sir

    • @Maria_farah
      @Maria_farah 4 หลายเดือนก่อน +1

      happy that i find someone we are taking this course same time. wish you luck

  • @anushagarige5581
    @anushagarige5581 ปีที่แล้ว

    Sir make a video about how to write queries sir please!!

  • @lias3968
    @lias3968 ปีที่แล้ว

    Sir ,how does s2 come to c1 c3 c4 and s3 come to c3 c4 and so come to c1 yet both of them match to both records.

  • @PoorBoys201
    @PoorBoys201 ปีที่แล้ว

    how this relationships topic helped in real time work

  • @koushikmv310
    @koushikmv310 4 หลายเดือนก่อน

    In exam we write only this is enough sir for 6 marks

  • @VijayKumar-im1bs
    @VijayKumar-im1bs ปีที่แล้ว

    sir there is no many to one relationship?🤔

  • @Vamshi_Kanna_official
    @Vamshi_Kanna_official ปีที่แล้ว

    Sir my doubt is many to many examples cheparu kada
    S1------>C1 C2 C3 C4
    S2------->C1 C2 C3
    S3--------> C3 C4
    S4--------->C1 ani and tablet 2 dhi kuda C1 C2......ect avi ala ochai sir could you please tell me

    • @rollasrinivasarao642
      @rollasrinivasarao642 ปีที่แล้ว +3

      one student can take mutliple subjets
      at the same time
      multiple subjets have for eah student