Terrorist Tracking Mayhem

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