Develop a Client/Server (MySQL) student record application

Project Description:

I need a client/server application with a MySQL backend database. The prototype could interface with a database that holds student records. Each record may contain the student's first name, last name, student ID, GPA, mentor, and student status, along with other information particular to a student type. There are three types of students: full-time undergraduate, full-time graduate and part-time undergraduate.

This application must be developed using an object-oriented design and must give functionality to update, delete and add students from the database.

The application should also query the database to print out a selected student's information or all students' information. The design and functional 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 Sequence diagrams, UML Class diagrams, and a test plan with test cases.

Prepare a working Java application that meets all needs.

1) project_details.pdf that describes, in great detail, how this project should be built.

2) registrar_attachment.sql script to prepare the database and stable schema to be used.

3) Sample_Test_Case_Attachment.doc - to be filled out suitably

4) Software_Requirements_Specification_Diagram.doc - to be filled out suitably

The application will be verified to make sure all requirements were met. If you created this application using the NetBeans integrated development environment,

Submit all word-processing documents that has your use case diagrams, sequence diagram diagrams, class diagrams and Test Plan as *.rtf (Rich Text Format) files.

Skills required:

Java, Software Architecture, MySQL