See anything wrong with this model.

Any help would be appreciated.

yeah, i see plenty

for starters, it's hard to read

upon closer inspection, i don't understand what's going on

say, what software did you use to produce this?

Only half of the image was uploaded. I will update the graphic tomorrow.

Basically another set of tables is used to categorize the products in the TaxId field.

basically its like this:

CatId PK
Cat_Name

CatId FK
SubCatId PK
SubCatName
Order

SubCatId FK
ClassId PK
ClassName
Order

ClassId FK
ProdId PK
ProdName
Order

ProdId is PK to the FK TaxId Products Table in the graphic posted.

I used Adobe Illustrator because its gonna be used to show people that don't have a web development background.

If this makes no sense then sorry :P

I created this database model for a sporting goods store. Its not ecommerce.

If anyone can take a look and let me know if anything looks wacky.

Please let me know.