IndividualAssignment1-173

IndividualAssignment1-173 - Assignment 1 173 Business...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 1 173 Business Intelligence for Analytical Decisions Due before beginning of class, Wednesday, April 20, 2011 . This assignment must be completed individually. Submit a hard copy print-out at the beginning of class. Please include your name and student ID on the top left corner of the assignment. 1. Given the following four tables: Customer (CustID , CustName, AnnualRevenue, CustType) Shipment (ShipmentNumber , CustID, Weight, TruckID, DestinationCity, ShipDate) Truck (TruckID , DriverName) City(CityName , Population) The primary key has a solid underline and foreign key is dashed underlined. Answer the following queries with SQL script. Use the tables provided above. Please use correct syntax. You do not need MS Access to answer this question. DO NOT submit SQL copied from MS Access. 1) List the names of drivers who have delivered shipments for customers with annual revenue over $25 million to cities with populations over 3 million? 1 point SELECT Truck.DriverName FROM Shipment, Truck, City, Customer
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

IndividualAssignment1-173 - Assignment 1 173 Business...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online