Based on the information provided from the below table, I need assistance in normalising and creating...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg
Posted Date:
Students also viewed these programming questions
-
QUESTION 2 (35 MARKS) ALERT Boxes is a manufacturing firm that produces boxes and wholesales them to distributors. All the boxes are produced and sold in the same month. The selling price of each...
-
1. Based on the information provided in the case below, what is the key strategic goal for Tim Hortons as of August 2014? It would be a year of dramatic change for Tim Hortons Inc. On August 26,...
-
The Brown-Forman Cooperage in Louisville Kentucky (USA) supplies flame-charred white-oak barrels for the aging processes of various bourbon and whiskey products produced under the Brown-Forman...
-
If a check correctly written and paid by the bank for $ 648 is incorrectly recorded on the company's books for $ 684 , the appropriate treatment on the bank reconciliation would be to THE ANSWER IS...
-
If a machine had a cost of $4,000 with an accumulated amortization of $1,000, what would be its book value?
-
Refer to problem 3-37. Prepare a balance sheet as of November 30, 20X0, and an income statement for the month of November. Prepare the retained earnings column of a statement of stockholders' equity....
-
Port Oil Corporation uses the successful efforts method. Recently, the company acquired a truck costing $60,000 with an estimated life of five years (ignore salvage value). The foreman drives the...
-
Werner Pharmacy, part of a large chain of pharmacies, fills a variety of prescriptions for customers. The complexity of prescriptions filled by Werner varies widely; pharmacists can spend between...
-
6. The layer of gold coating on a ring should be 0.03 millimeters thick when the ring is completed. A coating of 0.021 millimeters has already been applied. How many more millimeters of gold coating...
-
Bruin Corporation has been authorized to issue 5,000 shares of 12 percent noncumulative, nonparticipating preferred stock with a par value of $100 per share and 200,000 shares of common stock with a...
-
Evaluate following prefix expressions /-AB*+DEF *^+A/BD-EFG /*-AB/DE**FGH Where, A=1, B=2, C=3, D=4, E=2, F=2, G=4, H=3
-
Mandeville Limited ( ML ) constructed a distillery on January 1 , 2 0 2 1 . The distillery is estimatedto have a useful life of 3 0 years ( nil residual value ) from the date it was completed and...
-
The assembly department of Whitby Inc. uses the weighted average method of process costing. They shared the following data for the quarter with you. Physical units Direct materials Conversion costs...
-
Examine the shift in accounting standards for loan loss provisioning from incurred loss models to expected credit loss models in the aftermath of the 2 0 0 7 - 0 8 Financial Crisis. How do the...
-
In another water circuit, water flows at a rate of 30 litres/minute through a Perspex pipe of external diameter 80mm. Given that the pipe has a thickness of 0.01mm and the dynamic viscosity of the...
-
When car has a lifetime distribution exp(1/4), the owner wants to change the car either it is broken or the car is 8 years old. If it is replaced at 8 years (not broken), the owner pays 20, 000...
-
Dennis Kyle case : Dennis was sneezing was particularly bad one day. As he was having his breakfast, he sneezed hard and accidentally knocked his glass of water over. The glass broke, cutting his...
-
Find the cross product a x b and verify that it is orthogonal to both a and b. a = (t, 1, 1/t), b = (t 2 , t 2 , 1)
-
How can a company be sold by means of a capital increase?
-
At what price is a capital increase effected when made with an issue of subscription rights? When made without?
-
What is the consequence of a capital increase on EPS in the short term? In the long term?
Study smarter with the SolutionInn App