Attached with the email you will find a pdf document contacting the structure of a
number of tables as a base for a web-based application to collect Medical
Insurance related data from our students through the office website.
1- The application will allow the students to enter their information which include
· Personal Details :
a. Name (first, middle and last),
b. Marital Status
d. Date of Birth
e. Preferred Medical Insurance Cover Plan (Single, Single Parent, Family)
f. Civil ID: it’s a unique 12 digits number issued to all Kuwaiti nationals.
g. Telephone, mobile, email and full address in the UK.
· Medical Details
a. GP Doctor Name.
b. GP Clinic Name
c. GP Clinic Address
· Sponsorship Details:
c. Course title.
d. Name of Sponsor in Kuwait
e. Start date, end date.
· Dependent Details, if any
a. Spouse Name, Civil ID, Date of Birth.
b. Children Name, Civil ID, Date of Birth
1- The tables to be created and run under MySQL.
2- The web application to run on a Tomcat server.
3- Write a program (in Java, we suggest using a web application) to submit and
retrieve students details.
We will be examining:
· Code structure
· Exception handling
· Don’t write code in a .jsp
· Document not what you do but rather why you do it