<div dir="auto">The assumption being made here being that I'd numbers are unique, right?</div><div class="gmail_extra"><br><div class="gmail_quote">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:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">@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.<div dir="auto">The designer is either a total novice or deserves disciplinary action.</div></div><div class="gmail_extra"><br><div class="gmail_quote">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><wbr>> wrote:<br type="attribution"><blockquote class="m_-2235429696828705559quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">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. <div dir="auto"><br></div><div dir="auto">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?</div><div dir="auto"><br></div><div dir="auto">Best regards.</div><div dir="auto"><br></div><div dir="auto"><br></div></div><div class="m_-2235429696828705559elided-text"><div class="gmail_extra"><br><div class="gmail_quote">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><wbr>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">@Ronald <div>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.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 24, 2017 at 8:57 PM, Ronald Ojino via kictanet <span dir="ltr"><<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><wbr>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">My rather basic question is how is that database designed...it lacks data integrity (how did that happen?) ..could this be delibrate .<div dir="auto">Regards,</div><div dir="auto">Ronald Ojino</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_-2235429696828705559m_4485730430996656660m_3656037898891506840h5">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><wbr>> wrote:<br type="attribution"></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_-2235429696828705559m_4485730430996656660m_3656037898891506840h5"><div dir="ltr">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.<div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 24, 2017 at 7:03 PM, Barrack Otieno via kictanet <span dir="ltr"><<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><wbr>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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" rel="noreferrer" target="_blank">https://www.standardmedia.co.k<wbr>e/article/2000231105/iebc-regi<wbr>stry-shows-128-926-records-of-<wbr>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" value="+254721325277" target="_blank">+254721325277</a><br>
<a href="tel:+254%20733%20206359" value="+254733206359" target="_blank">+254733206359</a><br>
Skype: barrack.otieno<br>
PGP ID: 0x2611D86A<br>
<br>
______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/KICTA<wbr>Net/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/options/kictanet/jkieti<wbr>%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.</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="m_-2235429696828705559m_4485730430996656660m_3656037898891506840m_908562850422164603m_-6292765774038723651gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><font color="#999999"><br>John Kieti<br>Phone: <a href="tel:+254%20735%20764242" value="+254735764242" target="_blank">+254-735-764242</a> // <a href="tel:+254%20722%20764242" value="+254722764242" target="_blank">+254-722-764242</a><br>Twitter: @johnKieti // Skype: jkieti</font><span><font color="#999999"><cite><b></b></cite></font></span><font color="#999999"><cite><b><br></b></cite>Blog:</font><span><font color="#999999"> </font></span><a href="http://www.gmeltdown.com" target="_blank"><font color="#0000ff">gmeltdown.com</font></a><font color="#336666"> // </font><span><span><font color="#999999">LinkedIn: </font></span></span><a href="https://ke.linkedin.com/in/kieti" target="_blank"><font color="#0000ff"><span style="font-size:14px;line-height:16px;white-space:nowrap">https://ke.linkedin.<wbr>com/in/</span><b style="font-size:14px;line-height:16px;white-space:nowrap">kieti</b></font></a></div><div><div><font color="#999999"><br>The ordinary just won't do</font></div></div></div></div></div></div>
</div>
<br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/KICTA<wbr>Net/</a><br>
<br></div></div>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/options/kictanet/ronoji<wbr>nx%40gmail.com</a><span><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.<br></span></blockquote></div></div>
<br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/KICTA<wbr>Net/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/options/kictanet/arebac<wbr>ollins%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.<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="m_-2235429696828705559m_4485730430996656660m_3656037898891506840gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div><div><div><div>Regards, <br><br></div>Collins Areba, </div></div></div><div>Kilifi, Kenya.</div><div>Tel: +<b><font color="#38761d">254 707 750 788 </font></b>/ <b><font color="#ff0000">0731534124</font></b><br>Twitter: @arebacollins.<br></div></div>Skype: arebacollins<br></div></div></div></div>
</div>
<br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/KICTA<wbr>Net/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/options/kictanet/jkieti<wbr>%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.<br></blockquote></div></div>
</div><br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/KICTA<wbr>Net/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/m<wbr>ailman/options/kictanet/ronoji<wbr>nx%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.<br></blockquote></div><br></div>
<br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/<wbr>KICTANet/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/options/kictanet/<wbr>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.<br></blockquote></div></div>