Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
These are queries that use the full Red Cat Database as shown in Figure 3.1.  To do these queries you cannot use the SimplifiedSales database.  You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables. For each information request below, formulate a single SQL query to produce the required information.  In each case, you should display only the columns requested.  Be sure that your queries do not produce duplicate records unless otherwise directed. List the information in the SaleItem table concerning green sneakers. Use the first letter of each table name as alias names. (Note: Colors are capitalized while categories are not. ) Note: Your answer should dynamically include all current columns in the saleItem table  and any future changes to columns.

These are queries that use the full Red Cat Database as shown in Figure 3.1.  To do these queries you cannot use the SimplifiedSales database.  You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables. For each information request below, formulate a single SQL query to produce the required information.  In each case, you should display only the columns requested.  Be sure that your queries do not produce duplicate records unless otherwise directed. List the information in the SaleItem table concerning green sneakers. Use the first letter of each table name as alias names. (Note: Colors are capitalized while categories are not. ) Note: Your answer should dynamically include all current columns in the saleItem table  and any future changes to columns.

icon
Related questions
Question

These are queries that use the full Red Cat Database as shown in Figure 3.1.  To do these queries you cannot use the SimplifiedSales database.  You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables.

For each information request below, formulate a single SQL query to produce the required information.  In each case, you should display only the columns requested.  Be sure that your queries do not produce duplicate records unless otherwise directed.

List the information in the SaleItem table concerning green sneakers. Use the first letter of each table name as alias names. (Note: Colors are capitalized while categories are not. ) Note: Your answer should dynamically include all current columns in the saleItem table  and any future changes to columns.

1 * Customer ® CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone Saleltem ProductID ItemSize SalelD Quantity SalePrice Sale SalelD SaleDate CustomerlD Tax Shipping SalaryEmployee EmployeelD Salary WageEmployee EmployeelD Wage MaxHours '* 1 1 1 * Product ProductID ProductName ManufacturerlD Composition ListPrice Gender Category Color Description Inventoryltem ProductID ItemSize QtyOnHand ItemSize ItemSize Employee EmployeelD FirstName LastName Address City State ZIP Phone ManagerlD SSN EmailAddress HireDate 1 1 1 * |||+ * * * Manufacturer ManufacturerID ManufacturerName Address1 Address2 City State Postal Code Phone Fax Contact URL Purchaseltem ProductID ItemSize PurchaselD Quantity Purchase Price Purchase PurchaselD PurchaseDate EmployeelD Expected DeliveryDate ManufacturerlD Shipping *
Transcribed Image Text:1 * Customer ® CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone Saleltem ProductID ItemSize SalelD Quantity SalePrice Sale SalelD SaleDate CustomerlD Tax Shipping SalaryEmployee EmployeelD Salary WageEmployee EmployeelD Wage MaxHours '* 1 1 1 * Product ProductID ProductName ManufacturerlD Composition ListPrice Gender Category Color Description Inventoryltem ProductID ItemSize QtyOnHand ItemSize ItemSize Employee EmployeelD FirstName LastName Address City State ZIP Phone ManagerlD SSN EmailAddress HireDate 1 1 1 * |||+ * * * Manufacturer ManufacturerID ManufacturerName Address1 Address2 City State Postal Code Phone Fax Contact URL Purchaseltem ProductID ItemSize PurchaselD Quantity Purchase Price Purchase PurchaselD PurchaseDate EmployeelD Expected DeliveryDate ManufacturerlD Shipping *
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer