FBI computer system flops:
http://www.cnn.com/2005/US/02/03/fbi.computers/index.html
For the terrorist-tracking system, just get a big-ass Oracle RDBMS, typical add/change/delete/query-by-example/ACL (CrudScreen) user-interface tools, CrystalReports, and put in the following schema:
suspects // table name
----------
suspectID // auto-gen
priority // Priority risk assigned to suspect
suspectReasonCode // reason for being a suspect
suspectFirstName
suspectMiddle
suspectLastName
suspectAliases
--------------
aliasID //auto-gen
suspectRef // foriegn key to "suspects" table
aliasFirst
aliasMiddle
aliasLast
usedFromDt // used from date
usedToDt
suspectLocations
----------
locationID // auto-gen
suspectRef
locatFromDt // start date at location
locatToDt
locType (residence, airport, hotel, etc.)
longitude
latitude
(insert typical address columns...)
fieldNotes
-------------
suspectRef
agentRef // ID of agent authoring note
locationRef
encounterRef // if applicable (see below)
textNote // text note for small stuff
docRef // document reference (such as MS-Word file name)
encounters // meetings or close encounters between multiple suspects
------------
encntrID // auto-gen encounter ID
encntrDescript
encntrDt // date of encounter
locationRef // foriegn key to "suspectLocations" table
encounterParticipants
-----------
encntrRef
suspectRef
fromDateTime
toDateTime
I'm done. Now where's my 30 mil?
--top