Design database using XML and evaluate queries.

It is a simple xml demo using altova.M5X6SH23V6Q9
You can download the altova trial version here
http://www.altova.com/download-trial/
When you download you wll get the key for trial version on your mail id.
Steps:
1)

 

2)

 

3)

 

4)

 

5)

 

6)

 

7)

 

 8)

 9)

 

 10)

 11)

The different queries you can evaluate!
Queries

1)
xquery version "1.0";

{
for $i in doc ("sample.xml")//clg_tuple
where $i/ cid<3 return
{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}


2)
xquery version "1.0";

{
for $i in doc ("sample.xml")//clg_tuple
where $i/ cid=3
return

{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}


3)
xquery version "1.0";

{
for $i in doc ("sample.xml")//clg_tuple
where $i/ cid>3
return

{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}


4)
xquery version "1.0";

{
for $i in doc ("sample.xml")//clg_tuple
where $i/ addr="wagholi"
return

{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}