You have been given a spreadsheet that contains details of invoices. The column headers for the spreadsheet are date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep number, salesrep first name, salesrep last name, salesrep district, district name, and district size. Normalize this spreadsheet so it can be converted to a high fidelity relational database.
|
This page is part of the promotional and support material for Data Management (fifth edition) by Richard T. Watson |