Application development with DB2 pureXML - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 57

discussed in detail in Appendix A, “Setup procedure and sample data” on
page 295. In summary, we have used two database tables for our example as
shown in Table 2-1 and Table 2-2.

Table 2-1 Movie database table

ID int NOT NULL PRIMARY KEY

INFO XML

Table 2-2 Moviereview database table

REVIEWID int NOT NULL PRIMARY KEY

REVIEW XML

The sample XML data for Movie is shown in Example 2-1.

Example 2-1 Movie.xml

<?xml version="1.0" encoding="UTF-8"?>
<movie id = "345">
<heading>
<title>Crossroads</title>
<rating>***</rating>
</heading>
<movie-details>
<genres>Drama, Romance and Remake</genres>
<MPAArating>PG</MPAArating>
<country>US</country>
<year>2006</year>
<running-time>1 hr. 38 minutes</running-time>
<production>
<studio>RR Pictures</studio>
</production>
</movie-details>
<synopsis>
A grouchy old college professor who lived in a delapidated cabin near
the lake takes an interest in a frustrated writer who suffers from
habitual writer's block.
</synopsis>
<credits>
<writer>David Anderson</writer>
<director>Alex Ostern</director>
<photography>Charles Govasky</photography>
<actors>
<actor special="yes" type="lead" gender="M">Karl Thomas</actor>
<actor type="lead" gender="F">Sandra Casper</actor>
<actor type="lead" gender="M" special="yes">Peter Walsh</actor>