Q1: Create relational tables that solve the update, insert, and delete anomalies in Table 4-17. Create all the relational tables with PK, FK (labeled) and with the records for each table.

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

TABLE 4-17

Invoice #	Date	Order Date	Customer ID	Customer Name	Item#	Description	Quantity
52	6-19-18	5-25-18	201	Johnson	103	Trek 9000	5
52	6-19-18	5-25-18	201	Johnson	122	Nimbus 4000	8
52	6-19-18	5-25-18	201	Johnson	10	Izzod 3000	11
52	6-19-18	5-25-18	201	Johnson	71	LD Trainer	12
57	6-20-18	6-01-18	305	Henry	535	TR Standard	18
57	6-20-18	6-01-18	305	Henry	115	NT 2000	15
57	6-20-18	6-01-18	305	Henry	122	Nimbus 4000	5

Prepare the tables after the 3NF and input the records in each table. The template for table is below:

TABLE Name

(PK)			(FK)