[thoraway1010]

Except what happens when change events are dropped.

in SQL, normalized, ref integrity on - you simply never get out of sync.