Data Mining and Warehousing_Unit4_IP

Data Mining and Warehousing_Unit4_IP - Moonlight...

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

View Full Document Right Arrow Icon
1 RUNNING HEAD: MOONLIGHT DISTRIBUTORS DATABASE Task Name: Phase 3 Individual Project Deliverable Length: 500-750 words Details: One of your team members are a little rusty on their SQL skills, but needed 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 member sent you an e-mail with the following questions: From where should he source the information for the design? What difficulties would he 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? Customer Field Name Ke y Data Type Size of Data Type CustomerID PK CHAR 10 L_Name TEXT 50 F_Name TEXT 50 Address TEXT
Background image of page 1

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

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

This note was uploaded on 02/17/2012 for the course ITCO 101 taught by Professor Gugenhiem during the Spring '12 term at AIU Online.

Page1 / 5

Data Mining and Warehousing_Unit4_IP - Moonlight...

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