Re: What databases have taught me
Date: 23 Jun 2006 21:24:15 -0700
Message-ID: <1151123055.927472.64310_at_c74g2000cwc.googlegroups.com>
> ... ad hoc queries as simply as even SQL ...
I would be interested to see if SQL is simpler for the following dbd example which represents a Food Judging Contest. There are three persons. The first named john (aka johnathan) is a judge. The second named john (aka johnny) is a contestant. The third whose name is unknown is a spectator and his age is 28.
There are four food entries. The first is named leftOver1 which is soft and spicy The second is named apple1 which is crunchy and sweet. The third is named broccoli1 which is crunchy. The fourth is named tomato1 which is soft, sweet and sour.
Judge john likes leftOver1 and tomato1. Contestant john likes apple1 and tomato1. Spectator likes broccoli1 and tomato1. In addition, judge john likes contestant john.
The end of the script has a number of queries. Details at www.dbfordummies.com/Example/Ex039.asp Received on Sat Jun 24 2006 - 06:24:15 CEST