Listed below is the incomplete design of a Sales table for a wholesale company

Given the current design of this table, identify two violations of the basic requirements of a relational data model. Indicate possible anomalies in the table and then normalize the table to third normal form and create a database for the Company.

1. Name the database YOURNAME WHOLESALE COMPANY
   1. Make customer name and Quantity mandatory field
   2. 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.
4. 
   
5. Amounts must be calculated by the system
   Design the query so that the customer is indicated when running the query.
6. Create a report grouped by customer and sorted by Sales Order (SO), listing all sales with subtotals by customer and a Grand total.

SO#	Invoice Date		Item#	Description	Quantity Ordered	Unit Price	Customer #	Customer Name
101		7/5/2020	2033	Washer	5	$359.99	22	Brown Co.
			2051	Drier	8	$372.00
102		7/5/2020	1099	TV	4	$258.00	26	Homebase
103		7/6/2020	2028	VCR	10	$179.99	24	Easy Shop
			2034	CD player	10	$185.00
			2045	DVD player	5	$179.99
104		7/8/2020	1099	TV	15	$258.00	22	Brown Co.

Answer rating: 100% (QA)

To create database and table CREATE DATABASE yournamewholesalecompany USE yournamewholesalecompany C... View the full answer