Dear Sir or Madam, 

the following Request/Order was submitted from the Product Catalog Webpage: 

Title               :Mrs. 

First/last name     :Kathy Smith 

Company             :ITSO 

Address             :650 Harry Rd. 

Zip code, City      :San Jose Ca 

e mail              :kathy@yahoo.com 

Phone               :408 927 3633 

Fax                 : 

Customer No.        : 

Item no.    Manufacturer  Model                    Quantity 

16272       AUDI          80 Avant (8C, B4)        1 

16633       VW            PASSAT (3B2)             3 

951041      VW            POLO (6N1)               1 

Figure 3 8   Request/Order information sent to the vendor

3.1.2  Database structure

The database used by the application consists of four tables as described below: 

The table USERS contains the whole customer registration information. 

The table CATALOG contains the item information.

OENUMER is a table, which holds manufacturer item numbers.

SHOPPING_CART is the shopping cart table, which holds the items and user 

information during the order transaction. After the order or request is 

submitted, and an e mail is sent to the vendor, the information is deleted.

For detailed table information see Figure 3 9. 

Note:

These tables only use CHAR, VARCHAR, and INTEGER data types. In 

Chapter 5,  Database porting  on page 89, data type conversion between 

MySQL and DB2 UDB is discussed in detail.

 Chapter 3. Migration scenario 

71