Pine Valley Furniture Database Algorithms and Data Structure Task

Description

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?



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.