Data Modelling advice sought for dealing with FIRST/MIDDLE/LAST names

SQLServerCentral » Latest topics

Data Modelling advice sought for dealing with FIRST/MIDDLE/LAST names

I have source data (health data) across three tables with columns as follows:

certifier_name
fathers_first_name
fathers_given_names
fathers_last_name
fathers_middle_name
fathers_surname
first_name
given_names
maide

more info...