I have a database having Millions of records in three tables. Now i want to split these three tables in multiple tables to reduce redundancy and data duplication.
A lot of records(Persons) have multiple city, address , telephone, fax.
So New tables will be Address, ,City ,Postcode ,State ,Country ,Telephone ,Fax
My question is , Is it fine to have City, Postcode, State, Country, Telephone tables separately or Just merge these tables in address table?