|  Let me ask my question differently.  I don't understand the
|  constraint of the left to right mapping to the database table
|  description.  What I got from your prior message is that the terms had
|  to be listed in the business rule statement in the order that the
|  columns appear in the row.
|
|  Consider your case study from the tutorial and my unit number and BP
|  ID.  So the person is identified within his/her unit and we are
|  tracking what they like.
|
|  If the database row is defined as follows, how would I write the rules from the tutorial?
|
|  Unit_Id, BP_Id, Person_Name, Time_Of_Day_For_Snack, Favorite_Color, Favorite_Snack
|
|  Thanks,  Terry



|
|  url:12.345.67.89  dbms:9i  dbname:ibldb tablename:TERRY_1  port:1521  id:anonymous  password:oracle
|  ----------------------------------------------------------------------------------------------------------------
|  Oracle table some-Unit_Id some-BP_Id some-Person_Name some-Time_For_Snack some-Favorite_Color some-Favorite_Snack
|
|  In real operation with Oracle, the above rule ( with a real URL etc ) would be used instead of the table below



Oracle table this-Unit_Id this-BP_Id this-Person_Name this-Time_For_Snack this-Favorite_Color this-Favorite_Snack
=================================================================================================================
               U1          BP5        Alberto          12:30              Orange              Pretzels
               U2          BP3        Francesco        11:11              Red                 Popcorn
               U3          BP2        Naomi             6:20              Aquamarine          Chips
               U4          BP9        Frederick         7:40              Red                 Chips


Oracle table some-Unit_Id some-BP_Id some-person some-time-of-day some-Favorite_Color some-snack
---------------------------------------------------------------------------------------------------------
that-person likes to eat that-snack at that-time-of-day


Oracle table some-Unit_Id some-BP_Id some-person some-Time_For_Snack some-color some-Favorite_Snack
-----------------------------------------------------------------------------------------------------------------
that-person likes that-color


some-person likes to eat some-snack at some-time-of-day
-------------------------------------------------
that-person likes to eat that-snack


some-person likes to eat some-snack
that-person likes some-color
---------------------------------------------------
that-person would like to eat that-color that-snack


some-person1 is less than some-person2
----------------------------------------------------------------------------
the name that-person1 comes before the name that-person2 alphabetically


some-person1 likes to eat some-snack
some-person2 likes to eat that-snack
the name that-person1 comes before the name that-person2 alphabetically
-----------------------------------------------------------------------------
that-person1 likes to eat the same snack as that-person2