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
Surname 1Student's Name:Instructor:Course:Date:Personal ReflectionThis week has been very informative, as I got to learn on different issues, and...
testimonials icon
"What are Chicago's Concentric Zones" and "how might they be used to explain the public's fear of crime?" 500 words at least a...
testimonials icon
1. A nominating speech places an actor, entertainer, or politician into consideration for an award. True False  2....
testimonials icon
PLEASE READ BEFORE RESPONGINGTHESE TWO NEED TO BE SEPARATE... THE Rokeach...
testimonials icon
Watchhttps://www.youtube.com/watch?v=zPPxZrZovKUhttps://www.ted.com/talks/larry_page_where_s_google_going_next?language=en...
testimonials icon
Request your tutoring assistance. (For Computerscience Only)...
testimonials icon
Select one of the following and discuss in no less than three paragraphs, and have at least one response to another student of at least one paragra...
testimonials icon
  Required ResourcesTextSeaquist, G. (2015)....
testimonials icon
FINAL PROJECT I. Description What is the goal of this Project? The goal of the Final Project is to create a space for students...
testimonials icon
Question description (Weighted Average cost of capital) The target capitalstricture fo QM industries is 41% common stock 10% preferred stock,...
testimonials icon
BUS 640 Week 3 DQ 1 Relevant Costs Relevant Costs. Two partners own together a small landscaping b...

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