Project 2.1

Project 2

BUSA 326

You need the SalesOrdersExample database to complete this project. If you have not installed the

database in MySQL, please refer to the “SQL installation guide”, and “Load SQL Script” shown in Week 5

to set up the database.

NOTE: Write your own Queries. Do NOT use the same queries that I showed you in class.

1. Use INNER JOIN to create a query result. In this query result, list each vendor’s

name and the name of each product the vendor has supplied to our company. You should

use the Vendors, Product_Vendors, and the Products tables in the database to complete

this task. (20 Points)

2. Use INNER JOIN to create a query result. In this query result, list each customer’s

first name, last name, and the dates when he or she places orders to us. You should

use the Orders table and the Customers table in the database to complete this task.

(20 Points)

3. Use OUTER JOIN to create a query result. In this query result, list the name of the

products that have never been ordered. You should use the Order_Details table and the

Products table in the database to complete this task. (20 Points)

4. Use UNION to create a query result. In this query result, list both customers’ and

employees’ first name, last name, street address, city of residence, state of

residence, and zip code. You should use the Customers table and the Employees table

in the database to complete this task. (20 Points)

5. Count the number of Customers. You should use the Customers table. (10 Points)

6. Use MAX in a query. You can use any table. (10 Points)

What to Submit

1. Copy/Paste the above questions in a document.

2. Write your SQL query statements below each question (i.e. Copy/paste from MySQL).

3. Get a screenshot of the Result Grid after you execute each query in MySQL, and copy/paste into

the document as well (below the SQL query).

4. List the Number of Rows Returned – shown in the Action Output pane at bottom of MySQL

window (e.g. 3 row(s) returned).

5. Name the document as “Project2_YourLastName”.

6. Convert the document to .PDF, and submit it to Dropbox on eCollege by the listed date.