Question

Bob sells the vegetables he grows in a farmer's market. Bob is a little disorganized and has been looking for a good way to track his sales. If Bob creates a database to track the sales of vegetables, what is the appropriate relationship between orders and products?

Answer 1

Answer:

The appropriate relationship between orders and products is a one-to-many relationship.

Explanation:

A one-to-many relationship simply means that one order by a customer can be for many products, vegetables in this instance.  When Bob receives a customer's order for products, the customer may order more than one type of vegetables because customers buying vegetables always love variety.  Therefore, the database to track the sales of vegetables may need to track one order to various datasets containing the customer's order.