Pro exercise

Two-level referential integrity

Sales point to products, and products point to categories. Follow both links to attach the department, and report a sale whose product is unknown separately from one whose product points to a category that doesn't exist.

joins
referential integrity
lookups