class management system and a database

Document Preview:

1 SIT751 Assignment 2 – Class Management System Due Date: 5pm, Wednesday May 28, 2014 Total marks: 20 Project Details: In this assignment, students will develop a form based front end for a class management system and a database using a combination of JDBC commands, SQL, and Swing GUI components to allow users to query, insert, update and delete records using a simple graphical user interface. The basic system is composed of three linked tables: a student table, a class table, and a lecture table. The relational schema of these tables is shown below: The system will support the addition, modification and deletion of students, lectures and classes, as well as support different types of queries on a variety of different database fields, such as: who are the students of a given lecturer. Part A -Basic Requirements: 60% The basic requirements of this assignment are to implement the database front end using Java swing as discussed above. In particular, forms should be developed to cater for the following types of data entry, and queries: Student Records: ? Add new student records; ? Modify existing student records; ? Delete existing student records; ? Find a student record: by name, and by mobile. Class Records: ? Add new class records; ? Modify existing class records; ? Delete existing class records; ? Find a class record: by unit code, and by unit name. It is expected that the add and modify record interfaces will be similar, as will the find and delete interfaces so it might be an idea to make the different functionalities available under the same interface. For example, the add/modify interface will allow both insert and update operations and the find/delete interface will allow queries and deletes. Access to these form interfaces should be made available from a main form, through which users can activate the different functionalities of the program such as add, update, delete, find, check out video, and check in video. To facilitate ease of use students should...