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

Поділитися
Вставка
  • Опубліковано 18 жов 2024
  • 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 in One Shot(తెల...
    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

КОМЕНТАРІ • 25

  • @arjung7059
    @arjung7059 Місяць тому +1

    Very thanks to good explanation very great sir❤

  • @saicharanchepuri8145
    @saicharanchepuri8145 Рік тому +3

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

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

    greatest video about relationships.

  • @oyimangtatin2038
    @oyimangtatin2038 Рік тому

    Superb explanation sir.. thank you so much 🙏

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

    Nice explanation sir ... Thanks a lot

  • @abubakarizhar5608
    @abubakarizhar5608 5 місяців тому

    Very well description. Lots of likes.

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

    NICE SUPER EXCELLENT MOTIVATED

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

    Thank you sir

  • @SolyTesfa
    @SolyTesfa 6 місяців тому

    Great explanation 🥰.
    Sir tnx

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

    Thank you much sir♥️

  • @murugaperumal2819
    @murugaperumal2819 Рік тому

    Excellent teaching sir🙏

  • @G_Kaur_Ramgrdiya
    @G_Kaur_Ramgrdiya 7 місяців тому +2

    Thanks sir

    • @Maria_farah
      @Maria_farah 7 місяців тому +1

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

  • @sanjanasomika5953
    @sanjanasomika5953 Рік тому

    Awesome explaination sir 🙏

  • @oluwatuyiayomide5385
    @oluwatuyiayomide5385 Рік тому

    This is very satisfying

  • @Anelka465
    @Anelka465 4 місяці тому

    Master

  • @fog2640
    @fog2640 Рік тому

    finished watching

  • @anushagarige5581
    @anushagarige5581 Рік тому

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

  • @PoorBoys201
    @PoorBoys201 Рік тому

    how this relationships topic helped in real time work

  • @annadurai375
    @annadurai375 Рік тому

  • @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.

  • @koushikmv310
    @koushikmv310 7 місяців тому

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

  • @VijayKumar-im1bs
    @VijayKumar-im1bs Рік тому

    sir there is no many to one relationship?🤔

  • @Evergreen_vamshi_kanna
    @Evergreen_vamshi_kanna 2 роки тому

    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 Рік тому +4

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