This question has six Parts. Answer Parts $($a$)$ to $($f$)$ below:

Part $($a$)-$ checking for established links

Go to the Relationships screen and connect the $5$ tables, enforcing referential integrity $($to link the tables$).($Hint: This was already done for you and you only need to carefully check if the

relationships have been established between the tables before you perform query tasks$).$

Part $($b$)-$ finding the total sales for each customer

Calculate total sales for each customer. Include:

Customer ID and Company Name from the Customer Table and the calculated sale amount from the Sale$\_$Amount$\_$Calculation query. Name this query as Total$\_$Customer$\_$Sales. $($Hint: First,

you are to use the Salesitems table to find the calculated sale amount and save this query. Second, you are to use this query and the Customer Table to obtain the Total sales for each customer$).$

Part $($c$)-$ generate email username for each employee

Generate an email username for each employee using the first letter of the employee's first name and the first five letters of the employer's last name, eg$,$ Rod Smith $=>$ rsmith. Include:

Employee ID$,$ Employee FirstName, and EmployeeLastName in the query. Name this query as Employee$\_$Email$\_$Generator. $($Hint: Copy this expression$/$formula 'EmailUserName:

Left$([$Employees$]![$EmployeeFirstName$],1$ & Left$([$Employees$]![$EmployeeLastName$],5)\text{'}$ to your Builder$).$

Part $($d$)-$ finding total sales for each month

Calculate the total sales for each month $($Hint: watch the video and also go through the given handout$).$

Part $($e$)-$ finding customer that has the highest average sales

Determine which customer had the highest average sales amount. $($Hint: Use the Sale$\_$Amount$\_$Calculation query in task $2$ to help you to process and finally, sort in descending order$)$

Part $($f$)-$ finding the commission earned by the employees

Assume the employees earn a $3\mathrm{.}5\%$ commission on sales. Calculate the total commission due to each employee. Use $2$ queries to do these calculations. $($Hint: First query $-$ find the total sales for

each employee. Name this query as Employee$\_$Total$\_$Sales. Second query $-$ Copy this expression$/$formula 'Commission: $0\mathrm{.}035*[$Employee$\_$Total$\_$Sales$]![$SumOfAmt$]\text{'}$ in your Builder$)$