Details of this Paper

Data Warehousing and Mining

Description

solution


Question

Some of your team members are a little rusty on their SQL skills but need to create the SQL select statements that would produce running summary files for reports on the following;Customer Volume by Month;CustomerID;Month;Total shipments;Total weight;Driver Performance by Month;Driver ID;Month;Number of manifests on time;Number of manifests delivered late;The team members sent you an e-mail with the following questions;From where should they source the information for the design?;What difficulties would they have in writing the SQL statements for each of these tables?;Should any of these tables be created on an as-needed basis?;Do these summary tables violate the concept of table normalization?;Assignment Guidelines;Provide answers to the 4 questions outlined in the assignment description in a 2?3-page Word document.;Provide any examples, tables, or SQL statements that you created to arrive at your solutions.

 

Paper#71097 | Written in 18-Jul-2015

Price : $32
SiteLock