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