Bit111: Software Application Java Assessment Answer

You are to create an application that accesses a Sql Ite 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.

This project can be completed in teams of two to three students.

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.

Phase 1 end of week 5  – 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 

In this phase you will add a user interface to your prototype. You will use WindowBuilder 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 

In this phase you will add connectivity to a Sqlite database. This will let you perform the actual functions of saving and retrieving from the database.