You are to implement a database based system that can be used to keep track of students seeking positions as tutors/markers for subjects offered.
The system will use three tables: • a table with fields for subject code and student identifier (Unix logins are used for the student identifiers); the data in this table identify those students who have volunteered to tutor various subjects; • a table with the student identifier as a key, and student name and initials as additional fields; • a table containing subject code, student identifier, and mark. This table contains entries for all candidate tutors and gives their marks for each of the subjects that they have completed and which they wish taken into consideration when evaluating their suitability for a tutoring role.
These data tables are to be accessed by a Java program, using JDBC for database access.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
The program should compile and run under Solaris.