Question: Can you please add these data and show steps (this is for adding data only without creating the table) Employee (Note: Attribute names are abbreviated
Can you please add these data and show steps (this is for adding data only without creating the table)
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 |
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 |
Complete the following tasks:
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;)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
