New answers tagged database-diagrams
0
As far as primary keys, ALL TABLES HAVE THEM. It's a little over the top, but I've seen too many databases that lose their data integrity because the developers didn't want to lock down a PK ID field off the start. I would have a table for persons and a table for companies, with an attribute field to mark them as a seller.
For the company point of contact, ...
0
A few points that came across my mind while looking at this. The overall thought and design isn't bad, so I think you're on the right track as far as storing the product information.
I'm curious what kind of information is expected to be put into the "List of..." tables. As a note for names with more than one word you would do yourself a favor and NOT use ...
Top 50 recent answers are included
