Wholesale Club is a Canadian wholesaler of food for retailers in most Canadian regions and cities. Wholesale Club buys its products directly from manufacturers and farmers, and then resells them to individual retail stores and end-user consumers in the region. The table on the nest page contains raw information related to ordering and purchasing products and items from suppliers. Review the data and answer the questions that follow.

1. What is the main problem with the information presented in the table? How should this problem be solved? (5 marks)
2. Design the relational tables necessary to solve this problem. (15 marks)
3. Identify the primary key for each table as well as the foreign keys needed in the tables to implement referential integrity. (5 marks)

Purchase Order #	Purchase Order Date	Product #	Description	Unit Price	Quantity Ordered	Vendor #	Vendor Name	Vendor Address
5	3/9/18	334	XYZ	$30	3	204	FK Supply	107 Fairmont Dr.
5	3/9/18	231	PDQ	$50	5	204	FK Supply	107 Fairmont Dr.
5	3/9/18	444	YYM	$80	6	204	FK Supply	107 Fairmont Dr.
3	4/5/18	231	PDQ	$50	2	689	Norman Inc.	56 Main Street
3	4/5/18	241	XWZ	$80	4	689	Norman Inc.	56 Main Street
3	4/5/18	261	XYZ	$90	3	689	Norman Inc.	56 Main Street