I would like to create a database for recording cost estimates in the construction field. What would you as a professional do?
An estimate can include but not be limited to:
- Products (Manufactured products, eg: floor systems)
- Shipping (Shipping of products)
- Assembly (Assembly of products on site)
- Field Materials (Materials other then products required for assembly)
- Finishing (Materials and labour required after assembly)
Now, should each of the above be represented by one table "tbProductTakeoff", "tbShippingTakeoff", "tbAssembly", etc. or should they be collectively recorded to one table, eg: "tbTakeoff".
In the latter case, some intermediate tables would probably be required as well as a category field would be required to tell it what the record actually represents?
In the former case, the GUI would be much harder to handle in the sence there are several tables....
I know alot of responces would be, the tables should be representative of the entities, which is what? The products, Shipping, etc or the takeoff?
Also some might say "It depends on the attributes for each category." which is very true, but with some tweeking, it could be accomplished that each item could be represented by a "Item", "Cost", "Quantity", "SubTotal", "Total".