New answers tagged database-development
To me, there's no question. Go with Option 1. It makes sense that you'll have Products and Categories. They're different, and shouldn't be forced to live in the same table. However, a productName (reasonably shortened to 'name') is not the same as a categoryName (also reasonably shortened to 'name'). You can use context to figure out which 'name' you ...
Top 50 recent answers are included