This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 8.Customer is fine. Sale has way too many items. LastName and FirstName are completely unnecessary. C. CustomerID(LastName, FirstName , Phone, Email, SalesID ) Sales(SalesID , Item, Price, Tax, Total, PurchaseDate) It is better because it is much more specific and the information is stored in a area where it would be accessed easily. Also, the surrogate is short and simple and will never change. D. Sale( Total , Date, Item ) SaleItem(Item , Price, Vendor) It improves it by causing less information to be in one place and being able to reference it in different tables. You are able to find out the necessary information in SALE, and if necessary, you can look up the information for the item being sold....
View Full Document
- Spring '08
- Personal name, Family name, Natural key, primary keys, Jerome Azarewicz