******SEE FILE ATTACHMENTS******
*****Note: If you choose to use a test plan and/or test case template found on the Internet, please ensure you identify the source using APA citation.******
You will need to develop a Java application to meet the requirements of this assignment. It is recommended that you use NetBeans as your integrated development environment. To download this program, follow the instructions found at the “Netbeans Download” web link below.
Use the following scenario to complete this task:
You are eager to demonstrate to management your ability to develop a client/server application with a MySQL backend database. Your prototype should interface with a database that holds student records. Each record will contain the student’s first name, last name, student ID, GPA, mentor, and student status, along with other information specific to a student type. There are three types of students: full-time undergraduate, part-time undergraduate, and full-time graduate.
If management pursues this idea, the application must be easy to maintain and easy to extend. For these reasons, your application must be developed using an object-oriented design.
Your application should provide functionality to update, add, and delete students from the database. The application should also query the database to print out a selected student’s information or all students’ information. The functional and design requirements of the system are outlined in part A of the task.
Task: Note: For this task, you will submit a working student record managing system application, UML Use Case diagrams with descriptions of the functional requirements, UML Class diagrams, UML Sequence diagrams, and a test plan with test cases.
Note: Before you begin, follow the steps in the “Installing MySQL and Using NetBeans” document. Use the attached “Registrar.sql” script to create your registrar database and create the student table schema.