aggregate functions in database management

This for a MGMT 392 Database Management class. Here are the instructions:
Consider any online retailer with whom you either have direct experience or you have researched.
For this activity, write a 3-5 page paper that addresses the following:
Identify 2 tables that would be important to the organization to store their business transactions.
Describe 5 attributes (fields) for each of the tables, identifying at least one that would require aggregation.
State which aggregate function would be used and explain why.
You are free to cite an example from your own organization if you have current or prior work experience (provided, of course, they do not consider this information to be proprietary and confidential). If you cite an example from other sources, please list your reference.
Refer to the Module Exercises Rubric for grading criteria.
MGMT 392 2.2 Module Exercises Rubric
MGMT 392 2.2 Module Exercises Rubric
Criteria
Ratings
Pts
This criterion is linked to a Learning OutcomeIdentification and Analysis of the Main Issues/Problem
30.0 pts
Excellent (A) (27-30) Identifies and understands all of the main issues in question. Insightful, and thorough analysis of all the issues.
26.0 pts
Above-Average (B) (23-26) Identifies and understands most of the main issues in question. Thorough analysis of most of the issues.
22.0 pts
Average (C) (19-22) Identifies and understands some of the issues in question. Superficial analysis of some of the issues in question.
18.0 pts
Near-Failing (D) (15-18) Identifies and understands few of the issues in question. Incomplete analysis of the issues.
14.0 pts
Failing (F) (0-14) Identifies and understands very little of the issues in question. No analysis of the issues.
30.0 pts
This criterion is linked to a Learning OutcomeAnswers to Questions
30.0 pts
Excellent (A) (27-30) Answers to questions are clear throughout. Connection with class and study material goes well beyond the obvious connections among ideas; demonstrates insight and original thinking.
26.0 pts
Above-Average (B) (23-26) Answers to questions present some irrelevant information on topic etc., but very little; treatment goes beyond obvious connections with class and study material.
22.0 pts
Average (C) (19-22) Answers to questions are vague in places; some irrelevant or distracting information.
18.0 pts
Near-Failing (D) (15-18) Answers to questions are unclear and/or confusing. Treatment is very superficial; paper may be well written but says nothing.
14.0 pts
Failing (F) (0-14) Does not address the questions. Treatment is very superficial and says very little.
30.0 pts
This criterion is linked to a Learning OutcomeStrategy Choice and Justification
25.0 pts
Excellent (A) (21-25) An appropriate, reasonable strategy is selected and successfully developed. Content knowledge is used correctly.
20.0 pts
Above-Average (B) (17-20) An appropriate, reasonable strategy is selected and moderately developed. Content knowledge used appropriately, with minor computation errors.
16.0 pts
Average (C) (13-16) An appropriate, reasonable strategy is selected, but minimally developed. Uses content knowledge with conceptual errors.
12.0 pts
Near-Failing (D) (10-12) There is an attempt to solve the problem. Barely any strategy is applied that could lead to an answer. Rarely uses content knowledge.
9.0 pts
Failing (F) (0-9) There is no attempt to solve the problem. No strategy is applied that could lead to an answer. Uses no content knowledge.
25.0 pts
This criterion is linked to a Learning OutcomeCommunication, Style and Mechanics
15.0 pts
Excellent (A) (13-15) Solution is presented in a clear and orderly manner so the reader can follow the flow of the solution and final answer.
12.0 pts
Above-Average (B) (11-12) Solution is presented appropriately, but may contain a minor error. Reader can follow most of the steps in the solution and final answer.
10.0 pts
Average (C) (9-10) Solution is presented appropriately, but contains conceptual errors. Solution is presented in an unclear manner. Scorer has difficulty following the sequence of steps.
8.0 pts
Near-Failing (D) (7-8) Presents the problem in an unclear manner, steps are missing or out of sequence. Scorer cannot determine a sequence of steps.
6.0 pts
Failing (F) (0-6) Does not present the problem in a manner that can be deciphered. Misuse of words throughout. Awkward sentences throughout. Difficult to attach a thought process. Poorly punctuated, misspelled words, grammatically abusive.
15.0 pts
Total Points: 100.0
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"