previous | index | next

Foreign Keys

The information about the customer and salesperson should not repeat the information in the customer and salesperson tables.

So, we use the customer ID and salesperson ID in the Order Table.

Since these columns reference keys in other tables, they are called foreign keys.


previous | index | next