Приложение 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 
  -----------------------------------------------