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

Gsun solar panels review - Case study (40 marks) Tata Group: India’s New Global Challenger - Water by the spoonful summary - According to the attraction selection attrition theory job applicants - DIscussion needed by Friday @ 6pm - Holly bush nursery leicester - Types of redox titration - Behavior trap definition - Legal ethics - Limiting reagent lab vinegar and baking soda - Bluebird mfg has received a special - London~ England~!! +91-9829644411 Love Vashikaran Specialist Molvi Ji - Baking soda and vinegar limiting reactant lab answers - Situation analysis of coca cola - Ethical and legal implications of prescribing drugs for nurse practitioners - Regional ring road hyderabad - Insead global executive mba - Information system/Week 6 - Essay (Correlation) Research the practice of threat modeling and evaluate the usefulness related to the ability to predict attacks. 500 words, APA required, SafeAssign used. I need an essay for this quesion without plagarism - Regular rhythm in poetry - An upstream sale of inventory is a sale - Vce units 3 and 4 english - Goal programming excel solver example - Hr bnpparibas csod com my development - Vce psychology study design 2020 - Queen of the night cactus care - Holey plains state park - Ge rr7 relay replacement - Rslogix 500 data types - Is vodka a homogeneous mixture - How to critique a journal article nursing - Good microbiology laboratory practice - Washburn factory tour - If its legal its ethical - ORG/535 Week 4 Apply: Recruitment - Velux csp 100 100 - Www keiserlibrary com - Nbn multi dwelling units - Dynamic business law the essentials 4th ed - Deliverable 5 - Barriers to Change - Tina jones musculoskeletal subjective data - Abilene paradox and groupthink - Ratio analysis assignment doc - Defect report template doc - Unit of magnetic field strength named for a danish physicist - Iom sputum test result - 5-7 business paper - Jorge company bottles and distributes - External locus of control meaning - Nani poem by alberto rios - Takemoto corporation borrowed - Data analysis paper - Create a scenario summary report excel 2013 - 45a whyte street somerton park - Five paragraphs long - Titian sacred and profane love analysis - Who oversaw the preparation of the pequod for its voyage - Cirque du soleil harvard case study pdf - Discussion 1: Shift to Deep Learning - How are standard costs developed - Stat transfer 14 license key - Euroclad 32 1000 wall profile - 1.97 miles in km - Hrm role in orientation - Experiment 1 effects of ph on radish seed germination - Ls dyna material manual - What is stealth marketing course hero - List and discuss three prominent application areas for text mining - Transitions previews and summaries are all examples of - Middle road media case study - Swot analysis amazon case study - Introduction to java programming pdf notes - Mathematics life skills outcomes - How to exit from hive - Tubes containing the sps anticoagulant are used for - What does echidna eat - Research Methods in Criminal Justice - Week 11 News Journal. - Rosemount 3051 ordering information - Answering a question in two paragraph - Salesperson java application part i - Health policy journal 2 - Wife maintenance law in pakistan - Skip hire ealing council - Presidential projects for students - Wish you wood toy store - Excel 2016 module 8 review assignment - Csi web adventures rookie training - Supply chain management walmart case study - Module 11 Assignment - Tweak growing up on summary - Penn state university scandal organizational behavior - Clinical reasoning cycle case study examples - Cjt102 discussion - Marketing excellence nike case study solution - Do mcdonald's fries contain beef - Biome map coloring worksheet ask a biologist - 272 rutland ave welshpool - Christleton high school term dates - Olive tree custom reading plan - Astrand rhyming cycle ergometer test - Blobz guide to electric circuits