Design the order_lines table for order line items. It needs id as the primary key, required order_id referencing orders(id), and required qty; the database must not allow a line item for a missing order.