Diagram a relationship

- [Instructor] Let's go back to our database diagram … and hook these to tables together … with a formal relationship. … I'm continuing on from the last chapter, … but if you need the text that I have … on the left side of my screen … that builds the Products and Suppliers table, … then you can find that text … in the exercise files for this course. … To create a relationship … between the Products table and Suppliers table, … we first need to identify what columns … we'll join together. … First, let's think about the direction … of the relationship. … Does it make more sense that each, individual … product has multiple suppliers? … Or that each, individual supplier … sends us multiple products? … I think the latter makes sense … in a typical business, … so I'm going to join the primary key … from the Suppliers table to the Products table. … But what field should it connect to over here? … We currently have a supplier field … that's storing a "varchar100" data type. … This is a text data type …