Goal of the assignment is to create the beginnings of a database from given information. You are provided with the following data points about a customer and their orders: Customer Last Name Customer First Name Customer Middle Name Suffix Phone Email Address First seen Date Customer Address Street1 Customer Address Street2 Customer Address City Customer Address State * * Customer Address Zip Customer Address Last Modified Date Order Number List Price (MSRP) Sell Price Sell Date Ship Date Directions: 1. Normalize the data to 3NF (Hint-there should be 3 tables) 2. Create an ER diagram for Step 1 3. Write the SOL code to create the tables in Step 2. Remember about your constraints (PK, FK, Unique, etc.) and execute it in Oracle. 4. Write the SOL code to Insert at least 5 rows of data into each table you create and execute it in Oracle. Please upload the following (SOL code and screenshots can be placed in a doc file): 1. Screen shot of your ER Diagram (can also be uploaded as a separate file if you wish) 2. Copy and paste your SQL code for the table creation based on the ER Diagram you created. 3. Screen shot of the results of the following command: SELECT table_name FROM user tables 4. Screen shot of the results of running t 5. Copy and paste your SQL code for the data insertion into the tables. 6. Screen shot of the results of SELECT from each table. 7. Screen shot of the Oracle output that shows the constraints on each table. he DESC command on each table. Goal of the assignment is to create the beginnings of a database from given information. You are provided with the following data points about a customer and their orders: Customer Last Name Customer First Name Customer Middle Name Suffix Phone Email Address First seen Date Customer Address Street1 Customer Address Street2 Customer Address City Customer Address State * * Customer Address Zip Customer Address Last Modified Date Order Number List Price (MSRP) Sell Price Sell Date Ship Date Directions: 1. Normalize the data to 3NF (Hint-there should be 3 tables) 2. Create an ER diagram for Step 1 3. Write the SOL code to create the tables in Step 2. Remember about your constraints (PK, FK, Unique, etc.) and execute it in Oracle. 4. Write the SOL code to Insert at least 5 rows of data into each table you create and execute it in Oracle. Please upload the following (SOL code and screenshots can be placed in a doc file): 1. Screen shot of your ER Diagram (can also be uploaded as a separate file if you wish) 2. Copy and paste your SQL code for the table creation based on the ER Diagram you created. 3. Screen shot of the results of the following command: SELECT table_name FROM user tables 4. Screen shot of the results of running t 5. Copy and paste your SQL code for the data insertion into the tables. 6. Screen shot of the results of SELECT from each table. 7. Screen shot of the Oracle output that shows the constraints on each table. he DESC command on each table
