Most E-commerce applications use a similar design with 4 basic tables. There may be other ancillary tables ... or capitalize on merged words (e.g. first_name or FirstName). Sample Database Diagram - ...