A question about design Relational Model
-
If the original values change then, there will be data inconsistency (i.e. the calculated columns will not be correct).
-
SilimSayo wrote:
If the original values change then, there will be data inconsistency (i.e. the calculated columns will not be correct).
Incorrect isn't the same as inconsistent, and up-to-date is not the same as incorrect.
I are Troll :suss:
-
SilimSayo wrote:
Semantics!!!!
The exact definition is important, and not just a semantical detail. And no, I do not appreciate hit&run comments, as it's a lousy way of communicating.
I are Troll :suss:
Suppose I have a calculated field for age computed from dob and the current date. If this field is not updated and you query someone's age, it will return incorrect results. For example, if the query returns someone's [current] age as 64 when it should have been 65, the result would be incorrect.