Sql based question, In order to make the SQL select

Sql based question

Assignment Help Data Structure & Algorithms

Reference no: EM1380103

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.

Reference no: EM1380103

Questions Cloud

Creating dataflow diagram : Think about the level of detail involved with creating a dataflow diagram, why should the narrative be prepared? Explain why do we need the questionnaire?

Question about structured wiring : Describe how properly installed structured wiring save the need to recable when new applications are added. Provide some examples of a project that required to be recabled because it was not properly installed structured wiring?

Analyze the code of ethics : Choose a Code of Ethics from your area of interest in your present work or future career and summarize this code and analyze the Code of Ethics you have chosen to determine what you think are its strengths and weaknesses. Explain why for both

Creating a table of xml documents : Make a table of XML documents with a type of XML. Use a primary key so add a field of type INT that is an identity. Insert many records into XML field in this new table.

Sql based question : 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?

Find the weight range of normal onion bags : A packaging equipment is used to put onions into five pound bags. In fact the weights vary according to the normal distribution with expected price of average µ = 5.01 lb and standard deviation s = 0.05 lb.

Write an essay on one of topic : Write an Essay on one of topic given below: The impact of an individual's fortitude on self and others The impact of an individual's pursuit of ideals, An individual's response to circumstances beyond familiar experience, An individual's capacity ..

Shared activity, you will conduct a pestle analysis : For this Shared Activity, you will conduct a PESTLE analysis on your featured organisation and brand, which will become the focus of your Final Project. Imagine that the organisation you chose is in the decision phase of determining where to market n..

Increasing competitive advantage : In a 1,000-word paper, create a plan for increasing competitive advantage for the selected organisation and brand. The plan should include three appropriate strategies for increasing competitive advantage in your chosen organisation.

User Account

All Pages