I need to create a table called "evaluation" in which once a month must enter values of a simple formula a / b, that is, a field for a, another for b and a third for the result.
First, the table would look like this:
The problem is that I do not know if this structure works, because in addition I must store (or calculate dynamically, there is my doubt) the totals quarterly throughout the year. I planned to make a large table with one field for each month and between half another field for each quarter.
I have only two tables for this:
productos ------------ idProducto int, nombre varchar evaluacion ----------------- idEvaluacion int ai, fk_idProducto int, fecha datetime, denominador int, numerador int, resultado int