It just made things easier to start over. The old table ONLY had the ProductID without the supporting details (price, etc.) That information was linked to the Product table. Now, that information gets copied into the record. You'd have to go back through ALL of the old records and update them with the current information if we chose to keep them all. I've tried to show the evolution of database design, and sometimes when you learn a new way of doing things, you have to radically redesign your database.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.