bingo bob wrote: > interestingly enough - that's exactly what I've done. > > gone with... > > forename:string > midnames:string > surname:string > > midnames seperated by spaces basically, in the vast majority of cases > I'd expect 0, 1 or more rarely 2 midnames; pragmatically it just seemed > like the right thing to do in this case.
What you're doing is most likely going to "work" and will be easy to implement, but your solution is still bad database design. You are relying on a repeating group, multiple values in a single column. It's fine what you're doing, as long as you realize that it is bad design and you can live with that. For more details see: http://en.wikipedia.org/wiki/First_normal_form#Repeating_groups -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
