Structured Query Language Skills
Not what you're looking for?
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
In order to create the SQL select statements that would produce running summary files for reports of the above; how would you answer the questions below?
• 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?
Guidelines
Answer four questions above and provide any examples, tables, or SQL statements that you created to arrive at your solutions.
Purchase this Solution
Solution Summary
Structured query language skills are discussed.
Solution Preview
Task:
Structured Query Language Skills
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
In order to create the SQL select statements that would produce running summary files for reports of the above; how would you answer the questions below?
• 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?
Guidelines
Answer four questions above and provide any examples, tables, or SQL statements that you created to arrive at your solutions.
Answer:
I used the following set of SQL statements and example tables (and table fields) to reach to the solution.
For Customer Volume by Month:
Report 1
Month Number of Customers
Jan 1000
Feb 50
SQL for Summary Customers by Month with delivery complete
SELECT TO_CHAR( Date, 'MON') As Month, COUNT(CustomerID) As [Number of
Customers]
FROM Manifest
WHERE Manifest.Complete = 1
Report 2
For Customer ID, Month, Total Shipments, Total Weight:
CustID Month ShipTotal WeightTotal
1 Jan 2000 5000
1 Feb 20 100
1 Mar 0 0
1 Apr 0 0
1 May 0 0
1 June 400 800
1 July ... ...
2 Jan 50 175
2 Feb 35 205
...
SQL for Summary Customers ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C# variables and classes
This quiz contains questions about C# classes and variables.