Database Design 13 - One-to-Many Relationships

Поділитися
Вставка
  • Опубліковано 3 лют 2025
  • Start your software dev career - calcur.tech/de... 💯 FREE Courses (100+ hours) - calcur.tech/al...
    🐍 Python Course - calcur.tech/py...
    ✅ Data Structures & Algorithms - calcur.tech/ds...
    ~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
    ✉️ Newsletter - calcur.tech/ne...
    📸 Instagram - / calebcurry
    🐦 Twitter - / calebcurry
    🔗 LinkedIn - / calebcurry
    ▶️ Subscribe - calcur.tech/sub...
    👨🏻‍🎓 Courses - www.codebreakt...
    ~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
    ↪ My Amazon Store - www.amazon.com...
    🅿 Patreon - calcur.tech/pat...
    🅖 GitHub Sponsors - github.com/spo...
    Ⓟ Paypal - paypal.me/calcur
    🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
    🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
    📈 Buy Bitcoin - calcur.tech/cr...
    Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/cr...

КОМЕНТАРІ • 44

  • @MrMeisan123
    @MrMeisan123 8 років тому +51

    Dude, you could definitely get a teaching job if you wanted to.
    You're one of the best teachers i've ever had. You use humour, creativity, story-telling and you have a contagious enthusiasm for what you teach. Good stuff and more power to you

    • @VeraxMusic
      @VeraxMusic 7 років тому

      Yeah this guy is soooo much better than my professor.

    • @kenneh2198
      @kenneh2198 6 років тому

      Great!

  • @cameroncook313
    @cameroncook313 4 роки тому +1

    Crazy I enrolled in school, and my teacher is linking videos of you teaching to supplement our curriculum. Thank you so so so much for what you do.

  • @codebreakthrough
    @codebreakthrough  10 років тому +2

    New Database Design videos released!:
    One to Many Relationships - buff.ly/1nZSRrP (Start here if you are continuing the series)
    Many to Many Relationships - buff.ly/1nZSRrQ
    Designing One to One Relationships - buff.ly/1nZSRrR
    Designing One to Many Relationships - buff.ly/1nZSX2q
    Parent Tables and Child Tables - buff.ly/1nZSX2q
    Designing Many to Many Relationships - buff.ly/1nZSX2t
    Summary of Relationships - buff.ly/1nZSUDV
    Introduction to Keys - buff.ly/1nZSUDX
    Primary Key Index - buff.ly/1nZSUE1
    Look up Table - buff.ly/1nZSUE1
    Be sure to like them!

  • @codebreakthrough
    @codebreakthrough  10 років тому +1

    If you haven't seen the new Database Design videos, click below to start on video 13: One-to-Many Relationships. Please click "like" on the video!
    buff.ly/1nhhIXZ

  • @Totsy30
    @Totsy30 10 місяців тому

    Comparing the one to many to users and comments made the concept much more relatable and understandable.

  • @bablobko
    @bablobko 6 років тому +14

    This illustrates one user many comments.

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

    Bro, God bless you, helped me a lot than my professor!

  • @theavengedkoala211
    @theavengedkoala211 7 років тому +2

    These videos are really helpful, thanks for making these!

  • @JohnSmith-tz7iy
    @JohnSmith-tz7iy 9 років тому +35

    "OFF WITH THEIR HEADS"

    • @minhtao9774
      @minhtao9774 7 років тому

      Hahahah, that made me laugh hard outta no where!

  • @anilmaharjan1373
    @anilmaharjan1373 7 років тому +6

    your duster is awesome.. :)

  • @abhaykolhe8049
    @abhaykolhe8049 11 місяців тому

    this is what I was looking for

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

    Marriage examples were great way to illustrate this

  • @tushant04
    @tushant04 9 років тому

    What is the best database relationship design for rent and gallery ? Is it the best design that each rent has multiple images(living room, kitchen, bathroom) and each image will be associated to only one rent ?

  • @sheetaljaiswal2955
    @sheetaljaiswal2955 5 років тому +1

    Is one video posted on youtube and comments on it has one to many relationship..?? Correct me if I am wrong.

  • @amankumargiri3163
    @amankumargiri3163 7 років тому

    what will be the relationship between a table flights and table Fares

  • @laptopDoctorKZN
    @laptopDoctorKZN 7 років тому

    hey bud i enjoy your cources please can you do one in vb with a one to may
    ie . one customer may cars
    and how to edit and add cars ect

  • @asiasi354
    @asiasi354 8 років тому

    Hey Caleb ,
    First of all, thanks a lot for teaching this stuff, I love it!
    I have a question -
    If I've got two entities,
    And I want to connect their tables.
    Let's say I have these two tables "husband" and a "wife"
    Each husband can have only one wife, and each wife can have one husband
    (A One to one connection)
    How do I decide which one of them will hold the PK and which of them
    will have the FK of the other?
    If each of the tables will have a row of an entity with the FK of its pair,
    won't that cause an integrity issue?(like if I update only the wife with the
    new husband , but I forget to update it on the husband table ….)
    Or should I use a look up table
    to pair them together.
    Sorry if you already explained that and I missed it .
    Thanks a lot and keep up the good work, it's much appreciated J

  • @mangofreak567
    @mangofreak567 9 років тому +2

    nice vids

  • @angelicaaragon9768
    @angelicaaragon9768 5 років тому +1

    Thank you Caleb, you're an amazing teacher and you're super cute too

  • @islombekmamatqulov6896
    @islombekmamatqulov6896 4 роки тому

    just perfect

  • @salvagarcia6084
    @salvagarcia6084 6 років тому

    Man, with that example, you have walked into a mine field. Good luck

  • @jeewanintube
    @jeewanintube 8 років тому

    Does "many to one relation exist"I?
    If yes does "one to many" and "many to one" relation similar?

    • @codebreakthrough
      @codebreakthrough  8 років тому +2

      I think the names could be used to describe the same thing, just flipping the direction.

  • @shlomopfeuffer9288
    @shlomopfeuffer9288 7 років тому +1

    You realy need to get a white board

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

    Dude, please how do I implement these

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

      Use lucidchart

  • @mindfreakmovies9586
    @mindfreakmovies9586 5 років тому

    Why wet portion looks like sparrow head?

  • @segorbejose5229
    @segorbejose5229 9 років тому +1

    for me, he is the best. thanks for help us!

  • @emberafterglow4916
    @emberafterglow4916 4 роки тому

    Like this one, and .....

  • @vonBRS
    @vonBRS 9 років тому +1

    LOL AT SAM

  • @bablobko
    @bablobko 6 років тому +1

    I am commenting multiple comments, this is 2nd.

  • @FagbenroAbdullateef
    @FagbenroAbdullateef 10 років тому +1

    morning your lectures have helped me alot but am sincerely having problem to solve a one to many question hope you don't mind if you help me with your e-mail in order for me to mail it to you

  • @emberafterglow4916
    @emberafterglow4916 4 роки тому

    I make this one too. But all of these comments I have made are all made from my one and only user account. So my 1 user account has posted 3 comments. This is a one to many relationship.

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

    The third wife has no hands.. just saying

  • @eriic504
    @eriic504 5 років тому +1

    Did he say "How many wife you desire" ?

  • @emberafterglow4916
    @emberafterglow4916 4 роки тому

    I can make tons of comments.

  • @bablobko
    @bablobko 6 років тому +1

    I am commenting multiple comments, this is 3rd

  • @bablobko
    @bablobko 6 років тому

    .
    .
    .
    .

  • @bablobko
    @bablobko 6 років тому +1

    I am commenting multiple times, this is the nth comments

  • @bablobko
    @bablobko 6 років тому +1

    I am going to make many comments, this is the first.

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

    3:30
    I'm muslim and i feel offended
    delete this now