Project 1 &2 Data Info Mgt

Get a 10% discount on an order above
Use the following coupon code :
Get10

Order a Similar Paper Order a Different Paper

You need the salesordersexample database 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 customers table inside of the salesordersexample database, and write a query statement to show all data records of the customers table.

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

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

3. Use the employees table 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 employees table 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 salesordersexample database 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 JOIN to 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 Vendors table and the Product_Vendors table in the database to complete this task.

2. Use INNER JOIN to 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 Orders table and the Customers table in the database to complete this task.

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

4. Use UNION to 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 Customers table and the Employees table 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

 

Essay Writing Service at $11/page: Your Personal Essay Writer

Looking to get your papers done? We have worked on a similar assignment and our student scored better and met their deadline. All our tasks are done from scratch, well researched and 100% unique, so entrust us with your assignment and I guarantee you will like our services and even engage us for your future tasks. Click below button to submit your specifications and get order quote

Get started