Forgot your password?
Document Actions
hw9.html
CS 311: Databases
Final Project
(Homework 9)
due on May 12
The last phase of your database project is to add a Java front-end to give non-sql users access to your data. You should select at least 5 different activities to enable with your program. These might be queries, inserts, or data modifications; at least one of these activities should change the data in your tables and at least one should be a query. You can orchestrate these through a GUI program with a menu, through a text-based menu, or even as a suite of separate programs.
Here are a few more details:
-
At least one of the queries should be based on information supplied by the user (i.e, for the Oberlin database I have used for a lot of class examples, a query might be to ask for the classes being taught by a particular faculty member or the classes taken by a particular student.)
- Set up the data insertion or modification activity to make it possible for a user to enter data that violates one of your database constraints. For example, my Oberlin database might make it possible to add a new instructor to a course or to add a new course. In doing this one might enter a crn for a non-existant course. Your program should handle such bad data smoothly.
- Every activity should give some feedback to the user, even if it is just "command succeeded".
- The activities you implement in this way should include the major activities
one would want to do with your database. For example, with my Oberlin database
I might include
- Listing each course and its total enrollment
- Listing all of the students enrolled in a given section.
- Listing all of the courses taught by a specific faculty member.
- Enrolling a student in a given section.
- Adding a new course.
- Adding a new student
- Firing a faculty member and deleting all of his/her classes.
- You should include a README file with a brief user's guide to help me figure out how to use your program(s).
Package all of this up in a directory and use handins to submit it. This is due on the last day of classes: Friday, May 12.