CIS355A Week 6 Lab-Database Connectivity OBJECTIVES Programmatic access to a MySQL database to add and display records . PROBLEM: Student Management System A teacher needs the ability to store and retrieve student data. This includes . student name; three test scores; . average; and letter grade. FUNCTIONAL REQUIREMENTS You can code the GUI by hand or use NetBeans GUI builder interface. Create a GUI which allows for input and display of student data. It should include buttons to save a record, display all records. Create a database and table to store student name and three test scores. (Note that average and grade are calculated by app.) Student class Create a Student class to manage the student data. It should have private instance variables of student name; and three test scores. The class must have the following methods. . A default and parameterized constructor Sets/gets for all instance variables A get method to calculate and return the average A get method to calculate and return the letter grade toString to display the name of the student . . StudentDB. class Create a StudentDB class that is used to create a connection and interface with the database. This class should have two methods. getAll-reads data from database, returns data in an atraylist of student objects add-writes a record to the database