This preview shows pages 1–2. Sign up to view the full content.
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
This note was uploaded on 04/18/2008 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Spring '08 term at Pennsylvania State University, University Park.
- Spring '08