USERPROFILE
as400
USERINFO
netfinity
first_name
ncf
last_name
nw
USERVERIFY
email_address
s390
username
date_joined
rs6000
has attribute
has profile
password
birth_date
scalable
address
vm
username
vse
windows
other
has orders
username
USERORDERS
username
order_timestamp
product_id
order_id
Figure 54. Entity Relationship diagram of our DB2 database structure
We can now list the field names and their attributes for each of the four
database tables in the following sub sections.
USERVERIFY
The USERVERIFY table contains the username and password. The fields of
this table are shown in Table 1.
Table 1. The USERVERIFY database table
Field name
Data type
Length
Nullable
username
varchar
20
no
password
varchar
20
no
The username field will be the search key in this table; hence, we will also
allocate it to be the primary key in the table.
Neither username nor password are allowed to be empty.
64
Linux Web Hosting with WebSphere, DB2, and Domino




  

Home

About Services Network Support FAQ Order Contact
 

Linux Web Hosting

Our partners:Jsp Web Hosting Unlimited Web Hosting Cheapest Web Hosting  Java Web Hosting Web Templates Best Web Templates PHP Mysql Web Hosting Interland Web Hosting Cheap Web Hosting PHP Web Hosting Tomcat Web Hosting Quality Web Hosting Best Web Hosting  Mac Web Hosting 

Lunarwebhost.net  Business web hosting division of Vision Web Hosting Inc. All rights reserved