Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

You need the salesordersexampledatabase to complete this project. If you have not installed the database in MySQL, please refer to #3 installation guide in Week 3 link on eCollege to set up the database.

1. Use the customerstable inside of the salesordersexample database, and write a query statement to show all data records of the customers table.

2. Use the customerstable inside of the salesordersexample database, and write a query statement to show data records from the CustFirstName, CustLastName, and CustCity columns.

3. Use the employeestable inside of the salesordersexample database, and write a query statement to show the employee’s EmployeeID, EmpFirstName, EmpLastName, and EmpPhoneNumber, if she’s living in the area with 98413 as the zip code. 

4. Use the employeestable inside of the salesordersexample database, and write a query statement to show each employee’s EmployeeID, EmpFirstName, and EmpLastName. Also, in the report, create a new column called EmpAge, in which you use a date expression to calculate and show the employee’s age today. ( Hint:A similar analysis can be found in the developer guide in Week 5 link on eCollege.)

 

Please save the query statements for questions above into a Word document. Also, get a screen capture of the data report after you execute each query in MySQL, and save the screen captures into the Word document as well. Please name the Word document as “MyProject1

 

 

BUSA 326 Project 2 Instructions

You need the salesordersexampledatabase to complete this project. If you have not installed the database in MySQL, please refer to #3 installation guide in Week 3 link on eCollege to set up the database.

1. Use INNER JOINto create a report. In this report, list each vendor’s name and the name of each product the vendor has supplied to our company. You should use the Vendorstable and the Product_Vendorstable in the database to complete this task.    

2. Use INNER JOINto create a report. In this report, list each customer’s first name, last name, and the dates when he or she places orders to us. You should use the Orderstable and the Customerstable in the database to complete this task.

3. Use OUTER JOINto create a report. In this report, list the name of the products that have never been ordered by far. You should use the Order_Detailstable and the Productstable in the database to complete this task.

4. Use UNIONto create a report. In this report, list both customers’ and employees’ first name, last name, street address, city of residence, state of residence, and zip code.  You should use the Customerstable and the Employeestable in the database to complete this task.

Please save the SQL query statements for each question into a Word document. Also, get a screen capture of the data report after you execute each query in MySQL, and save the screen captures into the Word document as well. Please name the Word document as “MyProject2

 

testimonials icon
 Find an article that relates to Chapter 6 (Motivation).  In addition to finding an article, write a 1-2 page paper on how the article r...
testimonials icon
its about computer organization assignment please see the file that I attach...
testimonials icon
Surname1Japanese GhostName of studentName of professorName of courseName of institutionDateOracle 1(Prostitute)Who was the author of the oracle?T...
testimonials icon
need to do the final draft ( i already have the outline and the   need to do the final draft ( I alr...
testimonials icon
DQ3What are the basic principles of fund accounting? When do governmental entities recognize revenue? Why is timing important in recognizing...
testimonials icon
Sociologists explain deviance by three (3) major perspectives: biological, functional conflict, and symbolic interaction. Identify your role,...
testimonials icon
G.R. No. L-19617 October 31, 1969UNIVERSITY OF THE PHILIPPINES BOARD OF REGENTS and CRISTINO JAMIAS,petitioners,vs.AUDITOR GENERAL and the GOVERNMENT...
testimonials icon
As manager, you have been notified that the per-mile expenses reported by your top salesperson justifies securing a com...
testimonials icon
“Leading and Managing Communication” Please respond to the following: From the e-Activity, choose two (...
testimonials icon
  “PLACE THIS ORDER OR A SIMILAR ORDER WITH BRAINY TERM PAPERS AND GET AN AMAZING DISCOUNT”power point was first...
testimonials icon
Hello,I need two responses of at least 150 words each for the below students discussions for this week. Also in the bold below are the questions...
testimonials icon
Question description i can provide previous assignment for section A Details: To begin, work through the reference list that was c...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65