Wow, lots of non-database comments (not that there's anything wrong with that).
Design your systems flexibly, with a reasonable lack of assumptions. If society moves past your system, fix it.
I have one name. Very few online forms have ever allowed me to leave first or last blank. I generally try to get away with first-blank, last-filled in, and then surrender as appropriate.
What's worse, I think, is online groups where only one person can be known by a particular name. Stupid. How you call yourself should be unrelated to how the database needs to identify you uniquely.
Design your systems flexibly, with a reasonable lack of assumptions. If society moves past your system, fix it.
I have one name. Very few online forms have ever allowed me to leave first or last blank. I generally try to get away with first-blank, last-filled in, and then surrender as appropriate.
What's worse, I think, is online groups where only one person can be known by a particular name. Stupid. How you call yourself should be unrelated to how the database needs to identify you uniquely.