That depends on the problem domain and how you design the system, since there are several way to do this. Typically in financial systems you would either have a

That depends on the problem domain and how you design the system, since there are several way to do this. Typically in financial systems you would either have a start and end date on a summary record, or add an inactive record to a transaction table that has a record for each change to the account, or both.