Try to separate out all of the information stored in the above Customer Sales list into...

 

Transcribed Image Text:

Try to separate out all of the information stored in the above Customer Sales list into outlines for three new tables called: Invoice, Product, and Customer. For each new table include only columns from the Customer Sales list that really belong to that new table. For example, the new Invoice table should only contain columns from the Book List that describe invoice specific attributes (e.g. Invoice #). The Product table should only include columns that really describe something about the product and the Customer table should only include customer information from the original Customer Sales list. In your listing of the new tables you do not have to list all the data in the Customer Sales list only the column headings. A few things to watch out for: 1. Make sure all the columns in your new tables are split up properly so they are atomic (i.e. store only one piece of information). 2. Make sure you clearly identify a primary key (i.e. a unique lookup) on every new table (it is ok to make up a new column if you want). 3. It is ok to rename or split up the original columns from the Customer Sales list but you cannot exclude away ANY of the original columns (for example, you cannot just exclude the Loyalty Program column). Try to separate out all of the information stored in the above Customer Sales list into outlines for three new tables called: Invoice, Product, and Customer. For each new table include only columns from the Customer Sales list that really belong to that new table. For example, the new Invoice table should only contain columns from the Book List that describe invoice specific attributes (e.g. Invoice #). The Product table should only include columns that really describe something about the product and the Customer table should only include customer information from the original Customer Sales list. In your listing of the new tables you do not have to list all the data in the Customer Sales list only the column headings. A few things to watch out for: 1. Make sure all the columns in your new tables are split up properly so they are atomic (i.e. store only one piece of information). 2. Make sure you clearly identify a primary key (i.e. a unique lookup) on every new table (it is ok to make up a new column if you want). 3. It is ok to rename or split up the original columns from the Customer Sales list but you cannot exclude away ANY of the original columns (for example, you cannot just exclude the Loyalty Program column).

Answer rating: 100% (QA)

QUESTION Try to separate out all of the information stored in the above Customer Sales list into out... View the full answer