Time to move things into a MySQL database!
1. Develop a Database schema for your XML structure. Since it's tricky if not impossible to model hierarchical structures neatly in a DB table, flatten the creator structure in the schema to three attributes: creatorname, creatoremail and creatorhomepage. Also: limit the number of keywords to 5 (five). This schema is to be represented by an .sql file and should run with any MySQL installation. (25)
2. In the same .sql file, place INSERT statements that insert your current XML structure into the database (15).
Note: For the DB name use your Argonet name, like BO4711; for the table name use gallery with your Argonet name appended, such as GalleryBO4711. I will run all scripts against a DB and I'm not in the mood to deal with duplicate DB or table names :-)
ARGONET NAME = RRM16
3. Write a Java application (no Swing necessary) that supports three functions
a) a nice welcome screen and two options: Search for an image and Add an image (10 points)
b) Search the search will be performed by connecting to your DB. The results have to be just displayed on the screen (you can't click the links, of course!). (20 points)
c) Add lets the user add a new image by specifying each of its elements line by line. This image should then be added to the DB. (20 points)