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