You are to create an application that accesses a SqlIte 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. The project is a pilot for first year students.
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.
You will create a domain class, graphic 3 interface classes, a database class and a test class
In this phase you will set up the prototype. This will comprise of setting up the 3 domain classes specified above with their getters and setters. In this phase you will also set up junit tests to verify your code.
For the class subject there will be 3 arrays of strings
subjectCode = BIT100, BIT101, BIT108, BIT111, BIT112, BIT121,BIT230, BIT241
SubjectName = Effective Business Communication, Foundations of IT, Foundations of Business, Programming Concepts, Maths for IT, Network Communication Concepts, System Analysis and Design, Professional IT Practice and Ethics
Semester = 1,1,1,1,2,2 2,2
Junit
In the JUnit test, Test that
1.the fourth element in the subjectCode is BIT111, that the fourth element in the SubjectName is Programming Concepts, that the fourth element in the semester is 1.
2.the sixth element in the subjectCode is BIT121, that the sixth element in the SubjectName is Network Communication Concepts, that the sixth element in the semester is 2.
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 enrolment page, and a retrieve/update enrolment page
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.