Task $2.$ Client$-$Side Program

$(25$ marks$)$

Implement the client$-$side requirements $($non$-$graphical user interface$)$ and then provide code snippets for each function with clear explanations$/$comments of key statements used.

The client$-$side would accept the Student id$.$ The client will then forward the data to the server. $($Include input field validation wherever possible$).$

i$.$ Create a thread using extending thread class or implementing a runnable interface and implement a run method.

ii$.$ Request connection to the server.

ill. Accept and forward the necessary data to the server. iv$.$ Receive and display the results from the server.

v$.$ Close the connection after use.

Task $3.$ Server$-$side program

$(40$ marks$)$

Implement the server$-$side requirements and then provide code snippets for each function with clear explanations$/$comments of key statements used.

i$.$ Create a thread using extending thread class or implementing a runnable interface and implement a run method.

ii$.$ After receiving the data from the client side, the server should make a connection to the database.

Search the database using the data to retrieve the record. iv$.$ Calculate the total marks of the student.

v$.$ Calculate the CGPA of the student based on the criteria given below:

Avg$>=90$ : CGPA$=4$

Avg$>=80$ and Avg$<90$: CGPA $=3$

Avg$>=60$ and Avg$<80$: CGPA $=2$

MEC$\_$AMO$\_$TEM$\_035\_04$

Page $2$ of $16$

Advanced Programming $($COMP $20014\mathrm{.}1)-$ SPRING $24-$ CW$3($ASSMGT$)-$ All $-$ QP

Avg$>=50$ and Avg$<60$: CGPA $=1$

Avg$<50$: CGPA is not applicable

vi$.$ Calculate the fees to be paid after the discount based on the choice monthly$/$half$-$yearly$/$yearly$.$

Note that the fees has to be assumed by the student. Any value can be taken.

vii. viii.

Return to the client the student id$,$ student name, total marks, CGPA, fees after discount.

Close the connection with the database when done.