Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How would Homer write an SQL query?

Re: How would Homer write an SQL query?

From: Patrick Ryan <pat_at_halcyon.com>
Date: 2000/03/08
Message-ID: <8a49hu$nvm$1@brokaw.wa.com>#1/1

select recited.tale from recited, muse, hero, deed, city where hero.trait = 'ingenious' and deed.hero_id = hero.hero_id and deed.actitivty = 'Sacked' and recited.recital_id = deed.recital_id and city.city_id = deed.city_id and city.city_name = 'Troy' ;

: "Tell me, O Muse, of that ingenious hero who travelled far and wide after he
: had sacked the famous town of Troy."
 

: AND:
select recited.song from recited, goddess, hero, hero father, deed, city where hero.trait = 'anger' and deed.hero_id = hero.hero_id and deed.impact = 'ills' and deed.parties contains '%Achaeans%' and hero.hero_name = 'Achilles' and hero.father_id = father.hero_id and father.hero_name = 'Peleus' and recited.goddess_id = deed.goddess_id and

Note that the data designer chose not to normalize goddesses with muses, even though they share many of the same properties. Such is the political reality of database design.

 : _The Iliad_ begins with (again to Calliope or another of the Muses):

: "Sing, O goddess, the anger of Achilles son of Peleus, that brought
: countless ills upon the Achaeans."
 

: (The full versions are online at
 

: http://darkwing.uoregon.edu/~joelja/odyssey.html
: and
: http://darkwing.uoregon.edu/~joelja/iliad.html )

: Anyone want to give it a try? I'll give a credit to the writer of the best
: version.
 

: Please send your attempt to mailto:c.chesher_at_unsw.edu.au

: Chris

: --
: Chris Chesher
: Lecturer
: School of Media and Communications
: The University of New South Wales
: Sydney 2052
: c.chesher_at_unsw.edu.au
: http://mdcm.arts.unsw.edu.au

: -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
: http://www.newsfeeds.com The Largest Usenet Servers in the World!
: ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
  Received on Wed Mar 08 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US