TheSQLGuru (10/4/2012)
2) Having a table per object type sold is unworkable - how many different types of objects does Amazon sell??
So if you're selling products you have to design a schema that would work for Amazon.com? What if you're only selling three different types of items?
I disagree with your dogmatism. The correct answer is that "it depends". I've seen a lot of developers come up with very complex solutions to support a flexibility they don't really need and they end up wasting a lot of time in the process.