Please create the tables and insert the data into the tables with explaination.

Employee (Note: Attribute names are abbreviated to fit into the table columns)

Emp_ID	E_LName	E_Fname	E_St_Addr	E_St_Nm	E_City
E509	Jones	George	123	West Elm	Greeley
E302	Hayes	Marilyn	456	S Main	Newark
E244	Walker	Shondra	789	35th Ave	San Diego
E651	James	LaBron	321	123rd Street	Cleveland

Employee (Cont.)

E_St	E_Zip	E_Job_Cd	E_Pay_Rate	E_St_Date	Warehouse_ID
CO	81001	100	45000	05/20/2020	10
NJ	12003	200	95000	04/15/2017	10
CA	90121	400	85000	08/09/2015	20
OH	34508	400	120000	11/11/2020	20

Complete the following tasks:

Use SQL Developer to enter the Create Table statements into the AWS Oracle database instance. Be sure to include ALL tables mapped from your UML Class diagram. Provide a screenshot of every create table statement and the resulting Table Created output in SQL Developer.

Include your name, the Instructors name and the date as a comment on each screen shot.

Use SQL Developer to create SQL insert commands to insert 46 data items into each table. Be sure to verify all referential (FK) integrity constraints in tables on the many side of all one to many relationships. Do not include screen shots for the insert commands.

Note:

You must include at least two Orders that have been placed by the Customer but not shipped, at least two Orders that have been shipped but not delivered, and at least two Orders that have been delivered.

At least four of the Orders must include more than one product.

Use SQL Developer to show all the data inserted into the tables using the Select * SQL command for each table you created. Provide a screenshot of every select statement and the resulting output in SQL Developer.

(e.g., Select * From Orders:)

Use SQL Developer to show the successful insertion of all foreign key attributes by executing a SQL Natural Join statement to show the successful linking of all tables included in one to many relationships. Provide a screenshot of every select statement and the resulting output in SQL Developer.

(e.g., Select * From Customer natural join Orders; Select * From Orders natural join Order_Line natural join Products;)