Create a query that lists products and the suppliers that supply them

more information provided in first attached file

Requirements

1. Using the ERD provided, create the necessary tables to reflect the business rules given. That is, create Access tables, populate it with your own data in order to demonstrate that all business rules above are satisfied.

2. Create a query that lists all customers and their information (you may use the graphical interface in Access to do so).

3. Create a query that lists customers and the products that they have purchased (you may use the graphical interface in Access to do so). You should also create a report that uses this query. The report should be structured as follows: first list the name of the products; then, for each product list the customers who bought it (ascending alphabetically by last name). Proper column headings, formatting, etc. should apply. 1

4. Create a query that lists products and the suppliers that supply them (you may use the graphical interface in Access to do so). You should also create a report that uses this query. The report should be structured as follows: first, list the supplier ratings; then for each rating, list the suppliers. Finally, for each supplier list the products supplied in descending alphabetical order. Proper column headings, formatting, etc. should apply