Task: You are to create an application that accesses a MySql database and allow you to insert new students, subjects and new enrolments. You are also required to be able to insert,retrieve and display...

Task:

You are to create an application that accesses a MySql database and allow you to insert new students, subjects and new enrolments. You are also required to be able to insert,retrieve and display information about students, subjects and enrolments.


A substantial proportion of this project will be undertaken in class during tutorial time with some guidance.  It is thus important that you attend all your classes.
The project will be delivered in 3 phases


Phase 1 end of week 5 (10 marks) – In this phase you will set up the prototype. This will comprise of setting up the 3 classes specified above with their getters and setters. In this phase you will also set up junit tests to verify your code.


Phase 2 end of week 7 – week 8 – adding a graphic user interface (10 marks).
In this phase you will add a user interface to your prototype. You will use Window Builder to do this though it will need to do a little coding to make it more efficient and useable. Your user interface will have a home page which can call up each of the required functions. That is the home page will be able to call up an insert student page, a retrieve student page, an insert subject page, a retrieve subject page, an insert enrolment page and a display enrolment page. From each of these pages, you should be able to navigate back to the home page


Phase 3 – porting to a database (20 marks)
In this phase you will add connectivity to a MySql database. This will let you perform the actual functions of saving and retrieving from the database.