Java programme cs11

You have been asked to develop a Course Scheduling application for a College. The application will enable two types of Users to perform their necessary functions to schedule courses by semester. The Admin User will perform multiple functions to set up the database so that Students my schedule courses. The functions each User will be able to perform will be described below.

This application should have a very nice GUI interface and will be a database driven application. The database used will be Derby. This application must use good ObjectOriented Design and Programming. The database must use good Object-Oriented Design and Programming. There is a very close correlation between Object-Oriented Design and Database Design. Your application design should include at least four classes besides the main GUI class. Your database access should be in the classes that correlate with the database tables.

This assignment is the first half of the final project and will be submitted as

Final Project Part 1.

This phase of the project will implement the following Admin functions:

Add Semester

A semester is added to the database. The semester is identified by one name.

Add Course

A new course is added to the database. The course is identified by the code for the course, and the description of the course.

Add Class

A new class is added to the database. The class is identified by the semester the course is offered, the code for the course, and the maximum number of students the course will contain that semester.

Add Student

A student is added to the database. The student is identified by a studentID, the student’s first name, and the student’s last name.

This phase of the project will implement the following Student functions:

Schedule Class

The student will be scheduled in the class for the specified semester if there are seats available. If there are no seats available, the student will be put in a wait status for that Class. The waiting status must be maintained in the order the students tried to schedule the class. It will display whether the student gets scheduled for the class or is waitlisted.