CSc 8711. Databases and the Web
Spring 2004, Take Home Exam
Due: Tuesday, May 4, 2004
Note: Paper is due: Friday May 7th by midnight.

1. Consider the XML data for the bulletin board database in postings.xml. Write an XSLT program to transform this XML data file into an HTML web page similar to the web page you designed in programming assignment 1.
2. Consider the XML data for the Mail Order database in mo.xml. Write XQUERY queries for the following:

   Get the names and street addresses of customers who have placed at least one order.

   Get numbers and names of customers who have ordered part 10506.

   Get numbers and names of customers who have ordered a part from an employee in Wichita.

3. Consider the database in movies.sql. Write queries in Oracle SQL to answer the following:

   Get the titles and years of all crime movies.

   Get the names of persons who have acted in a movie and also been the sole director of the same movie.

   Get the titles and years of movies in which James Caan has acted.

   Please refer to Chapter 8 (XMLType in Oracle) for this problem.
4. Write XML schemas for the following data:
   (a) Write an XML Schema for problem 1 postings data.
   (b) Write an XMLSchema for problem 2 mailorder data.
   (c) Write an XML Schema for the data described in transcript.xml. StudId element contains 9 digit social security numbers; Sem element contains a letter (F, S, or U) followed by a 4-digit year; Grade element contains one of the grades: A, B, C, D, F, IP, S, U.

NOTE:

• For problem 1, submit only the xsl file named postings.xsl.
• For problems 2 and 3 you must submit screen captures. To capture terminal output use the instructions in capture.html.
• For problem 4, you must use the validation program illustrated in XMLSchema Validation. Show couple of examples of valid data and couple of examples of invalid data.