Page 12 - IP

 Based on the course selected, Fee Per Quarter is displayed in
the appropriate textfield according to the following criterion :

Course Fee Per Quarter

Pharmacy 2000.00

Architecture 2500.00

Arts & Design 2300.00

 If the student is eligible for Concession, a concession of 7% of

Fee per quarter is calculated as the concession amount,
otherwise concession amount is 0.

 Fee to be paid is the Fee per quarter with the concession

amount (if any) deducted from it.

Help Ms. Priya in writing the code to do the following :

(i) When ‘Calculate Charges’ button is clicked, ‘Fee per quarter’,
‘Concession Amount’, ‘Fee to be Paid’ should be calculated and

displayed in the respective text fields. 4

(ii) When ‘CLEAR’ button is clicked, all the textfields,
radiobuttons and checkbox should be cleared. 1

(iii) When ‘Exit’ button is clicked, the application should close. 1

5. Consider the following table ‘Furniture’. Write SQL commands for the
statements (i) to (viii) and write output for SQL queries (ix) and (x).

Table : Furniture

FCODE NAME PRICE MANUFDATE WCODE

10023 Coffee table 4000 19-DEC-2016 W03

10001 Dining table 20500 12-JAN-2017 W01

10012 Sofa 35000 06-JUN-2016 W02

10024 Chair 2500 07-APR-2017 W03

10090 Cabinet 18000 31-MAR-2015 W02

90 8