Archer Solutions needs to store the following data about customers and sales in a relational database:

Product ID Order date Customer ID Customer address Customer name Customer phone Selling price (per unit) Quantity sold Purchase order number Product description Salesperson ID Salesperson name Salesperson commission rate

You are an intern at a local CPA firm. You have been asked by your supervisor to illustrate relationships and field names for these tables in a relational database. You must also identify the primary keys and foreign keys that relate the tables. You may add additional field names, as necessary. For example, salesperson would have a first name and a last name.