Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

273 77th street avalon nj

16/11/2021 Client: muhammad11 Deadline: 2 Day

Sql

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 Prime Paints .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.

1. List the names and street addresses of all vendors based in states of Michigan or Ohio. Sort the list by city name.

2. Find total number of stock items the company have in their warehouse.

3. 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.

4. Display the first name and contact details (email, phone) of all 'product specialists' who work in Marketing.

5. Find the employee number, full name and hire date of oldest staff member.

6. Find the date(s) with highest amount of sales. Also display the corresponding total sale amount.

7. List all brand names and the total dollar amount of sales for each brand. Sort the list by descending order of brand sales.

8. Find highest paying customers (according to their invoice totals) and list their names along with the city and state they belong to.

9. Find out the total of salaries paid out by all departments during the month of June 2017. Sort the list by department name.

10. For the year 2015, get a list of all professions and their the average salary. Profession is identified employee title. Average must be displayed with 2 decimal places. Sort the list by highest paid jobs at the top.

[1.5 marks × 10]

For some questions that require date and time calculations, please refer to MySQL documentation to see the available functions.

RATIONALE

back to top

This assessment task will assess the following learning outcome/s:

· be able to use complex SQL commands to query a database.

MARKING CRITERIA AND STANDARDS

back to top

The marking criteria for this assignment is:

Criteria

HD

DI

CR

PS

be able to use complex SQL commands to query a database.

SQL syntax returns all attributes that meet the business requirement from the tables that hold the data and applies the correct restrictions to retrieve the required information.

SQL syntax returns all attributes that meet the business requirement from the tables that hold the data with minor omissions and applies appropriate restrictions to retrieve the required information.

SQL syntax returns key attributes that meet the business requirement from the tables that hold the data and applies relevant restrictions to retrieve the required informationn

SQL syntax returns key attributes that meet the business requirement from the tables that hold the data but the restrictions applied to retrieve the required information contain minor errors.

PRESENTATION

back to top

Please prepare and submit a single Word document containing your SQL queries and result screenshots.

REQUIREMENTS

back to top

Only MySQL RDMBS must be used for this exercise. You may use a graphical front end like MySQL Workbench for executing queries. Instruction videos for this task will be provided on Interact site.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignment Writer
Instant Homework Helper
University Coursework Help
High Quality Assignments
Supreme Essay Writer
Professional Accountant
Writer Writer Name Offer Chat
Instant Assignment Writer

ONLINE

Instant Assignment Writer

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$30 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$32 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$27 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$45 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$16 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$40 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Glen innes east tamaki healthcare - Elder Abuse - Himaa introductory intermediate coding course - In self-directed learning, trainers do not control or disseminate instruction. - Challenges with realising aspirations of the common good - 1 discussion due in 24 hours. - List of account titles under assets - Name the vertices of a quadrilateral - Eukaryotic cell structure and organelles worksheet 10 - Case study paper - Blue eyes and brown eyes experiment video - Wk 2 theory in research - Ethics- show you care - Shear force in a beam lab report - Sealy embody introspection mattress reviews - 1331 crissey circle brookings or - Filipino tattoos ancient to modern pdf download - Starbucks foreign direct investment case study - Mortgage offer letter template - 6 steps of root cause analysis ihi - International dimensions of organizational behavior free pdf - Effective Compensation Plans - Deliverable 3 - Employment Law Infographic - Australian stained glass supplies catalogue - Question to be answered - Create a scenario summary report excel 2013 - Monthly fire drill log template - Miss marple the pale horse full episode - It 210 milestone one - Cessna 172 preflight checklist - Conductivity of strong and weak electrolytes lab report - How to draw hyperbolic paraboloid - Notice of marriage swansea - Market competitive pay system - The strategic-management process is often touched off by a crisis. - Company Presentation - Martha mccaskey case study - Lesson 17 openness and concealment answers - The right thing to do 8th edition pdf - Insulin onset peak duration table - General Biology - Fresher than fresh snow cones - An authentic counselor is best described as - ET WK10 Paper - Positive interdependence and knowledge sharing - Salvador dali blue period - Old man sam song - Swot analysis of internet cafe - Open university teaching assistant - IS525 INFO STRATEGIC PLANNING - HISTORY-ECONOMIC THOUGHT 125 (001) (Fall 2020) - Cambridge latin course book 1 stage 6 avarus translation - How to write a policy paper proposal - ISA 562 – 2020 - Econ 545 final exam answers - Arc flash incident energy table - 45 in roman numerals - Daq assistant express vi - How to make full wave rectifier circuit on breadboard - Physical flow of inventory - Econ 214 problem set 5 - Last hours of pompeii - A 1.00 meter length of nichrome wire - Ezy group trading toombul - Computer network security tutorial pdf - Mieszkam w Szczecinie - The life of arseniev - Capella university msn care coordination - Attribution theory and how it influences the implementation of innovation technologies - Of mice and men gcse essay - Lords of dogtown intro - Configuring and verifying standard acls - Organizational values presentation - Hospitality hotels forecasts monthly labor needs - Ends ways and means model - Hartford research issues bonds dated january - Needed in 8 hours - Support groups for the bereaved consist mainly of - Charges and electric potential mastering physics - Discussion - Need Saturday by 5:30 pm EST 3.5 Leadership Presentation - What is a fraction equivalent to 4 4 - Responding - Please check for citations errors and grammar errors - How to use hendrich fall risk assessment - Www galencollege edu student portal - Borosilicate glass thermal expansion - Economic and business - What does sg & a stand for - Jetblue and the veterans administration case study - Photorec carver - 1.6 km run norms - Week 6 - Short Essays - Deliverable 3 - Ranking Capital Investment Projects Excel and Power Point - Texting and driving persuasive speech examples - How to always be imposter in among us - Cable high pot test - Seussical the musical mayor - App driven orchestration in oic - Bendigo health specialist clinics