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 make the SQL select statements that would manufacture 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.