Database Management

Due Date: Friday, May 2

Points: 30

Introduction: This is the final piece of the project. You will write a java program that accesses your database and write a summary of the project.

Java Program. You need to write a program that inputs a piece of information from the user, uses that piece of information in a query that pulls data from 2 different tables, and then displays the results for the user in an understandable way (the user knows what they are looking at). You will be given an ODBC datasource name and its location on the harddrive. As you work on the program you will need to copy your database to this location on the harddrive and rename it to the required name.

Summary Information. Finally, I would like you to word process a summary of your project that includes the following pieces of information:

• What are some things you learned about the process of developing a database and database management while working through the project. Rather than simply summarizing the different aspects of the project, pick two areas where you felt this project was especially valuable.
• Reflect back on the project, and describe what you would do differently if you were to start over from the beginning (pick a different topic, spend more time on the E-R diagram, not worry so much about the E-R diagram, etc.).
• Compare this project to other aspects of the course (lectures, homework, tests, lab time) in terms of its value (or its potential value if you didn't think the project as structured was worthwhile).

Handing In. When you finish put your java code file and your word processed summary document together in a folder and drag them to the drop folder for the class (g:\fyfe\COSC325\Drop Folder). Also turn in hard copies of the java file and summary.