I think we are making the classic mistake programmers make; given a problem, jump straight to solving it in technology without doing due diligence and doing the bits in between problem and software.
IMHO, for and undertaking as such as this, the primary key in the database is the LEAST of your problems.
I would think that solving the human issues (privacy, accessibility from ASAL, security etc) would have precedence.
@josh so what would be the primary key or foreign key for that matter? the problem is not the information but the kind of information about you that would be accessible to those who should not have access to it. In the case of the drivers license guess its the amount of information returned to anyone that is the problem and not that the primary key was the social security no. Plus if information about you is being stored in different institutions or government agencies how else would they link your data across all the db's. Any system can be abused be it computers or paper systems. What would you suggest as the next step?
--If the human brain were so simple that we could understand it, we would be so simple that we couldn't. - Emerson M. Pugh
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke