In normalization, does anyone know why derived data is not allowed? Is it merely because the data would be inefficient to store because it can be calculated using a query?
In my purposes, I use an access database to interface directly with word in order to populate fields and generate customized templates. Derived data would be useful to have in that case so that I can easily interface the information seamlessly and not have to run a separate query. Using it in this manner, would derived data still be a bad idea for a database?
Comments