a$.$ Go to the Relationships screen and connect the five tables, enforcing referential integrity.

b$.$ 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.

c$.$ 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.

d$.$ Calculate the total sales for each month.

e$.$ Determine which customer had the highest average sales amount. $($Hint: Sort in descending order.$)$

f$.$ 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.

Rorkaraund for Drahlame in thrauah $14$

Clear