microsoft Access

Listed below is the incomplete design of a Sales table for a WHOLESALE company normalize the table to third normal form and create a database for the Company. 1. Name the database YOURNAME WHOLESALE COMPANY a. Make customer name and Quantity mandatory field b. Unit price should be more than 100 but less than 1000 2. Create a Query Listing: Customer Name and all data about items sold sorted by product name within a customer record 3. Create a query listing all Items sold to a single customer, charges for each item sold (PRICE x NUMBER OF UNITS) and the total amount. Amounts must be calculated by the system Design the query so that the customer is indicated when running the query. 4. Create a report listing all sales with subtotals by customer and Grand total