Re: Newbie Normalization Question

[Total Newb]

Thanks for the quick reply! Quick question:

So would each random question gets its own Table every time a business adds a new question to their form or just start a table for questions and add to that table over time, leaving null fields where a business doesn't use that particular question?

To answer your question each manufacturer will only carry one of each product (product id) but every business could have a different vendor across the country attached to them and each vendor needs to be able to see what products from their manufacturer they have submitted. So I need to tie in the products and businesses in with foreign keys to identify the vendors. Any ideas on that would be great as well but I was working on one problem at a time. Have I bitten off too much or is this standard database design? Thanks guys!