Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in the database.•Only products that the company sells will be stored in the database. Products will have been purchased byone or more of the customers.•Suppliers may be potential suppliers (i.e., they may not have necessarily supplied any products yet). If asupplier provides a product, it is the exclusive supplier of that product to your company.Note that you will need to determine which data should reside in which tables. Additionally, make sure you are marking the relationships correctly. Requirements: Create an ERD for your database system (this should not be an Access relationship map printout). 2. Using the ERD create the necessary tables to reflect the business rules given. 3. Create a query that lists all customers and their information (you may use the graphical interface in Access todo so). 4. Create a query that lists customers and the products that they have purchased (you may use the graphicalinterface in Access to do so). You should also create a report that uses this query. The report should beproducts within customers (ascending alphabetically by last name) and group indicated by customer name.Proper column headings, formatting, etc. should apply. 5. Create a query that lists products and the suppliers that supply them (you may use the graphical interfacein Access to do so). You should also create a report that uses this query. The report should be productswithin suppliers (descending order by the supplier star rating) and group indicated by supplier name withinstar rating. Proper column headings, formatting, etc. should apply.You will need to populate the tables with enough data to demonstrate adequately that your queries work correctly.
Please help
1 Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a
The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought).
1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in the database.•Only products that the company sells will be stored in the database. Products will have been purchased byone or more of the customers.•Suppliers may be potential suppliers (i.e., they may not have necessarily supplied any products yet). If asupplier provides a product, it is the exclusive supplier of that product to your company.Note that you will need to determine which data should reside in which tables. Additionally, make sure you are marking the relationships correctly.
Requirements: Create an ERD for your database system (this should not be an Access relationship map printout).
2. Using the ERD create the necessary tables to reflect the business rules given.
3. Create a query that lists all customers and their information (you may use the graphical interface in Access todo so).
4. Create a query that lists customers and the products that they have purchased (you may use the graphicalinterface in Access to do so). You should also create a report that uses this query. The report should beproducts within customers (ascending alphabetically by last name) and group indicated by customer name.Proper column headings, formatting, etc. should apply.
5. Create a query that lists products and the suppliers that supply them (you may use the graphical interfacein Access to do so). You should also create a report that uses this query. The report should be productswithin suppliers (descending order by the supplier star rating) and group indicated by supplier name withinstar rating. Proper column headings, formatting, etc. should apply.You will need to populate the tables with enough data to demonstrate adequately that your queries work correctly.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images