G
Guest
I am designing a database for actual, budget, and forecast data. The table
structure for all 3 types is the same. Is is better to have 3 tables - 1 for
actual, 1 for budget, and 1 for forecast or should I have 1 table that holds
the data for all 3 types and add a type field to determine whether the record
is actual, budget, or forecast? Are there pros/cons to each design? Thanks
for your help.
Weste
structure for all 3 types is the same. Is is better to have 3 tables - 1 for
actual, 1 for budget, and 1 for forecast or should I have 1 table that holds
the data for all 3 types and add a type field to determine whether the record
is actual, budget, or forecast? Are there pros/cons to each design? Thanks
for your help.
Weste