Instead, you would split this out into a proper_name table, which then has records mapping informal names to formal names. (Mike: Michael, Chris: Christopher, etc) You could then join that to the ...

Normalization is a process of designing and organizing database tables to reduce data redundancy and improve data integrity. Redundancy means having the same data stored in multiple places, which ...