XML

Files

• cdlib.xml
• cdlib.xsd
• cdlib.xsl
• customerpayments.xml

Exercises

Using customerpayments.xml, answer the following questions using XPath.

1. List all customers.
2. Who is the last customer in the file?
3. Select all customers in Sweden.
4. List the payments of more than USD 50,000.
5. Select the first payments by Toys4GrownUps.com.
6. What was the payment date for check DP677013?
7. Who paid with check DP677013?
8. What payments were received on 2003-12-04
9. Who made payments on 2003-12-04?
10. List the numbers of all checks from customers in Denmark.

Using customerpayments.xml, answer the following questions using XQuery.

1. List all customers.
2. Who is the last customer in the file?
3. Select all customers in Sweden sorted by customer name.
4. List the payments of more than USD 50,000.
5. Select the first payments by Toys4GrownUps.com.
6. What was the payment date for check DP677013?
7. Who paid with check DP677013?
8. What payments were received on 2003-12-04
9. Who made payments on 2003-12-04?
10. List the numbers of all checks from customers in Denmark.