I have run into an issue with my design. I noticed that not everyone has a middle name or that they have multiple parts to their name. This makes it extremely difficult to use a middle name column. Is it better or "cleaner" to use a full name column or given and surname columns, which way is better?
As of right now, I have 3 columns set up last_name, First_name, and Middle_name. As stated before I realized that not everyone has a middle name or has multiple names for their middle name.
What I have tried:
I have tried to investigate what the best approach is, however, I have not found many articles on this.