Standard Way of Storing Names in a Database [closed]

Question

I have recently been pondering names and the way we store them. Generally a person will have a First, Last and Middle name. If you want to be particularly complete you might add a suffix field, perhaps even a title field. So if someone wants to be "Dr. John Q. Public III", they can. But a person can have more than one honorific and more than one suffix. For that matter then could hve a hyphenate last name too. So what if you are "Dr. John Quintus Maximus Public-Doe III Ph.D. MD. RPh."? You could do:

Persons
    PersonID
    Prefix
    FirstName
    MiddleName
    LastName
    Suffix
PersonHonorifics
    PHID
    PersonID
    Honorific
PersonNames
    PANID
    PersonID
    NameOrder

But then it gets to be a bear to work with, and no one ends up using them anyway.

Is there a generally accepted "Standard Way" to store name data?

Answer 1

I prefer AD naming style

First Name  givenName
Last Name   sn
Initials    initials
Display Name    displayName
Description description
Office  physicalDeliveryOfficeName
Telephone Number    telephoneNumber
Telephone: Other    otherTelephone
E-Mail  mail
Web Page    wWWHomePage
Web Page: Other url