You have chosen to sponsor your bid up to a maximum amount of .
I need a client/server application with a MySQL backend database. The 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.
This application must be developed using an object-oriented design and must 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 project.
Note: This project is 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.
Use the attached “Registrar.sql” script to create your registrar database and create the student table schema.
Create a working Java application that meets all requirements.
I am attaching the following supplements for further details
1) project_details.pdf that explains, in great detail, how this project should be built. (to verbose to post here)
2) registrar_attachment.sql script to create the database and stable schema to be used.
3) Sample_Test_Case_Attachment.doc - to be filled out appropriately
4) Software_Requirements_Specification_Diagram.doc - to be filled out appropriately
Note: Include all .java and .class files along with any test data used.
The application will be verified to ensure all requirements were met. If you created this application using the NetBeans integrated development environment, please zip the entire NetBeans project folder. This will include all .java and .class files.
Submit all word-processing documents that contain your use case diagrams, class diagrams, sequence diagram diagrams and Test Plan as *.rtf (Rich Text Format) files.