We are a little confused on the shopping cart table. If on our “view shopping cart” page, the customer ID, shipping info, and billing info does not appear, should we assume this information and include them in our un-normalized table?
Response: Yes, I mentioned in class that you could include relevant and reasonable fields in the first table if they are not explicitly shown on the report but you determine that they were needed to prepare the report (e.g., a cookie ID). However, be careful not to add fields to the tables once you start the normalization process (e.g., when you are in 3NF do not add a new key field because you think it is needed — presumably such a field should have been added in the first omnibus table).
Related Questions
- On the Order Confirmation page, what is the User Account number below the shipping choices? Does my AccuStandard Customer Number go there?
- Why does the Number of Bids on the Listing Info page display more bids in the table than are listed after I click the Bid History link?
- What does the shipping date indicated in shopping cart page depends on?
