Solution: Create an Intersection Table
Let's devise a solution for Jaywalking by creating an intersection table.
Instead of storing the account_id
in the Products
table, we can store it in a separate table, so each individual value of that attribute occupies a separate row. This new table Contacts
implements a many-to-many relationship between Products
and Accounts
:
Create a free account to view this lesson.
By signing up, you agree to Educative's Terms of Service and Privacy Policy