Use a half-open interval: EFFECTIVE_DATE is inclusive, END_DATE is exclusive. This prevents gaps and overlaps. - The current record has END_DATE = NULL. - When a new rate takes effect, update the previous record's END_DATE and insert a new record. - Consider adding a CHECK constraint or trigger to p