Bank database

The bank model is based on an underlying relational database. The EJBBANK database consists of the tables shown in Figure 10-2.

Figure 10-2. Bank database and tables

Tables

All the tables have a primary key. Some tables have a foreign key that relates the table to another table. The data types used in the tables are for illustration and do not represent a real banking system.

Customer table

The CUSTOMER table includes all the information recorded for a bank customer (Table 10-1).

Table 10-1. Customer table
Column nameTypeLengthKeyNullsDescription
CUSTOMERIDINTEGER PKNoCustomer ID
TITLECHAR3NoNoTitle
FIRSTNAMEVARCHAR30NoNoFirst ...

Get EJB 2.0 Development with WebSphere Studio Application Developer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.