I have an order table that is an order for a customer. I need to reference as a foreign key an unknown number of products that could make up the order (product_id) how do I do this? What am I missing.

1. When you start designing your database. It's implicit. It's only a process of reshuffling if you come to a bad designed database. 2. ? 3. You have a table (relation) with Instructors for their rows ...