Ïðèëîæåíèå 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
       -----------------------------------------------