Models Tour

1
?TShirt

..............................

TShirt sam1

TShirt "Sam's favorite"

ex1, ex1b


2
?TShirt Red
        Green
        Purple   //a comment!

..............................

TShirt sam2 //another comment!
Red

TShirt sam3
Red
Purple

ex2


3
?TShirt Color Red
              Green
              Purple

..............................

TShirt sam2
Red //alternatively, Color Red

TShirt sam3
Red
Purple

TShirt sam4
Color

ex3


4
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve //choose one
                    ShortSleeve

..............................

TShirt sam15
Red
LongSleeve

TShirt sam15.2
Red
LongSleeve

TShirt sam15.2
ShortSleeve

ex4


5
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType

..............................

TShirt sam16
Date 1997   // or Purchased Date 1997
ShortSleeve //order irrelevent
Purple

TShirt Sam98
Purchased 1997 //WRONG

ex5


6
field   can contain                  examples
-------------------------------------------------------------------
Text      nearly anything!           "Hi Sam", 22, or 5.5
Int       whole numbers              22, but not "Hi Sam" or 5.5
Float     decimal or whole numbers   22 or 5.5, but not "Hi Sam"
DateType  legitimate dates           1997, 1997-07-14_13:02:19


7
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType
                  Price UNIQUE Float
        Remarks Text
        Rating UNIQUE Int

..............................

TShirt Sam30
Price 12.95
Red
Remarks "faded quickly"
Remarks "flimsy seams"
Rating 2

TShirt Sam30
Remarks "oversized"

ex7


8
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType
                  Price UNIQUE Float
        Remarks Text
	Rating UNIQUE Int
        Damage DateType Text

..............................

TShirt sam26
Damage 1995 "tomato sauce"

TShirt sam27
Damage 1996

TShirt Sam28
Damage 1995 "grass stain"
Damage 1996 "tomato sauce"
Damage 1996 "bleach"
Damage 1997 "dog"

TShirt sam28
Damage "tomato sauce" //WRONG

ex8


9
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType
                  Price UNIQUE Float
        Resembles ?TShirt
        Remarks Text
	Rating UNIQUE Int
        Damage DateType Text
        Borrowed_by ?Person

?Person Address Text

..............................

TShirt sam16
Borrowed_by "Sarah"

Person "Sarah"
Address "825 E. 30th St, Bryan TX 77840"

TShirt sam17
Borrowed_by "Alice"

ex9


10
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType
                  Price UNIQUE Float
        Resembles ?TShirt
        Remarks Text
	Rating UNIQUE Int
        Damage DateType Text
        Borrowed_by ?Person XREF Shirt

?Person Address Text
        Shirt ?TShirt

..............................

TShirt sam16
Borrowed_by "Sarah"

Person "Sarah"
Address "825 E. 30th St, Bryan TX 77840"

ex10


11
 sam16     -----?TShirt Borrowed_by ?Person XREF Shirt
           |                           |           |
   |       |                           |           |
   |       |            1. Find        |           |
   |       |       ---------------------           |
   |       |       |   this ?Person                |
   |       |       |                               |
   |       |       |                               |
   |       |       |               2. Find         |
   |       |       |      --------------------------
   |       |       |      |      label Shirt
   |       |       |      |
  \|/      |       |      |
           |       |      |
 Sarah     |    ?Person Shirt ?TShirt
           |                      |
           |                      |
           |                      |
           |   3. Fill in field   |
           ------------------------
               with TShirt name


TShirt sam16
Borrowed_by "Sarah"

Person "Sarah"
Address "825 E. 30th St, Bryan TX 77840"
Shirt sam16

ex11


12
?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType
                  Price UNIQUE Float
        Resembles ?TShirt
        Remarks Text
	Rating UNIQUE Int
        Damage DateType Text
        Borrowed_by ?Person XREF Shirt

?Person Address Text
        Shirt ?TShirt XREF Borrowed_by

..............................

TShirt sam40
Borrowed_by "Sally"

Person Ed
Shirt sam50

ex12


13

I. TShirt
  A. Color
    1. Red
    2. Green
    3. Purple
  B. Type
    1. LongSleeve
    2. ShortSleeve
  C. Purchased
    1. Date
    2. Price
  D. Resembles
  E. Remarks
  F. Rating
  G. Damage
  H. Borrowed_by

?TShirt Color Red
              Green
              Purple
        Type UNIQUE LongSleeve
                    ShortSleeve
        Purchased Date UNIQUE DateType
                  Price UNIQUE Float
        Resembles ?TShirt
        Remarks Text
	Rating UNIQUE Int
        Damage DateType Text
        Borrowed_by ?Person XREF Shirt

?______.*____.*__
        |     |____
        |     |_____
        |___........*_________
        |           |__________
        |________.*___ I
        |         |____ F
        |______T
        |_____D T
        |__________ ?
 

14
?Allele
?______.*___....*_________ ? 
        |       |________T
        |       |____________ ?
        |_____.........*___ ?
        |              |_________ ?
        |_______ ?
        |_______________
        |________.......*_____ T
        |               |___   D
        |               |______ T T
        |               |________T
        |               |___________________T
        |               |___________ ?
        |               |___________ ? 
        |_______ ?  #
        |_________ ?
        |_____ ?
        |_______........*__ ?  #
        |               |___________....*______ ? 
        |               |               |__________ ? 
        |               |               |___________ ? 
        |               |               |_________ ? 
        |               |               |_____________ ? 
        |               |               |______________ ? 
        |               |_____T
        |__________.....*________ ? 
        |               |________
        |               |_______
        |               |____________
        |               |___
        |               |____________________...*_____________
        |               |                       |_____________
        |               |____
        |               |_______........*________________
        |               |               |___________________
        |               |_______
        |               |_____
        |_____ ? 
        |________ ?