Programming Assignment #8
Storing XML in a Relational Database

Due on Tuesday April 15 before midnight.


The purpose of this project is to learn how to store XML data in a relational database.

This project must be done individually. No copying is permitted. Note: We will use a system for detecting software plagiarism, called Moss, which is an automatic system for determining the similarity of programs. That is, your program will be compared with the programs of the other students in class as well as with the programs submitted in previous years.

Note that, if you use a Search Engine to find similar programs on the web, we will find these programs too. So don't do it because you will get caught and you will get an F in the course (this is cheating). Don't look for code to use for your project on the web or from other students (current or past). Just do your project alone using the help given in this project description and from your instructor only.


You will develop this project on Omega or your own PC/laptop. If you want use your own PC, you need to install SQLite. Look at the file createDB.sql from project5. You need to create an sql schema in a file createCS.sql and create your database using:

sqlite3 mydb.sqlite
.read createCS.sql

Project Requirements

You will use the XML file cs.xml with the DTD department.dtd. You need to parse this file and store it into a relational database and then convert the relational data back to XML.

What to Submit

Use the form below to submit your java file and your relational schema:

Submit Project #8:

Last modified: 04/08/14 by Leonidas Fegaras