Database Program Translation - Information Systems Reengineering, Integration and Normalization - page 221

Client

* *

*

Client_Account
Executive

ClientOrder Stock Balance

*

Execution

Fig. 5.15 An XML client view in EER model is mapped to a DTD

An XML view of the relational schema on the selection of Client as root is trans-
lated from the EER model into a DTD Graph as follows (Fig. 5.15 ):
Query for selecting all the ClientID and OrderID
SQL Query:

6(/(&7&OLHQW&OLHQW,'2UGHU2UGHU,'
)520 &OLHQW2UGHU

:+(5( &OLHQW&OLHQW,' 2UGHU&OLHQWG,'

Translated XPath query:

& & # _

&OLHQW6WDWHPHQW&OLHQW2UGHU#2UGHU,'

Result from XPath Result:

&OLHQW&OLHQW,'
2UGHU2UGHU,' !2UGHU!
&OLHQW!
&OLHQW&OLHQW,' !
2UGHU2UGHU,'
2UGHU2UGHU,'
&OLHQW!
&OLHQW&OLHQW,' !
2UGHU2UGHU,'
2UGHU2UGHU,'