search for: gramdma

Hi, I am begining the design of an order management system, and had a few questions about the database design. For example: I have a customers table and an orders table, with a one to many relationship. Now if i change the customers address after the order has been created, it will be updated in any of the past orders, and I do not wish this to happen. Is the best way to deal with this to store