Information Technology Reference
In-Depth Information
Balance Table
Clientid
Stockid
Bookbalance
seqno
600001
000001
10000
1
600001
000941
1000
2
600002
000001
1000
1
600003
000011
1000
1
600003
000012
500
2
AccountExecutive Table
aeid
Lastname
firstname
Seqno
AE0001
Franky
Chan
1
AE0002
Grace
Yeung
1
AE0003
Paul
Ho
1
The relational schema is pre-processed and translated to XML schema. From the
relational tables above, the EER model is created (Fig. 5.14 ):
m
1
client_Accoun
tExecutive
Client
has
1
n
n
Balance
AccountExecutive
place
1
of
n
1
1
1
ClientOrder
trade
Stock
1
has
n
Execution
 
Search WWH ::




Custom Search