Re: goto contest

It is a toy example; or more accurately, a "thought experiment". However, I suppose the CIA/FBI might have something like it to track suspicious people, such as John Lennon. It would be a huge database of info about people. I imagine most of such a system would either be ad-hoc querying and alert reports that signal suspicious behavior based on some score-giving algorithms. I suspect the schema would look something like:

Table: People
-------------
PersonID
SSN
FirstName
Middle
Last
BirthDate
HairColor
ImageURL
FatherRef (foriegn key to People)
MotherRef
....

Table: LivedLocations
-----------
liveLocID
personRef
LocType (Apt, house, etc.)
AddressRef (ref to location table)
....
FromDate
ToDate
....

Table: WorkedAt
----------
....

Table: countriesVisited
--------------
....

Table: suspiciousEncounters
--------------
personRef1
personRef2
AddressRef
spottedBy
se_notes
.....

(However, because multiple people can meet, perhaps we need a Meeting table, and then a many-to-many table for each person at the meeting.)

Post #152,119 by admin 4/21/04 7:22:43 PM Reply	Re: goto contest Then post a working example. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #152,125 by tablizer 4/21/04 8:41:47 PM 4/21/04 8:43:23 PM Reply	I already did an XBase version. (There is also an L version) [link\|http://www.geocities.com/tablizer/shapes.htm\|http://www.geocities...blizer/shapes.htm] However, shape examples don't tell us much either way. In biz apps, the rules are determined mostly by capricious humans, not Mother Nature. Mother Nature does not change the rules very often, and thus shapes are not a very useful metaphore to study change impact. ________________ oop.ismad.com Edited by tablizer April 21, 2004, 08:43:23 PM EDT Expand All History
Post #152,130 by admin 4/21/04 9:09:04 PM Reply	I'm not talking about shapes. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #152,137 by tablizer 4/21/04 9:13:31 PM Reply	What are you talking about? There is always this to compare: [link\|http://www.geocities.com/tablizer/chal06.htm\|http://www.geocities...blizer/chal06.htm] ________________ oop.ismad.com
Post #152,139 by admin 4/21/04 9:13:55 PM Reply	Your "peoples" example. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #152,191 by tablizer 4/22/04 2:39:34 AM 4/22/04 2:44:39 AM Reply	People database It is a toy example; or more accurately, a "thought experiment". However, I suppose the CIA/FBI might have something like it to track suspicious people, such as John Lennon. It would be a huge database of info about people. I imagine most of such a system would either be ad-hoc querying and alert reports that signal suspicious behavior based on some score-giving algorithms. I suspect the schema would look something like: Table: People ------------- PersonID SSN FirstName Middle Last BirthDate HairColor ImageURL FatherRef (foriegn key to People) MotherRef .... Table: LivedLocations ----------- liveLocID personRef LocType (Apt, house, etc.) AddressRef (ref to location table) .... FromDate ToDate .... Table: WorkedAt ---------- .... Table: countriesVisited -------------- .... Table: suspiciousEncounters -------------- personRef1 personRef2 AddressRef spottedBy se_notes ..... (However, because multiple people can meet, perhaps we need a Meeting table, and then a many-to-many table for each person at the meeting.) ________________ oop.ismad.com Edited by tablizer April 22, 2004, 02:40:57 AM EDT Edited by tablizer April 22, 2004, 02:43:22 AM EDT Edited by tablizer April 22, 2004, 02:44:39 AM EDT Expand All History

Welcome to IWETHEY!