Приложение E

---

ТАБЛИЦЫ, ИСПОЛЬЗУЕМЫЕ В SQL

 
 
====================  ТАБЛИЦА 1:  ПРОДАВЦЫ  ================ 
 
      ---------------------------------------------- 
        snum  |   sname   |  city        |   comm 
      --------|-----------|--------------|---------- 
        1001  |  Peel     |  London      |    .12 
        1002  |  Serres   |  San Jose    |    .13 
        1004  |  Motika   |  London      |    .11 
        1007  |  Rifkin   |  Barcelona   |    .15 
        1003  |  Axelrod  |  New York    |    .10 
       --------------------------------------------- 
 
 
 
==================  ТАБЛИЦА 2:  ЗАКАЗЧИКИ  =============== 
 
       ---------------------------------------------- 
        cnum  |  cname     | city    | rating | snum 
       -------|------------|---------|--------|------ 
        2001  |  Hoffman   | London  |   100  | 1001 
        2002  |  Giovanni  | Rome    |   200  | 1003 
        2003  |  Liu       | SanJose |   200  | 1002 
        2004  |  Grass     | Berlin  |   300  | 1002 
        2006  |  Clemens   | London  |   100  | 1001 
        2008  |  Cisneros  | SanJose |   300  | 1007 
        2007  |  Pereira   | Rome    |   100  | 1004 
       ---------------------------------------------- 
 
 
 
==================  ТАБЛИЦА 3:   ПОРЯДКИ  ================== 
 
       ----------------------------------------------- 
        onum  |    amt    |    odate    | cnum | snum 
       -------|-----------|-------------|------|------ 
        3001  |    18.69  |  10/03/1990 | 2008 | 1007 
        3003  |   767.19  |  10/03/1990 | 2001 | 1001 
        3002  |  1900.10  |  10/03/1990 | 2007 | 1004 
        3005  |  5160.45  |  10/03/1990 | 2003 | 1002 
        3006  |  1098.16  |  10/03/1990 | 2008 | 1007 
        3009  |  1713.23  |  10/04/1990 | 2002 | 1003 
        3007  |    75.75  |  10/04/1990 | 2004 | 1002 
        3008  |  4723.00  |  10/05/1990 | 2006 | 1001 
        3010  |  1309.95  |  10/06/1990 | 2004 | 1002 
        3011  |  9891.88  |  10/06/1990 | 2006 | 1001 
       -----------------------------------------------