Pine Valley Furniture Database Algorithms and Data Structure Task

Instructions

Please use the Pine Valley Furniture sample database attached here to answer the following questions. Name the queries according the question number (e.g., Query 1 and Query 2). Save your queries in the database and submit the database to this dropbox.

Download the Pine Valley Furniture Database File

• Query 1: Use WHERE statement to answer what are the customer IDs and names of all customers, along with the order IDs for all the orders they have placed?
• Query 2: Use INNER JOIN to answer what are the customer IDs and names of all customers, along with the order IDs for all the orders they have placed?
• Query 3: Use natural join to answer “for each customer who has placed an order, what is the customer’s ID, name, and order number?”
• Query 4: Use OUTER JOIN to list customer name, identification number, and order number for all customers listed in the Customer table. Include the customer identification number and name even if there is no order available for that customer
• Query 5: Use OUTER JOIN list customer name, identification number, and order number for all orders listed in the Order table. Include the order number, even if there is no customer name and identification number available.
• Query 6: Write SQL code to assemble all information necessary to create an invoice for order number 1006.
• Query 7: Use self-join to answer what are the employee ID and name of each employee and the name of his or her supervisor (label the supervisor’s name Manager)?
• Query 8: Use subqueries to answer what are the name and address of the customer who placed order number 1008?