Unless you know how the data is being used, it's impossible to know what is, or isn't a good database design. There are many times when denormalizing the data makes good sense, and when you wouldn't store the component parts.

If they don't need to distinguish between the first and middle names, it's easier to just not bother with that step. If those two fields are used for sorting the records, and the database doesn't handle derived indexes, then it make sense to store the full version, possibly along with the name broken down into pieces. If they never need the name broken down into its component parts, (eg, they're only using it for display and/or sorting purposes), then they may not need to maintain them.

Yes, they would have more flexibility in the future by storing it in terms of first/middle/last, but if you're tuning for reads, it's not efficient to put everything back together for every access.

I personally thought that saying something wasn't sensible, and that something specifically needed to be done, without an intimate understanding of the reasons for its existance to be very rude.

In reply to Re^2: Inverting full names by jhourcle
in thread Inverting full names by kieps

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.