Project : Part 2

(Due : 11/08/2007)

 

?     Best Solution for Project Part 1

?     Tutorials for Project Part 2: <Slides1: DOM Parser>, <Slides2: Sample GUI >, <SampleGUI.java>, <SampleDOMParser.java including data set(dblp.xml and dblp.dtd)>

 

The goal of this project is to design a database for a real application and experience how to populate a database from an XML document data source automatically and how to provide a user-friendly GUI interface to insert data into the database.

 

 

l       Read a Requirements Document

 

 

l       Given the requirements document, you are required to do for this project as follows

 

 

1.       Draw an E-R diagram.

 

2.       Design and create a relational database schema based on your E-R diagram.

 

3.       Implement a software tool able to populate initial database automatically by parsing the DBLP XML record file.

 

?     Tutorials for XML and Java XML parser: 

ü http://www.totheriver.com/learn/xml/xmltutorial.html

ü http://java.sun.com/webservices/jaxp/dist/1.1/docs/tutorial/overview/index.html

ü http://java.sun.com/developer/Books/xmljava/

 

?     Tutorials for GUI in Java: 

ü http://java.sun.com/docs/books/tutorial/ui/features/compWin.html

 

4.       Insert more than 9 publications for each of proceedings, journals, and books into your database by the tool.

 

5.       Implement a GUI-based Insertion System in Java to enable a user to manually insert or modify the data that need to be inserted into your database since the DBLP XML record does not provide you sufficient information for your database.

 

?     There is no restriction on the GUI design, but it should have the functionality that enables a user to insert all data in need into database. Certainly, GUI might be evaluated better if it provides more convenient ways from a user’s point of view.

 

 

l       Submission

 

Send a zip  file to TA via Digital Dropbox in Blackboard with all source codes and necessary files including a PDF/JPEG/PPS file with your E-R diagram. The zip file should include “read.txt” to explain how to compile and run your system, including the information that TA must know in order to grade, such as your teammates. Your program should be executable by “run.bat” file without doing any other extra works. The zip file should be named after your name, for example, for project2 if your name is “David Smith”, then your file should be named as “david_smith_project2.zip”. The name(subject) of your submission in digital dropbox should be “Project2_WSU access ID”, for example : Project2_aq1111.