Create the primary keys and relationships according to the ERD.

Then, create the following queries in the Access Database using the query designer $($QBE$)$ or SQL$.$

Name each query as Query $1,$ Query $2,$ Query $3,$ etc., ensuring the number in the query name corresponds to the question number.

To help you grasp the requirements and conduct self$-$assessment, the output of queries are provided in the attached document.

Create a query to display the total inventory$$that is$,$ the sum of all products on hand for each brand ID$.$ Sort the output by brand ID in descending order. Note: Product$\_$QOH filed name stands for Product Quantity On Hand.

Create a query to display the brand ID$,$ brand name, and average price of products of each brand. Sort the output by brand name.

Create a query to display the department number and most recent employee hire date for each department. Sort the output by department number.

Create a query to display the employee number, first name, last name, and largest salary amount for each employee in department $200.$ Sort the output by the largest salary in descending order.

Create a query to display the customer code, first name, last name, and sum of all invoice totals for customers with cumulative invoice totals greater than $$1,500.$ Sort the output by the sum of invoice totals in descending order.

Create a query to display the department number, department name, department phone number, employee number, and last name of each department manager. Sort the output by department name.

Create a query to display the vendor ID$,$ vendor name, brand name, and number of products of each brand supplied by each vendor. Sort the output by vendor name and then by brand name.

Create a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee's last name and then by first name.

Create a query to display the largest average product price of any brand based on sales history $($Hint: Average price should be calculated based on Line$\_$Price filed. The Prod$\_$Price in the Product table is the current price of product, which cannot be used for this query$)$

Create a query to display the brand ID$,$ brand name, and average price of products for the brand that has the largest average product price.

Generate a query to exhibit the name of the top$-$selling product, based on the highest count of units sold.

Create a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made a sale to a customer whose last name is Hagan on May $18,2021.$

Create a query to display the current salary for each employee in department $300.$ Assume that only current employees are kept in the system, and therefore the most current salary for each employee is the entry in the salary history with a NULL end date. Sort the output in descending order by salary amount.

Create a query to display the starting salary for each employee. The starting salary would be the entry in the salary history with the oldest salary start date for each employee. Sort the output by employee number.Create the primary keys and relationships according to the ERD.

Then, create the following queries in the Access Database using the query designer $($QBE$)$ or SQL$.$

Name each query as Query $1,$ Query $2,$ Query $3,$ etc., ensuring the number in the query name corresponds to the question number.

To help you grasp the requirements and conduct self$-$assessment, the output of queries are provided in the attached document.

Create a query to display the total inventory$$that is$,$ the sum of all products on hand for each brand ID$.$ Sort the output by brand ID in descending order. Note: Product$\_$QOH filed name stands for Product Quantity On Hand.

Create a query to display the brand ID$,$ brand name, and average price of products of each brand. Sort the output by brand name.

Create a query to display the department number and most recent employee hire date for each department. Sort the output by department number.

Create a query to display the employee number, first name, last name, and largest salary amount for each employee in department $200.$ Sort the output by the largest salary in descending order.

Create a query to display the customer code, first name, last name, and sum of all invoice totals for customers with cumulative invoice totals greater than $$1,500.$ Sort the output by the sum of invoice totals in descending order.

Create a query to display the department number, department name, department phone number, employee number, and last name of each department manager. Sort the output by department name.

Create a query to display the vendor ID$,$ vendor name, brand name, and number of products of each brand supplied by each vendor. Sort the output by vendor name and then by brand name.

Create a query to display the employee number, last name, first name, and sum of