Does anyone know of a good document or site where I can get Best Practices for creating a Customer Database (SQL)? For example, Customer buys 2 different products at 2 different times and uses different email addresses. Or they decide to change their email address in their account after they purchase. Of course I don't want to overwrite the info. And I want to see the interaction of the customer historically...
Hard info to find for free. Here's a site with free database models, think they are MS SQL based but can be adapted to MySQL or other. http://www.databaseanswers.org/data_models/ Just some quick advice. Customer's information would/should be in one table while their orders are in another table. Referenced by the customer's id. Setting up a history of actions would pretty much boil down to logging and depending on activity could be cumbersome.