I'm designing a price list table for my database.It will include Customer, Model, Start_date, End_date, Price, Currency, RRPWhen I update a new price list, which is sent every now and then (maybe every 1~3 months), I need to update the prices but I would like to keep the records of what has already been raised.Currently in system:Customer  - Model - Start Date - End date  - Price - Currency - RRPA         - Z     - 2015/10/20 - 2015-12-19- 120   - GBP      - 220A         - Z     - 2015/12/20 - 2999-12-31- 100   - GBP      - 200After updating new price:Customer  - Model - Start Date - End date  - Price - Currency - RRPA         - Z     - 2015/10/20 - 2015-12-19- 120   - GBP      - 220A         - Z     - 2015/12/20 - 2016-02-20- 100   - GBP      - 200A         - Z     - 2016/02/21 - 2999-12-31-  90   - GBP      - 180What is the best way to update the price?I tried to google which solved all the problems until now as most of the search results is bringing up SQL price plans :(I have learned MySQL 9 years ago in college for a few months so I know how to interpret the SQL scripts but I am totally lost when I'm trying to create anything from scratch.
Designing pricing table (RDBMS agnostic)
sql;data modeling