a) Use OracleSQL* Plus, create the schema of this database.

a) Use OracleSQL* Plus, create the schema of this database..
a) Use OracleSQL* Plus, create the schema of this database. Continue by inserting thedata records as presented in the handout. Document final tables.b)Solve the following queries in SQL. For each query, you need to specifythe SQL and show the result of each query if applied to the Order-EntryDatabaseMaterial, see attachment1) List the customernumber, name (first and last), city, and the balance of customers whoreside in Denver with a balance greater than $150 or who reside inSeattle with a balance greater than $300.2) List the employeenumber, name (first and last), and phone of employees who have takenorders in January 2013 from customers with balances greater than $300.Remove duplicate rows in the result.3) List the order number,order date, customer name (first and last), and total amount for ordersplaced on January 23, 2013. The total amount of an order is the sum ofthe quantity times the product price of each product on the order.4)List the product number, product name, sum of the quantity of productsordered, and total order amount (sum of the product price times thequantity) for orders placed in January 2013. Only include products thathave more than five products ordered in January 2013. Sort the result indescending order of the total amount.5) List the employeenumber, employee name (first and last), commission rate, supervisingemployee name (first and last), and the commission rate of thesupervisor.6) Using the join operator style, list the productname and the price of all products ordered by Beth Taylor in January2013. Remove duplicate rows from the result.7) For Coloradocustomers, compute the number of orders placed in January 2013 in whichthe orders contain products made by Connex. The result should includethe customer number, last name and number of orders placed in January2013.8) For each employee with a commission rate greater than0.03, compute the total commission earned from orders taken in January2013. The total commission earned is the total order amount times thecommission rate. The result should include the employee number, employeelast name and total commission earned.9) List the productnumber, name, price and total order value (sum of price times quantity)of products ordered by Colorado customers in January 2013 in web orders.A web order does not have an employee associated with the order.
a) Use OracleSQL* Plus, create the schema of this database.

Don't use plagiarized sources. Get Your Custom Essay on
a) Use OracleSQL* Plus, create the schema of this database.
For $10/Page 0nly
Order Essay

Calculate the price of your paper

Total price:$26

Need a better grade?
We've got you covered.

Order your paper