I have been asked to design a database based on the attached. My problem is how to identify what should be fields in the database. This database will be joined to another table called department numbers. I know that the $Variance and % Variance columns are not fields but calculated fields.
The point is each department number will have the Other sources section, Uses section and the other Uses section in a report. Therefore my question is, should each of the items in the sections be fields? That's where I am confused. Could someone help?