Schema:
Customer(CustNo, FirstName, LastName etc..)
Order(OrderNo, CustNo, DatePlaced, etc..)
OrderLine(OrderNo, ProductID, Quantity, TotalPrice)
Products(ProductID, Name)
I'm trying to figure out how to implement a product with different options to it. Say a customer orders an ice cream. But they have the option of chocolate topping or strawberry topping. How would I see this in the Orderline table? How would I add this as a Product? What do I need to add? Thanks