Question 3 Please!!

Use the columns to determine which tables you will need in your database. Please remember that one order can have multiple products and that a product may be in multiple orders. I suggest creating a table called OrderedProduct with a composite (2 column PK) for this.

Draw and submit the ERD with the 4 tables and all columns in each table. You only need to submit the ERD. It can be drawn in Visio, draw.io, or by hand.

office supplies, therapy CRITICAL T THINKING therapist handles each therapy (a therapist UITM sessions listed in Exercise 1. list the ID. last name, and first name ole 3. Sports Physical Therapy has a list of approve hysical Therapy has a list of approved vendors who supply things such as office supplies, the tools, towels, and wraps. Design a database to meet the follow Design a database to meet the following requirements: " ress. city, state, zip code, telephone number a. For each vendor, list the vendor ID number, vendor name, address, and type of supply provided. For each supply, list the product number (UPC or SKU), product name, description, vendor ID number quantity, and price. c. For each order, list the product number, product name, vendor ID number, quantity, total price, date ordered, and expected date of arrival. office supplies, therapy CRITICAL T THINKING therapist handles each therapy (a therapist UITM sessions listed in Exercise 1. list the ID. last name, and first name ole 3. Sports Physical Therapy has a list of approve hysical Therapy has a list of approved vendors who supply things such as office supplies, the tools, towels, and wraps. Design a database to meet the follow Design a database to meet the following requirements: " ress. city, state, zip code, telephone number a. For each vendor, list the vendor ID number, vendor name, address, and type of supply provided. For each supply, list the product number (UPC or SKU), product name, description, vendor ID number quantity, and price. c. For each order, list the product number, product name, vendor ID number, quantity, total price, date ordered, and expected date of arrival