
270 VisualAge for Java Version 3: Persistence Builder with GUIs, Servlets, and JSPs
ITSOBANK Database Implementation
We extended the database used in the previous redbooks to add more
functionality. This ITSOBANK database is now being used in a series of
redbooks on VisualAge for Java and VisualAge Generator.
Figure 175 shows the physical database design and the relationships
between the tables.
Figure 175. ITSOBANK Tables and Relationships
ACCID BANKID CUSTID ACCTYPE BALANCE MINAMT OVERDRAF BILLTITLE
BANKID BANKNAME
CUSTID TITLE FNAME LNAME USERID PASSWORD BANKID
CARDID PIN CARDTYPE CUSTID
TRANSID ACCID TRANSTYPE TRANSAMT TRACCID
ACCTYPE POLNAME POLVAL ...