Re: Data Model for the Vote Entry Station

From: <dr-jekyll_at_att_dot_net>
Date: Tue Apr 20 2004 - 18:41:54 CDT

Hi Ed,

> It is possible that you might have two candidates with the same last or
> first name. I'd recommend that you change the name field to have a Title,
> first, initial, surname and suffix field to guarantee unambiguous sortings.

I think you're referring to CFO_Name in the CFO (Candidate For Office) Table. The phrase "Name as it is to appear on the ballot" is just about word for word out of the forms that candidates complete when filing to run for office. This name field is separate from the candidate's name for identification purposes, which normally is the voter registration information. Candidates names as they appear on the ballot are made unique, when necessary, by voting officials by whatever rules they use. For example, Congressman Ralph Hall from Texas once ran against another man named Ralph Hall in a primary. The other Ralph Hall distinguished his name by his middle initial, while the current Congressman Ralph Hall distinguished his name by using his town of residence, Rockwall. They included the candidates' town names on the ballot.

Parsing a person's name into last, first, title, etc is certainly the norm in most business Data Modeling. I really don't believe we'll see a need to do that with this field, but if we do, it won't be difficult to change.

If I'm misunderstanding you, my cell phone number is 312.804.4233. Anywhere in the US is a local call for me, so I'll call you back and save you the long-distance charges.

= The content of this message, with the exception of any external
= quotations under fair use, are released to the Public Domain
Received on Fri Apr 30 23:17:14 2004

This archive was generated by hypermail 2.1.8 : Fri Apr 30 2004 - 23:17:29 CDT