From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Develop relationships

Develop relationships

From the course: Learning Relational Databases

Start my 1-month free trial

Develop relationships

- [Tutor] Now that our fields are organized by subject, we should have a good understanding of all the tables that will need to be created in the database in order to satisfy our mission objectives. Additional tables will be required by the DBMS to operate efficiently, but we'll identify those more thoroughly in the next chapter. The next stage is to begin hooking our tables together in a series of relationships. To do this, we'll evaluate each of our tables against every other table, and ask if there's an association between the entities. In making this determination, it's often helpful to try and verbalize the relationship. For instance, when comparing the Employees table to an Invoice table, you might say that the employee assists with an invoice, or that an invoice is created by an employee. If you were to compare the Invoices with the Line Items table, you might realize that invoice is made up of line items, or that a line item appears on an invoice. These types of sentences…

Contents