Welcome to AssignmentCache!

CMIS 420 Homework 3 Online Vehicle Sales OVS Database

Availability: In stock

Regular Price: $15.00

Special Price: $12.00

Quick Overview

CMIS 420 Homework 3 Online Vehicle Sales OVS Database


1) Complete your OVS database through the Homework #2 requirements.
2) Add 25 customers so that you now have 50 total.
3) Add 25 vehicles so that you now have 50 total.
4) Add 200 sales so that you now have 250 total.
5) Via a single SELECT query display the total count of sales, and the lowest, average, and highest sale price.
6) Via a single SELECT query display all customer IDs, names, and zip codes of customers having purchased 5 or more vehicles.
7) Via a single SELECT query display the institution and loan type of the financing plan used for the most sales.
8) Via a single SELECT query display the vehicle make involved in the most sales and all customers having purchased a vehicle of that make.
9) Produce a detailed and formatted report showing the customer IDs, names, and zipcodes along with makes and models sold with summarized customer counts and make and model counts.

CMIS 420 Homework 3 Spool File

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

  • CMIS 420 Homework 3 Spool File
  • CMIS 420 Homework 3 SQL Script

Regular Price: $15.00

Special Price: $12.00

Details

CMIS 420 Homework 3 Online Vehicle Sales OVS Database

1) Complete your OVS database through the Homework #2 requirements.
2) Add 25 customers so that you now have 50 total.
3) Add 25 vehicles so that you now have 50 total.
4) Add 200 sales so that you now have 250 total.
5) Via a single SELECT query display the total count of sales, and the lowest, average, and highest sale price.
6) Via a single SELECT query display all customer IDs, names, and zip codes of customers having purchased 5 or more vehicles.
7) Via a single SELECT query display the institution and loan type of the financing plan used for the most sales.
8) Via a single SELECT query display the vehicle make involved in the most sales and all customers having purchased a vehicle of that make.
9) Produce a detailed and formatted report showing the customer IDs, names, and zipcodes along with makes and models sold with summarized customer counts and make and model counts.

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.