<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link=blue vlink="#954F72"><div class=WordSection1><p class=MsoNormal>National ID numbers are unique. That is why all the e-government systems being implemented use it to identify a Kenyan citizen uniquely.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows 10</p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='border:none;padding:0in'><b>From: </b><a href="mailto:kictanet@lists.kictanet.or.ke">Collins Areba via kictanet</a><br><b>Sent: </b>Wednesday, January 25, 2017 8:38 AM<br><b>To: </b><a href="mailto:awatila@yahoo.co.uk">awatila@yahoo.co.uk</a><br><b>Cc: </b><a href="mailto:arebacollins@gmail.com">Collins Areba</a><br><b>Subject: </b>Re: [kictanet] IEBC registry shows 128,926 records of shared voter details - Who audits the IEBC database?</p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>The assumption being made here being that I'd numbers are unique, right?</p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 25 Jan 2017 05:23, "Ronald Ojino via kictanet" <<a href="mailto:kictanet@lists.kictanet.or.ke">kictanet@lists.kictanet.or.ke</a>> wrote:</p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal>@Collins/John, i find such a system as very vital and when some IT professionals design its database like junior high school students, it beats logic....what was so hard in using the id no or passportno as its primary key or better still us a composite key...basic stuff that just makes one wonder when such issues arise in a database of such magnitude. Auto-incrementing the primary key here is suicidal in my opinion.</p><div><p class=MsoNormal>The designer is either a total novice or deserves disciplinary action.</p></div></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 24-Jan-2017 11:15 PM, "John Kieti via kictanet" <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a>> wrote:</p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal>There is a tendency among some database designers to avoid setting the "unique" property for database fields other than their system's own auto_increment or otherwise generated primary keys. </p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Am also curious what mechanism is in place to stop me from registering as a voter, first using my passport , then again using my national ID. Anyone?</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Best regards.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Jan 24, 2017 21:20, "Collins Areba via kictanet" <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a>> wrote:</p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal>@Ronald </p><div><p class=MsoNormal>I suspect the offline nature of collection of data and biometric information might have resulted in multiple data points in cases of genuine ID number shared between more than one person (how that happens I have no clue) or trying to register more than once. If you ask me, What should have happened is for them to delete all repeating entries, and leave the burden of proof on the registrants. At least the database would at all times then be accurate.</p></div></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Tue, Jan 24, 2017 at 8:57 PM, Ronald Ojino via kictanet <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a>> wrote:</p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal>My rather basic question is how is that database designed...it lacks data integrity (how did that happen?) ..could this be delibrate .</p><div><p class=MsoNormal>Regards,</p></div><div><p class=MsoNormal>Ronald Ojino</p></div></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal>On 24-Jan-2017 8:06 PM, "John Kieti via kictanet" <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a>> wrote:</p></div></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><div><p class=MsoNormal>IMHO, We need an early spotlight on the competences, capacities and integrity of people running IEBC's ICT functions. We cannot afford to have mediocrity being exhibited in the ICT profession, yet again.</p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Tue, Jan 24, 2017 at 7:03 PM, Barrack Otieno via kictanet <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a>> wrote:</p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal>IEBC Chair Wafula Chebukati said that these cases of multiple<br>registrations are attributed to data entry errors at the time of<br>registration, possible use of one ID to register more than once,<br>attempted registration of more than one person using same ID as well<br>as shared National ID numbers. “The Commission is working closely with<br>National Registration Bureau (NRB) to clean up all the shared IDs. In<br>addition, a team of Registration officers and ICT operators are<br>conducting further cleanup,” said Chebukati. He said that the<br>provisional register will be availed to members of the public for<br>verification once the voter enlistment exercise is over.<br>Read more at: <a href="https://www.standardmedia.co.ke/article/2000231105/iebc-registry-shows-128-926-records-of-shared-voter-details" target="_blank">https://www.standardmedia.co.ke/article/2000231105/iebc-registry-shows-128-926-records-of-shared-voter-details</a><br><br>Of particular interest is the following line : attempted registration<br>of more than one person using same ID as well as shared National ID<br>numbers, do we have competent people managing this important<br>institution?<br><br>Regards<br><br>--<br>Barrack O. Otieno<br><a href="tel:+254%20721%20325277" target="_blank">+254721325277</a><br><a href="tel:+254%20733%20206359" target="_blank">+254733206359</a><br>Skype: barrack.otieno<br>PGP ID: 0x2611D86A<br><br>_______________________________________________<br>kictanet mailing list<br><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/mailman/listinfo/kictanet</a><br>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/KICTANet/</a><br><br>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com" target="_blank">https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com</a><br><br>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br><br>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p></blockquote></div><p class=MsoNormal><br><br clear=all></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- </p><div><div><div><div><div><p class=MsoNormal><span style='color:#999999'><br>John Kieti<br>Phone: <a href="tel:+254%20735%20764242" target="_blank">+254-735-764242</a> // <a href="tel:+254%20722%20764242" target="_blank">+254-722-764242</a><br>Twitter: @johnKieti // Skype: jkieti<b><i><br></i></b>Blog: </span><a href="http://www.gmeltdown.com" target="_blank">gmeltdown.com</a><span style='color:#336666'> // </span><span style='color:#999999'>LinkedIn: </span><a href="https://ke.linkedin.com/in/kieti" target="_blank"><span style='font-size:10.5pt'>https://ke.linkedin.com/in/<b>kieti</b></span></a></p></div><div><div><p class=MsoNormal><span style='color:#999999'><br>The ordinary just won't do</span></p></div></div></div></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<br>kictanet mailing list<br><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/mailman/listinfo/kictanet</a><br>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/KICTANet/</a></p></div></div><p class=MsoNormal>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com" target="_blank">https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com</a><br><br>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br><br>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p></blockquote></div></div><p class=MsoNormal><br>_______________________________________________<br>kictanet mailing list<br><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/mailman/listinfo/kictanet</a><br>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/KICTANet/</a><br><br>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com" target="_blank">https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com</a><br><br>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br><br>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p></blockquote></div><p class=MsoNormal><br><br clear=all></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- </p><div><div><div><div><div><div><div><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Regards, </p></div><p class=MsoNormal>Collins Areba, </p></div></div></div><div><p class=MsoNormal>Kilifi, Kenya.</p></div><div><p class=MsoNormal>Tel: +<b><span style='color:#38761D'>254 707 750 788 </span></b>/ <b><span style='color:red'>0731534124</span></b><br>Twitter: @arebacollins.</p></div></div><p class=MsoNormal>Skype: arebacollins</p></div></div></div></div></div><p class=MsoNormal><br>_______________________________________________<br>kictanet mailing list<br><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/mailman/listinfo/kictanet</a><br>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/KICTANet/</a><br><br>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com" target="_blank">https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com</a><br><br>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br><br>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p></blockquote></div></div></div><p class=MsoNormal><br>_______________________________________________<br>kictanet mailing list<br><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/mailman/listinfo/kictanet</a><br>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/KICTANet/</a><br><br>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com" target="_blank">https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com</a><br><br>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br><br>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></blockquote></div></div><p class=MsoNormal style='margin-left:4.8pt'><br>_______________________________________________<br>kictanet mailing list<br><a href="mailto:kictanet@lists.kictanet.or.ke">kictanet@lists.kictanet.or.ke</a><br><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/mailman/listinfo/kictanet</a><br>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/KICTANet/</a><br><br>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com" target="_blank">https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com</a><br><br>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br><br>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p><p class=MsoNormal><o:p> </o:p></p></div></body></html>