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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
