Holidays
Homework
Class
XII
Sub:
Informatics Practices
Note: The questions to be done in class notebook .
2.
WRITE A JAVA PROGRAM TO MAKE A CALCULATOR HAVING
CONTROLS ADD , SUBTRACT , MULTIPLY , DIVIDE AND REMAINDER
3.
WRITE A JAVA PROGRAM TO ONPUT PRINCIPAL AND
TIME AND CALCULATE THE INTEREST . IF PRINCIPAL IS MORE THAN 10000 THEN
RATE OF INTEREST WILL BE 6% OTHERWISE 5%.
4.
WRITE A PROGRAM TO INPUT THE MARKS IN 5 SUBJECTS AND
CALCULATE AND DISPLAY TOTAL MARKS , PERCENTAGE AND GRADE. THE GRADE WILL
BE A IF MARKS ARE > =80 , B IF MARKS >=60 OTHERWISE C.
5.
WRITE A PROGRAM TO INPUT A NUMBER AND FIND IT TO BE POSITIVE , NEGATIVE OR ZERO. ALSO FIND
IT IS EVEN OR ODD.
6.
WRITE A PROGRAM TO FIND THE LARGEST AS WELL SMALLEST OF
THREE NUMBERS. TAKE TWO BUTTONS AS LARGEST AND SMALLEST IN THE FORM.
7.
Employees
|
Empid
|
Firstname
|
Lastname
|
Address
|
City
|
|
010
|
|
Kumar
|
Raj nagar
|
GZB
|
|
105
|
Harry
|
Waltor
|
Gandhi nagar
|
GZB
|
|
152
|
Sam
|
Tones
|
|
|
|
215
|
Sarah
|
Ackerman
|
440
|
|
|
244
|
|
Sengupta
|
|
|
|
300
|
Robert
|
Samuel
|
9 Fifth Cross
|
|
|
335
|
Ritu
|
Tondon
|
Shastri Nagar
|
GZB
|
|
400
|
Rachel
|
Lee
|
121 Harrison St.
|
|
|
441
|
Peter
|
Thompson
|
|
|
Write the SQL commands for the following :
(i)
Create table Employees and insert values in the table
as shown.
(ii)
To show firstname,lastname,address and city of all
employees living in paris
(iii)
To display the content of Employees table in descending
order of Firstname.
(iv)
List the name of employees whose first name starts with
‘R’ and last name with ‘L’.
(v)
Count the no of employees of each city.
Give the Output of following SQL
commands:
(i)
Select count(distinct designation) from empsalary;
(ii)
Select designation, sum(salary) from empsalary group by
designation having count(*) >2;
(iii)
Select sum(benefits) from empsalary where designation
=’Clerk’;
8.
DESIG
|
W_ID
|
SALARY
|
BENEFITS
|
DESIGNATION
|
|
102
|
75000
|
15000
|
MANAGER
|
|
105
|
85000
|
25000
|
DIRECTOR
|
|
144
|
70000
|
15000
|
MANAGER
|
|
210
|
75000
|
12500
|
MANAGER
|
|
255
|
50000
|
12000
|
CLERK
|
|
300
|
45000
|
10000
|
CLERK
|
|
335
|
40000
|
10000
|
CLERK
|
|
400
|
32000
|
7500
|
SALESMAN
|
|
451
|
28000
|
7500
|
SALESMAN
|
·
Create table Desig and insert values in the
table as shown
·
Display W_id
and benefits of Employee having salary
between 15000 and 9000
·
Display details of Employees who are “CLERK” .
·
Arrange the data in the ascending order of
benefits.
·
Display the sum of salary designation wise.
Find the output -
1.
Select MAX(salary) from desig;
2. Select COUNT (DISTINCT designation) from
desig;
3 Select designation, SUM(salary) from desig
Group by designation Having count (*) > 2;
9. Q On an A4 Sheet explain any 15 HTML Tags with example.
|
A B
C D |
10 . Knowledge supplement Organization has set up
its new center at Mangalore for its office and web based activities. It has 4
Blocks of buildings as shown in the diagram -
Center
to center distance between various blocks Number of Computers
|
Block A to Block B
|
50 m
|
|
Block B to Block C
|
150 m
|
|
Block C to Block D
|
25 m
|
|
Block A to Block D
|
170 m
|
|
Block B to Block D
|
125 m
|
|
Block A to Block C
|
90 m
|
|
Block A
|
25
|
|
Block B
|
50
|
|
Block C
|
125
|
|
Block D
|
10
|
i.
ii.
iii.
iv.
v.
vi.
a. Suggest a most suitable cable layout of connections
between the Blocks.
b. Suggest the most suitable places (i.e. Block) to house
the server of this organization with a suitable reason.
c. Suggest the placement of the following devices with
justification:
a) Repeater b)
Hub/Switch
d. The organization is planning to link its head office
situated in City in a hilly region where cable connection is not feasible,
suggest an economic way to connect it with reasonably high speed?
