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
Order instructions: Guidelines for Paper 1The paper should be 2-3 pages double-spaced, plus an image of the work discu...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
Explain health inequalities and health disparities from a community-based perspective. Health Disparities Objectives Explain health...
testimonials icon
Please see the attachment for the math homework. Due by tomerrow ...
testimonials icon
This report is based on highlighting the goals which are achieved through launching a new product in the market through the use of the SMART tech...
testimonials icon
The paper must be one to two pages, excluding the title page and references page(s), and formatted according to APA style as outlined in t...
testimonials icon
Hello, please let me know if you can do this assignment , 5 to 6 pages is enough. due Tuesday.its health care policy class.Cases...
testimonials icon
 Week 2 written comparative politicsYou are preparing a brochure for American visitors to France. Your purpose is to i...
testimonials icon
Create a mind-map of Amazon European Distribution Strategy case  With reference to the Case Analysi...
testimonials icon
Critical Analysis  Critical analyses must be a maximum of three pages in length;  You will identify the pro...

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