Go to the Relationships screen and connect the five tables, enforcing referential integrity. Calculate the total sales f

[answerhappygod]

Go to the Relationships screen and connect the five tables,
enforcing referential integrity. Calculate the total sales for each
customer. Include CustomerID and CompanyName from the Customer
table and the calculated sale amount from the Sale_Amount_
Calculation query. Name the query Total_Customer_Sales. Generate an
e-mail user name for each employee using the first letter of the
employee’s first name and the first five letters of the employee’s
last name, e.g., Rod Smith = > rsmith. Include EmployeeID,
EmployeeFirstName, and EmployeeLastName in the query. Name the
query Employee_Email_Generator. Calculate the total sales for each
month. Determine which customer had the highest average sales
amount. (Hint: Sort in descending order.) Assume the employees earn
a 5 percent commission on sales. Calculate the total commission due
to each employee. Use two queries to do these calculations.
Required: e. Which customer had the highest average sales amount?
What specifically was their average amount? f. Which employee had
the highest earned commission? What specifically was their
commission amount?