Database Design 18 - Designing Many-to-Many Relationships

thank you so much for the effort, still useful after 8 years

Thanks for the video
My question is will the intermediary table have a primary key and if it does what do you suggest it is for the example you used

thank you!!

does row in Intermediary table will have ID ?

You’re genius in teaching. Literally i learned a lot from you.

I'm working on Apex, so can I assume intermediary table as a view in Apex? so I can build 2 separated tables and connect then together by a view??

Wow...

You've changed so much in 6 years XD

70 Claires clicked thumbdown lol

But if we get rid of John - then does all his information delete?

Wait wait wait

Classes/class students/students

Everything gets id’s/👌🏽

😂

👌🏽

Foreign keys?

Class students?

3 tables?

Should I be watching in order?

Database design 18? So there’s 17 more videos 👀

Thank you for the video- I subscribed over one year ago- and my professor added you as a example in our class- thank you so much for the video- thank you for being smart!

"Not Claire!" lol

thanks mate you are a life saver

I think I get it.

In a many to many situation a student can follow the same course twice or more.

So we make a third table with the PK from the two table to prevent that ?

I don't get it...why can't we just write many to many...M:M ? N for many is so dull 😄

Why not Claire?

I LOVE your videos! So helpful and love the humour too!

Long but interesting video.

Do you need to give primary key to the rows of junction table?

Great explanation, thank you.

this was before you hit puberty lol

I am exactly like you. You are exactly like me. Your way of speaking and goofy funny ways. I really identify with you. I am left handed and my hand writing looks exactly like yours. I think it is so cool that you made this video so long ago and you are so young. (I feel old now) Great Job on this entire series!!!!!! You are some one I look up to for the way you just get up there and speak off the cuff and from your actual knowledge. You Rock!!

Thank you sooooooooo much! my professor never taught me how to handle this many to many. She just said nah having many to many in your ER D is not good ...

Guys I need to confess right here right now.
I love to read Comments Section, especially this vid in this series.

Thanks past Caleb Curry, may the force with you.

After 5 hours searching, finally I found the best explanation! Thanks Caleb

Thank you Caleb.

I cannot thank you enough .. After 5 years still useful content ..

I was doing ER diagrams, after watching this it clicked fully. I think what did it for me was the real life example.

This was very helpful. My question was actually, in the case of me making a database that stores different shows that i have watched, I wanted to know how I can give each show in the database multiple genres without having null values in some of the columns, the intermediary table solves that perfectly. thank you Caleb

Why I Came: my professor told us to so my class could understand this concept.
Why I Stayed: Caleb is adorable and dorky.

Clear and Simple,keep it up :)

It's funny because classes are classes so students are objects. You're OBJECTIFYING students!

Parent vs Parent complication concept is very approachable. Thank you Caleb. btw, 2018 here?

Thank you so much for this!! I'm a front end developer who just got a back end based code challenge and this was a wonderful jumping off point.

Very helpful

Thank you!! (sorry about Claire)

I still can't believe how much more I'm learning here compared to my instructor in my db design course.
Thank.
You.
Good.
Sir.

Finally I am not sleeping during learning. Thank you.