I am creating a fairly simple database for an engineering firm to handle their job costing and need some advise on the design.
I have a table for categories and quotes (and others)
The issue I have is that I want to be able to create a quote that has a cost breakup by category (with the categories listed in the category table). Do I create all the category names as fields in the quote table to store the quoted price for that category, or can I look them up from the category table itself. If I create the category fields in the quote table then I am duplicating data.
Hope this makes sense.