I don't envy you. A picture is worth a thousand words and that applies to each viewer. Relevance is based on cultural, political, sexual, and a host of other empiricals.
I do have two suggestions, however. First, have a look at Getty Images and Corbis. Get an idea of how they catalog their content. Second, in addition to using the 5-Ws (who what when where how) have a method for the user to add "keys." There will be things you never imagined. I hope this helps. HALinNY => -----Original Message----- => From: [EMAIL PROTECTED] => [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton => Sent: Monday, October 09, 2006 16:48 => To: ProFox => Subject: Design question => => I have been asked to design an application to manage folders => of image files (these are scanned images) The images need => to be retrieved on the basis of 1 or more attributes. An => example may make this clear. => => Image1 is an image of two people (Fred and Tom) taken in => 1987 in Lowestoft => Image2 was taken in London in 2004 => Image3 is an image of Paul (don't know when or where it was taken) => => In order to be able to retrieve images based on one or more => attributes I am considering setting up a table like this => => KeyType KeyValue Image => => Name Fred Image1 => Name Tom Image1 => Place Lowestoft Image1 => Year 1987 Image1 => Place London Image2 => Year 2004 Image2 => Name Paul Image3 => => etc etc => => The idea is to give flexibility to the number of different KeyTypes => => Comments ? Suggestions ? => => Thanks => => => => [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

