Relational Database and Active Record Basics

  • can have many songs
  • can have many genres
  • can have only one Artists
  • can have many genres
  • can have many songs
  • can have many artists
This doesn’t work! We cannot add a new column every time we need to add a new song to an artist.
The correct way — the child always has the parent ID
A join table that lists the primary ID’s of instances of Genres and Songs

--

--

--

Product at Policygenius. Previously @ NBC News, AMC Networks, and Fueled.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jasper Curry

Jasper Curry

Product at Policygenius. Previously @ NBC News, AMC Networks, and Fueled.

More from Medium

An Introduction to Virtual Environments for Beginners

Creating a Book Class 📚

Intro to NumPy | Why to learn NumPy | NumPy Creating Arrays

Building ML Models in the Cloud with SAS Viya

Sas Viya with Bubble Tea