CBSE Class 11 Informatics Practices Worksheet Set 04 Solved

1.
(a) An electronic shop has announced the following seasonal discounts on the purchase of certain items.

Develop the following GUI application based on the above criteria, to input name of a customer, amount of purchase and item of purchase (TV or Music System using Radio Button) by a customer. Compute and print the net amount to be paid by a customer in a text field (jTextField3) on clicking COMPUTE button. (Net amount = amount of purchase – discount)

(b) Distinguish between Radio Button and Check Box. 

(c) What will be the output after executing the following code segment if the inputs in jTextField1 are (i) 10 (ii) 40

String str=jTextField1.getText();
int Number=Integer.parseInt(str);
switch(Number) {
case 10 : System.out.println(“Ten Thousand”);break;
case 20 : System.out.println (“Twenty Thousand”);
case 30 : System.out.println (“Thirty Thousand”);break;
case 40 : System.out.println (“Forty Thousand”);
default : System.out.println (“Not enough!!!”); }

(d) Write Java code to display area of a square in jTextField2 on clicking CALCULATE button. The user enters side of the square in jTextField1. Also write code to terminate application when the user clicks EXIT button.

(e) Rewrite the following code in Java using if statement
int k;
char d;
switch (k) {
case 1: System.out.println(“ONE”);
case 2: System.out.println(“TWO”);
break;
case 3: System.out.println(“THREE”);
break;
default: System.out.println(“NONE”); }

(f) Develop the following GUI application to find day of the week.

Write Java code to accept an integer between 1 to 7 in jTextField1 and display day of the week (Monday for 1, Tuesday for 2 and so on..) in jTextField2 on clicking FIND DAY button using if statement. If the user enters any other number display ERROR. Also write code for RESET button to clear both the text fields.

2.
(a) Given the following table SHOP

Write SQL commands based on SHOP table for the following :

(i) Display names of items whose I_Code is in the range 600 to 680
(ii) Display details of the items in descending order of Price.
(iii) Display I_Code and name of items whose Qty is above 10 or Price is below 5.1
(iv) Display details of items whose name starts with „P‟
(v) Display names of items for which Qty is entered in the table

(b) Write output for the following SQL commands based on SHOP table
(i) SELECT Name FROM SHOP WHERE Price NOT IN (1.1,1.8);
(ii) SELECT „Price of‟, Name, „is‟,Price FROM SHOP WHERE Qty < 10;

Please click on below link to download CBSE Class 11 Informatics Practices Worksheet Set D Solved