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.

Your submitted assignment (125 points) must include the following:

• A 1–2-page Word document that contains your answers to the assignment questions and any material that you created to assist you with the assignment.