Another get-to-know-each-other

Please get into groups of 3-4 (ideally, with people you haven't done one of these with before) and share one of the following:

  • What’s the last thing you bought yourself?
  • What would your best friend say about who you are and what makes you tick?
  • What is something adventurous that you’ve done?
  • Is there something that you’ve dreamed of doing for a long time? Why haven’t you done it?
  • Who or what do you turn to when you need to recharge?

What are the associations?

  • Cities and Neighborhoods
  • Courses and Students
  • Photographers and Photos
  • Bands and Venues
  • Contractors and Clients
  • States and Senators
  • Groups and Members

One-to-Many or Many-to-Many?

When you're deciding, ask yourself:

  • Can one x have many y?
  • Can one y have many x?

The answer is usually: it depends on what you're building. Justify it.

If One-to-Many, which table gets the foreign key column?

If Many-to-Many, what’s a good name for the join table?

<iframe src="https://pollev-embeds.com/multiple_choice_polls/EZ7zocA9OTRhXUXdRFFIO/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/y65QlOc45oOKvXqdk6HTG?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/7nfYbTGYvPT0GQssWeXeV/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/PTaBsexgqtfDUr8lh9RCH?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/discourses/tv5wQuT17rKCLGRfWzOy0/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/discourses/Cjb0EcGucIGM5nHkhAsCY?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/gwMHnYTWJSHPeXpcEBjjX/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/zZlRgj6dbIPzaEIIw513k?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/discourses/mUyiEthPTNKB5yxSHLmwV/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/discourses/WlWo0xn43QsQ9Mp8fHNjh?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/d4b6DU2IkZAttZKgwwtEg/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/9K1OQr0H1Mgr7urHU7Ipp?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/tS24tDkkPKORSsqmUcMyX/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/BXLo5Uky5aIzqxSVUzdg1?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/EHmgM9p6fwIciNtrAowxu/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/puR1lLQEAt4PYln3SNGVU?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/discourses/Alw1GqvFoNjWytlKDxI7c/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/discourses/oCuBd1qZX0zDrD61rPL1c?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/SHLVnmYmsUBl14Z0X5Uqk/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/IBzmcUKoTW7fT73gJeBga?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/discourses/ADKsPr11sonL0DMdBqmTz/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/discourses/umggnLXJVdRhLS4y8Bhef?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/rA5r4Z1JgxSDeVxgUoqTz/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/iDEjVJLN8xaZ3CgNR2X9X?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/multiple_choice_polls/ViNZ7TD0ln9YpnUSv0tGh/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/multiple_choice_polls/eUHbv8JNRDAzt0M5tEejf?controls=none&short_poll=true" width="800px" height="600px"></iframe>
<iframe src="https://pollev-embeds.com/discourses/aSuBBvRRIY4Fb7UryzIXP/respond" width="800px" height="600px"></iframe>
<iframe src="https://embed.polleverywhere.com/discourses/W3r93G1b2XrFydUmDC3ft?controls=none&short_poll=true" width="800px" height="600px"></iframe>

POLL

Cities and Neighborhoods

RESPONSES

Cities and Neighborhoods

POLL

If we model Cities and Neighborhoods as a one-to-many, which table would you add a foreign key to?

RESPONSES

If we model Cities and Neighborhoods as a one-to-many, which table would you add a foreign key to?

POLL

If we model Cities and Neighborhoods as a one-to-many, which table would you add a foreign key to?

RESPONSES

If we model Cities and Neighborhoods as a one-to-many, which table would you add a foreign key to?

POLL

Courses and Students

RESPONSES

Courses and Students

POLL

If we model it as a many-to-many, can you think of a good name for the join table between courses and students?

RESPONSES

If we model it as a many-to-many, can you think of a good name for the join table between courses and students?

POLL

Photographers and photos

RESPONSES

Photographers and photos

POLL

If we model Photos and Photographers as a one-to-many, which table would you add a foreign key to?

RESPONSES

If we model Photos and Photographers as a one-to-many, which table would you add a foreign key to?

POLL

Bands and Venues

RESPONSES

Bands and Venues

POLL

If we model it as a many-to-many, can you think of a good name for the join table between bands and venues?

RESPONSES

If we model it as a many-to-many, can you think of a good name for the join table between bands and venues?

POLL

Contractors and Clients

RESPONSES

Contractors and Clients

POLL

If we model it as a many-to-many, can you think of a good name for the join table between contractors and clients?

RESPONSES

If we model it as a many-to-many, can you think of a good name for the join table between contractors and clients?

POLL

States and Senators

RESPONSES

States and Senators

POLL

Groups and members

RESPONSES

Groups and members

POLL

If we model it as a many-to-many, can you think of a good name for the join table between groups and members?

RESPONSES

If we model it as a many-to-many, can you think of a good name for the join table between groups and members?