Page 74 - IP

(c) Consider the tables product and client give
below – Product

PID ProdName Manufactures Price
T P01 Pen Cello 5
T P02 Gel pen Luxar 10
T P03 Ink pen Luxar 10
T P04 Pencil Natraj 2
T P05 Sketch Camel 2

Client
CID CliName City PID
01 Rakesh Delhi TP01

02 Prakash Mumbai TP05
03 Suresh Delhi TP03
04 Dinesh Delhi TP02
05 Pravesh Banglore TP04

i. To Display the details of products whose Price is in the range of 6 to 10 [2]
ii. To display client name, city from table chart and ProdName and price from table
product [2].
iii. To increase the price of all products by 10. ( Product the output only) [2]

7 (a) Write two major Projects of E-Governance in India? [1]
(b) How is e-learning beneficial to students? [2]
(c) Ashok works for a Hotel. He warts to create controls on a form in NetBeans for the following
function. Choose appropriate controls from TextField, Label , RadioButton , CheckBox , List ,
ComboBox , Button and write in the third column. [2]

S.No. Controls use to Control
1 Select room type
2 Enter customers name
3 Enter arrival date
4 To book rook