Note for the project

Project Description

Goals
- Reading about XML, XML schema, and XML query languages
- Practicing the development of databases using XML technologies
Requirements
- Demonstrating the understanding of XML and Web Data through the development of XML schema, XML, XPath, XSLT, and XQuery
- Presentation (15') for each team at the end of the semester
Steps
1. Design a database with the following properties: has at least 3-4 tables; integrity constraints: keys and foreign keys;
2. Select 3 or more frequently asked questions about the database; at least one question must involve a join between at least two tables; For each query, provide a specification of the presentation of the answer that, in your opinion, is the best way for answering it.
3. Create XML documents for storing the information of the database.
4. Make sure that your XML documents represent valid instance of the database. To achieve this, you need to define XML schema for your documents.
5. Your XML schema must at least contain some definition of complexType, simpleType, and keys.
6. Create XSL documents for answering the questions from (b) that does not require joins; and XQuery document for questions from (b) that requires join.
7. You need to make sure that your documents and queries are valid.
Documentation and Presentation
- A document detailing (a) and (b)
- XML documents available on the website (either one of the team member)
- A 10-12' presentation and 3-5' question and answering on the last day of the class
Grading
- 10 points total
- 1 for database design (table descriptions, keys, etc.)
- 1 for discussion on questions to the database
- 2 for XML schema and XML documents (completeness of XML schema, XML documents)
- 2 for XSL documents
- 2 for XQuery documents
- 2 for presentation
Useful Links
1. The W3C website http://www.w3.org/ has everything you might need. I list some that could be useful below.
2. The W3 School web site http://www.w3schools.com/default.asp can help you checking your XML documents (see http://www.w3schools.com/dom/dom_validate.asp for more detail). NOTE: I tried and it seems that pasting the XML file in the box works and specifying the URL does not work. Nevertheless, you can verify a XML document for syntax error using this link.
3. The link http://support.x-hive.com/xquery/index.html is good for testing your skill with XQuery.
4. Examples of XSL can be found in http://www.topxml.com/xsltstylesheets/default.asp.

Son Cao Tran

Last modified: 03/01/2006 01:37 PM -0700