CourseScheduler Final Project Part 1 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 Userwill 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 goodObject- OrientedDesign and Programming. The database must use good Object-Oriented Design and Programming. There is a very close correlation between Object-Oriented Design and DatabaseDesign. 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 followingAdminfunctions: AddSemester Asemesteris added to the database. Thesemesteris identified byonename. AddCourse A new courseis added to the database. Thecourseis identified by the code for the course,andthe description of the course. AddClass A new class is added to the database. The class is identified bythe semesterthe course is offered, the code for the course, andthe maximum number of students the course will contain that semester. AddStudent A studentis added to the database. Thestudentis identified by a studentID, the students first name, and the students last name. This phase of the project will implement the following Student functions:ScheduleClass Thestudentwill bescheduled in the class for the specifiedsemester ifthere 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. Display Schedule TheDisplay Schedule function will display the current scheduleof classesfor a specified student for the current semester.It will display the course code andthe status of the student in the class, whether scheduled or waitlisted. Display Classes The DisplayClasses function will display a complete list of classes for the current semester showing the course code, description, and number of seats. Testing scenario: A testing scenario will be provided to assist you in testing this application.It will be called Final Project Part 1 Test ScriptonCanvas. Database considerations: Your database will be created butallthe tables should be empty when your project is submitted. InitialNetBeansProject: An initial project is provided foryouto be used as the basis of your final project.It is provided as a .zip file in Week 11in Canvas under thename CourseSchedulerNameID.zip.It MUST be used for your Final Project.You will change the project name after you download it. There is a video in Week 11about how to do this. GUI Guidelines: The user should be required to enter only unknown data. Drop down lists of known data such as Student names, Course Codes, or Semesters should be displayed for the user to select. Combo Boxes should be used for the drop-down lists on the form. When information is requested to be displayed, e.g., for a Display command, all the requested information must be displayed. When a command is performed, the results of that command should be displayed to the user on the same display without the user needing to use a Display function to see what was done. Submission Guidelines: Don't forget to submit your zipped PROJECT folder and your zipped DATABASE folder. Zip the ENTIRE database folder and the ENTIRE project folder and submit the two zipped files in the assignment under one submission. *Template ZIP file attached *Program Layout pdf file attached

Attachments:

CourseSchedul....zip

Course-Schedu....pdf