- 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.