MySQL Data File Containing Data about a Paints Business Based in United State - IT/Computer Science Assignment Help

Assignment Task:

TASK:

In this assignment, you are supplied a simple dataset for which you will write SQL queries. You will be using the well-known MySQL RDBMS for this task. You are provided a MySQL data file containing data about a paints business based in United States. It contains data about the customers, invoices, employees, products and vendors. Import this file into your MySQL installation by following the instructions on Interact site. Click here to download PrimePaints.sql data file. For your convenience an ERD is also provided so that you can better understand the database structure. Some column names are ambiguous, their description is provided below: Prod_SKU - A unique identifier for every single product in stock. Prod_Min - A minimum theshold level for a product. When stock falls below that level, it must be reordred. Prod_QOH - Quantity on hand for the given product. Cust_Balance

- The amount owed by a customer. It is not the same as total of their invoices. Sal_From and Sal_End

- Dates indicating a pay period. Sal_Amount - Salary paid to the employee in the given pay period Emp_Comm

- Rate of commission for some employees. Write and execute SQL statements to complete each of the following tasks. Copy your SQL statements into the assignment document. Secondly, include the screenshots of results obtained by executing those statements on the DBMS. Typing the results of SQL statements is NOT acceptable. List the names and street addresses of all vendors based in states of Michigan or Ohio. Sort the list by city name. Find total number of stock items the company have in their warehouse. Find out the duration (number of days) for which we there are records of sale data. Display the earliest date, latest date and the period between two. Display the first name and contact details (email, phone) of all
 

This IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.