CBSE Class 11 Informatics Practices Worksheet Set 03 Solved

1.
(a) What will be the text in jLabel1 after executing the following code ?
int First=7;
int Second=83;
First++;
if (First + Second >90)
jLabel1.setText(“Value is 90”);
else
jLabel1.setText(“Value is not 90”);

(b) Write Java code to display area of a rectangle in jTextField3 on clicking AREA button. The user enters length and breadth of the rectangle in jTextField1 and jTextField2 respectively. Also write code to terminate application when the user clicks EXIT button.

€ 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.

(d) Rewrite the following code in Java using switch statement

int k;
char d;
if (d==‟N‟)
k=1;
else if (d==‟S‟)
k=2;
else if (d==‟E‟)
k=3;
else if (d==‟W‟)
k=4;
else k=0;
€ Give any one difference between Text Field and Text Area. 

(f) Create a GUI application to compute Total Amount.

Write Java code to find Total Amount to be paid by a customer on clicking Compute button, according to the checkbox selected. The user enters name of the customer and selects one or more items. If TV is selected, display Bill Amount 35000. If Music System is selected, display Bill Amount 28500. Find the total amount. If Elite Customer Check Box is selected,
give a discount of 10% in the total amount. Display the Final Amount in Total Amount Text Field (jTextField4)

2.
(a) Given the following table EMPLOYEE

Write SQL commands based on EMPLOYEE table for the following :

(i) Display names of the employees whose salary is in the range 50000 to 70000.
(ii) Display details of the employees in descending order of Empno.
(iii) Display Empno and Name of employees from Sales department whose salary is below 80000.
(iv) Display details of the employees whose name has the letter „a‟
(v) Display Name and department of employee whose salary is not entered in the table

(b) Write output for the following SQL commands based on EMPLOYEE table

(i) SELECT Name FROM EMPLOYEE WHERE Dept IN („HR‟,‟Marketing‟);
(ii) SELECT Name, Salary*0.1 “Bonus” FROM EMPLOYEE WHERE Dept=‟Marketing‟;

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