Page 4 of 12PREVNEXT

Create relationships for a new database

table on one side and table on many side


At this point, it helps to think of relationships has having “sides.” For example, one supplier can provide many assets, so the Suppliers table resides on the "one" side of the relationship, while the Assets table sits on the "many" side, and the picture shows this.

Next, remember this rule: To create a one-to-many relationship, you use the primary key from the table on the "one" side as a foreign key in the table on the "many" side, and you’ll see how to do that next.

The same rule applies to one-to-one and many-to-many relationships, but not in quite the same way, so we’ll look at those later in this course. For now, keep the idea of “sides” in mind, and the video in the next section will show you how to create a relationship.

Page 4 of 12PREVNEXT