Indexes

All primary and foreign key columns in ACME are indexed. All indexes are prefixed with IDX.

Note 

Indexes on the foreign keys are unnecessary and even ineffective for a database of this size, but we created them anyway, as if we are working with a huge database with thousands of customers and millions of orders.