Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database ...

Basic Design Principles Most E-commerce applications use a similar design with 4 basic tables. There may be other ancillary tables to support things like shipping, taxes, categories for searching, etc ...