Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Roy Slough
  Where is Roy Slough?
 Potters Bar
 United Kingdom
 Roy Slough
 To: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 Tags
Subject: RE: Name string not working in SQL
Thread ID: 345266 Message ID: 345554 # Views: 35 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Thursday, May 24, 2012 8:48:35 AM         
   


Thank you for the comment Mike but......

Ah at last at topic I can speak with some authority on,
My coding may not be up to much (yet) but database design and normalisation I can do.

For Data Normalisation, whether a persons name is considered a single entity or it's constituent parts is a matter of debate.
Admittedly their title (Dr. , Mr, Mrs, Miss, Ms etc..) is not part of their name nor is any acreditations they may have (Bsc, Hons, MBE, OBE etc.) but the rest of the name can vary,
Not only is the number of elements in a name variable, but the content is also variable.
e.g. some people have no middle name some have multiple (even six, seven or more!!!)
some people only quote initials and in strict terms an initial is not the same data as a name.
Some cultures have surname or family name first then followed by their own personal name(s)

It is not reasonable possible to cater for all these variations and permutations as the structure and coding would be very complex (especially for data entry personnel who usually are nor trained in these matters).
Therefore one must analyse and design the data structure from it's envisaged use.
In this scenario the only piece of information required separate is the last Name or Surname (where the name is an individual)
I could allow/force the user to enter this as a separate field or programatically extract it after entry, either way data normalisation is maintained (for the required data use)

Luckily I have years of experience in data design, but a novice may panic when warned "there may be trouble ahead" or "you may pay for this poor design later"
Better I think to advise they consider carefully how the data is to be used prior to making significant decisions.

I do appreciate and understand the point you are trying to make, but feel it worthwhile to make the counterpoint that it isn't black and white, especially when it comes to names.

ENTIRE THREAD

Name string not working in SQL Posted by Roy Slough @ 5/21/2012 9:30:37 PM
RE: Name string not working in SQL Posted by Anders Altberg @ 5/22/2012 2:29:49 AM
RE: Name string not working in SQL Posted by Roy Slough @ 5/22/2012 9:26:01 AM
RE: Name string not working in SQL Posted by Anders Altberg @ 5/22/2012 11:43:01 AM
RE: Name string not working in SQL Posted by Mike Yearwood @ 5/22/2012 3:49:58 PM
RE: Name string not working in SQL Posted by Roy Slough @ 5/22/2012 4:02:45 PM
RE: Name string not working in SQL Posted by Mike Yearwood @ 5/22/2012 8:21:17 PM
RE: Name string not working in SQL Posted by Roy Slough @ 5/24/2012 8:48:35 AM
RE: Name string not working in SQL Posted by Mike Yearwood @ 5/24/2012 4:59:18 PM
RE: Name string not working in SQL Posted by tushar @ 5/24/2012 8:08:37 PM
RE: Name string not working in SQL Posted by Samir Ibrahim @ 5/30/2012 9:05:13 PM