cjj
15 Dec 2009
UK, Ireland / Applying for Polish citizenship; problem with old style UK birth certificates [7]
by the time I finished reading this, the voices in my head were saying "computer system" and "what idiot designed the database"
In the old days - with everything hand-written in books - there was at least room for manoeuvre. Now, once some dork of a designer decides "oh, yes, we'll make /this/, /this/ and /this/ to be the key fields", there's often nothing the poor users of the system can do.
A few years ago now I was sitting at my desk at work one day and overheard the senior designer talking to the database designer ... one of them announced happily "and of course PESEL will be the primary key". They were designing an HRMS system - round a database - and this design decision would have meant that every person entered into it would need a PESEL. I fought the urge to say nothing but had to pipe up with "I don't have a PESEL" (despite being at work and paying taxes). That stunned them - they couldn't imagine someone /not/ having a PESEL. Actually, during my treatment at a local hospital around that time they had to make up a PESEL for me ... one that wasn't 'real' but which still got through the field validation on the data entry screens...
In this case someone has probably designed an unholy mismash of data entry validation based on recent birth certificates and some polish-bureaucracy-based understanding of "how things are"
by the time I finished reading this, the voices in my head were saying "computer system" and "what idiot designed the database"
In the old days - with everything hand-written in books - there was at least room for manoeuvre. Now, once some dork of a designer decides "oh, yes, we'll make /this/, /this/ and /this/ to be the key fields", there's often nothing the poor users of the system can do.
A few years ago now I was sitting at my desk at work one day and overheard the senior designer talking to the database designer ... one of them announced happily "and of course PESEL will be the primary key". They were designing an HRMS system - round a database - and this design decision would have meant that every person entered into it would need a PESEL. I fought the urge to say nothing but had to pipe up with "I don't have a PESEL" (despite being at work and paying taxes). That stunned them - they couldn't imagine someone /not/ having a PESEL. Actually, during my treatment at a local hospital around that time they had to make up a PESEL for me ... one that wasn't 'real' but which still got through the field validation on the data entry screens...
In this case someone has probably designed an unholy mismash of data entry validation based on recent birth certificates and some polish-bureaucracy-based understanding of "how things are"