Discover answers to your most pressing questions at Westonci.ca, the ultimate Q&A platform that connects you with expert solutions. Discover the answers you need from a community of experts ready to help you with their knowledge and experience in various fields. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

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?

Sagot :

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.