Question: Based on the information provided from the below table, I need assistance in normalising and creating an ERM-creating tables in Oracle and populating the

Based on the information provided from the below table, I need assistance

Based on the information provided from the below table, I need assistance in normalising and creating an ERM-creating tables in Oracle and populating the data from the below table. Sales Person No Sales Person Year of Department Manager Product Name Hire No Name No Product Unit Name Quantity Price 101 Cookie Biscuit 1995 10 Almond 19440 Sugar $ 5.50 100 101 Cookie Biscuit 1995 10 Almond 24013 Milk $ 2.85 200 101 Cookie Biscuit 1995 10 Almond 26722 Oil $ 1.50 300 102 Sweet Candy 1998 102 Sweet Candy 1998 102 Sweet Candy 1998 2220 Kit Kat 19440 Sugar $ 5.50 100 Kit Kat 24013 Milk $ 2.85 500 Kit Kat 25410 Pecan $ 3.00 800 103 Chocolate Milk 2001 10 Nuts 25940 Chocolate $ 7.00 200 103 Chocolate Milk 2001 10 Nuts 26722 Oil $ 1.50 500 104 Cherry bar 2005 10 Almond 25940 Chocolate $7.00 100 104 Cherry bar 2005 10 Almond 25410 Pecan $ 3.00 700 104 Cherry bar 2005 10 Almond 26722 Oil $ 1.50 950 Please complete the following: a) Create an ERM diagram b) List the DDL statements to create tables in Oracle. c) List the DML statements (i.e., INSERT) to populate data to the created tables in (b)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!