Below is a simple ERD for a retail company whose customers buys one or more products each. Each product has associated with it a bill for all products rendered. Name ID Specs Price Customer Buys Product ID Amount Birth date Name Addres Bill # Date Billed Bill - Using Microsoft Access, construct a databased that would cater for the data in the ERD: Construct the tables with their fields, keys, data types and meta data Build the needed relationships (or index tables where the relationship is not 1-1) Enter sample data in the tables created Build a query that would generate a list of: Customers (with their information), Products purchased (with information) and any Bill reported