Trying to adhere to the normalization rule in cleaning up and re-design this database. If I have a history table that has a history_Type column that currently stores varchar of the type. Should I create a new table as History_Type with HistoryTypeId primary key as identity column and the a 2nd column as Type_Name as varchar. Then change the History table to hold the HistoryTypeId instead? Thanks.