Create relational tables that solve the update, insert, and delete anomalies in the table below

(To avoid the update, insert, and delete anomalies, four separate relational tables are created).

Label Primary and Foreign Keys.

Note: Table provided are to aid in organization you may not use all columns and or rows for each table

Create relational tables that solve the update, insert, and delete anomalies in the table below.

(To avoid the update, insert, and delete anomalies, four separate relational tables are created)

Note: Table provided are to aid in organization you may not use all columns and or rows for each

Purchase Order #	Purchase Order Date	Part #	Description	Unit Price	Quantity Ordered	Vendor #	Vendor Name	Vendor Address
2	3/9/18	334	XYZ	$30	3	504	KL Supply	75 Stevens Dr.
2	3/9/18	231	PDQ	$50	5	504	KL Supply	75 Stevens Dr.
2	3/9/18	444	YYM	$80	6	504	KL Supply	75 Stevens Dr.
3	4/5/18	231	PDQ	$50	2	889	Oscan Inc	55 Cougar Cir.

Table 1: