New answers tagged

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