For whatever it's worth, a pretty good book that covers this in a lot of detail is https://databaserefactoring.com/. One of the authors had several notes on his website about this prior to putting them into a book: http://www.ambysoft.com/books/agileDatabaseTechniques.html