XII HUMANITIES

English Holidays Homework.

Class XII Writing Questions

1.Write on following topics in your respective English Registers.

a) Value Based Education Remedy to Decrease Crime

b) Hazards of Environmental Pollution.

c) Circus- “A Menace to Animals”.

d) The Role of Youth in Combatting Corruption.

e) Minimizing of Human Rights is the way to cleanse society from corruption.

f) Teaching Profession is better Medical profession.

2. Prepare a power point presentation or write review of chapters : 1 to 13.

3. Learn the syllabus completed in class till 30May 2018 for Selection Test in June month.

raYT/Sai@t ivad\yaalaya hstsaala na[- idllaI

kxaa 12 vaIM ihMdI koind`k

AByaasa kaya- 1 kivata ‘ptMga’

dao AMk vaalao p`Sna

1 kiva nao Sard ko Aanao kI tulanaa iksasao kI hO AaOr @yaaoM

2 savaoro kI ]pmaa iksasao kI ga[- hO AaOr @yaaoM

3 ptMga kivata kI BaaYaa pr iTPpNaI kIijae.

4 baccaaoM d\vaara CtaMo kao maulaayama banaanao sao @yaa ta%pya- hO

tIna AMk vaalao p`Sna

XII HUMANITIES

1 ‘ptMga’ kivata ka p`itpad\ya ilaKoM.

2 kiva nao Sard?tu ka vaNa-na iksa p`kar ikyaa hO.

AByaasa kaya- 2 paz ‘baajaar dSa-na’

dao AMk vaalao p`Sna

5 pOsao kao @yaa batayaa gayaa hO AaOr @yaaoM ?

6 ‘manaIbaOga’ sao @yaa ta%pya- hO ?

7 baajaar ka AamaM~Na kOsaa haota hO ?

8 ‘s~I maayaa na jaaoD,o,,,,,,,,,,,’ sao @yaa AaSaya hO ?

9 Aqa-Saas~ ko ilae p`yau@t dao ivaSaoYaNaaoM ka AaOica%ya spYT kIijae.

tIna AMk vaalao p`Sna

1 baajaar kI jaadu[- takt hmaoM Apnaa gaulaama banaa laotI hO kOsao ?

2 BagatjaI baajaar kao saaqa-kta AaOr samaaja kao SaaMt kOsao kr rho hOM ?

AByaasa kaya- 3 ‘kalao maoGaa panaI do’

2 AMk vaalao p̀Sna

1 vaYaa- na haonao ko karNa gaa^Mva kI @yaa halat qaI

2 laoKk iksa AMQaivaSvaasa pr duKI haota hO

3 AMQaivaSvaasa ka natIjaa hmaoM iksa p̀kar Baugatnaa pDa,

4 jaIjaI kaOna qaI laoKk ko ]sako saaqa kOsao saMbaMQa qao

5 Aaja iksa Baavanaa ka naamaao inaSaana nahIM hO

6 Aaja doSa kI kOsaI halat hO

XII HUMANITIES

8 Aapko ivacaar sao yah isqait kba AaOr kOsao badlaogaI

3 AMk vaalao p`Snas

1 [Mdr saonaa ko baaro maoM laoKk AaOr ]sakI jaIjaI kI raya maoM @yaa AMtr qaa

2 idnaaoM idna panaI ko gahrato saMkT kao doKkr @yaa Aaja ka yauvaavaga- ‘[Mdrsaonaa’ kI trh kao[- saamaUihk

AaMdaolana p`arMBa kr sakta hO

AByaasa kaya 4‘Apizt va rcanaakaya-

1 pRYz saM#yaa 297 ko daonaaoM Apizt gad\yaaMSa kroM.

2 pRYz saM#yaa 300 maoM ide daonaaoM Apizt kavyaaMSa kroM.

3 mahaivad\yaalayaaoM maoM baZ,tI rOigaMga kI GaTnaa kI Aaor Qyaana AakiYa-t krto hue iSaxaa maM~I kao

ek p~ ilaKoM.

4 vaahnaaoM kI baZ,tI saM#yaa sao ]%pnna samasyaae^M pr ek fIcar laoKna kroM.

POLITICAL SCIENCE

1. Prepare PPT or project on India’s International Relations

2. Learn and revise all the chapters covered till 28th May-2018

History

1) Interview any one of your older relatives

(mother/father/grandparents/uncles/aunts)

Who has travelled outside your town or village. Find out

Where they went

How they travelled

How long did it take

XII HUMANITIES

Why did they travel

Did they face any difficulties

List as many similarities and differences that they may have noticed between

their place of residence and the place they visited, focusing on language, clothes,

food, customs, buildings, roads, the lives of men and women.

Write a report on your finding.

2) Revise all the work done in notebook. XII SCIENCE,COMMERCE,HUMANITIES

INFORMATICS PRACTICES (065) ASSIGNMENT

Note:-

i. Do the assignments in Assignment Note Book.

ii. GUI case studies and SQL Queries should be done in practicals too,

bring the soft copy of the same.

GUI Case Studies (6 marks Question)

1.

a. Ms. Jenny wants to create a form for Indian Railways Accomodation

Charges. She has created the following GUI using Netbeans, as shown

below:

There are three types of accommodation with charges as:

XII HUMANITIES

For AC Rs. 400 per day.

For Non-AC Rs.250 per day.

For Dormitory Rs. 100 per day.

Write the code to do the following :

i. ‘Calculate’ Balance Amount, on the basis of combo box optionis

selected using formula.

Balance=no_of_days*Selected_cat_charges-Advance

ii. Write the code required for ‘CLEAR ALL’ to clear all the textfields.

iii. Write the code to Exit the program.

2. M/s. R Ltd wants to calculate mean value for its business. They designed a GUI

in java using Netbeans as below:

Accept frequencies (f) in the first 4 text boxes.

Write the code to do the following :

i. ‘Calculate’ Mean value, on the basis of all the 4 frequencies using

formula.

Mean=(f1+f2+f3+f4)/4

ii. Write the code required for ‘CLEAR ALL’ to clear all the textfields.

iii. Write the code to Exit the program.

3. Ms. Rakhi works in an International Bank as an IT Head. She designs a simple

Interest

calculator

program

as shown

below:

XII HUMANITIES

The interest rate is given based on the account type as shown below:

Account Type Interest Rate

%

SAVING 4%

RECURRING DEPOSIT 6%

FIXED DEPOIST 8%

i. Write the code required for ‘INTEREST RATE ‘ button to display

interest rate as per the above given criteria.

ii. Write the code required for ‘SI’ button to calculate and display

‘SIMPLE INTEREST’ based on the given formulae:

SI=(amount*interest_rate*duration)/100

iii. Write the code required for ‘CLEAR ALL’ to clear all the textfields.

4. Mr.Kunalworksasaprogrammerin“DeliciousIceCream”parlourwherehe

hasdesignedasoftware tocomputechargestobepaidbythecustomer.A

screenshotofthesameis shownbelow:

Acustomercantakeanyice creamoutof1Scoop/2Scoops/IceCreamSundae.

Acustomercan alsooptforone,twoorall threetoppingsoverIceCream. Chargesoftoppingsareextra.Eachtoppingsisfor30.00.Forexampleiftwo toppings arechosen,60.00willbedisplayedas Toppings Charges. HelpMr.Kunalinwritingthecodetodothe following:

XII HUMANITIES

(i) AfterselectingappropriateRadioButtonandcheckbox(es),(ifrequired),when‘CalculateAmount’buttonisclicked,IceCreamcharges,ToppingsCharges and ‘TotalAmounttoPay’shouldbecalculatedanddisplayedtherespectivetext fields. ChargesforIceCreamsareasfollows :

Typeof IceCream

IceCream

1Scoop 60.00

2Scoops 80.00

IceCream Sundae

120.00

TotalAmounttoPay=IceCreamCharges +Toppings Charges. (ii) When‘CLEAR’buttonisclicked,allthetextfields,radio buttonsand checkboxes shouldbecleared. (iii) When‘Exit’buttonis clicked, theapplicationshouldclose.

5. Ms. Charma works as a programmer in “ABG Gar Rental Gompany”

where she has designed a software to compute charges to be paid bythe

client. A screenshot of the same is shown below:

A client can take any car out of Deluxe/CemiDeluxe/Ordinary for rent.

XII HUMANITIES

A client can also opt for services of a guide. Gharges vary depending

on the type of car opted.

Charges of services of Guide are extra.

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

a. AfterselectingappropriateRadioButtonandcheckbox(ifrequired),

b. when ‘CALCULATE’ button is clicked, Amount, Guide Charges and

Total Amount should be calculated and displayed in therespective text

fields.

Cat ego ry of Car Amo u nt (in

Rs) Deluxe Car 1000 per day

Semi Deluxe Car 800 per day

Ordinary Car 700 per day

AmountisobtainedbymultiplyingperdaychargesofCarwith

number of days for which the car is taken.

If ‘Guide Required’ checkbox is selected, Guide charges per day are

Rs 500.00.

Guide Gharges is calculated as : car required for No. of days * 500;

TotalAmount=Amount+Guidecharges

c. When ‘CLEAR’ button is clicked, all text fields andcheckboxshould

be cleared.

d. When ‘Close’ button is clicked,the applicationshouldclose. 6. Ms.Neelamworksasaprogrammerin“Kidz EntertainmentZone”.Shehas

designeda Registration Pagetocalculate thetotalfee of summercampdepending

uponthenumberofactivitiesselectedbytheuserconsideringageeligibility as well. A

screenshot of thesame is shown below:

XII HUMANITIES

Help herin writingthe codeto do the following: i. Afterenteringtheagein the specified text field,when „ChkEligibility‟button is clicked,adialogueboxshouldbedisplayedwithamessage“Welcome”ifageis inbetween3-13yearselsetheprogramshould beterminatedafterdisplaying the message “Sorry!You are either underageor overage!!”.

ii.Afterselecting the desirableactivities,totalfeeshouldbedisplayedinthe specifiedtextfieldontheclickof“Proceed”buttonattherateofRs.1000per activity.

iii.Adiscountof20%isapplicableifmorethanoneactivityischosenbythe user.

iv.Afterclickingonthe“NetFee”button,NetFeeshouldbecalculatedand displayed in therespectivetext field as perthegiven formula:

NetFee= Fee – Discount

XII HUMANITIES

7. Read the following case study carefully and answer the questions that

follows –

Read the following case study and answer the questions that follow : AVON Tools has

computerized its billing. The following is the data entry screen used by them :

Write code to implement the following :

(a) when user clicks Clear button , all the values stored in text fields and radio buttons

should be cleared.

(b) Ensure that value entered in quantity text field is positive only.

(c) Close the application when exit button is clicked.

(d) when calculate button is clicked , sub total , tax ( 6.50% of Sub Total), delivery and

handling charges and total amount

are computed and displayed in respective text fields.

The criterion of Delivery and Handling charges is as given below :

Category of City Charges

A Rs. 2000. B Rs. 3000

C Rs. 3500

(g) Read the following case study carefully and answer the questions that follows

–

Read the following case study and answer the questions that follow : AVON Tools has

computerized its billing. The following is the data entry screen used by them :

XII HUMANITIES

Write code to implement the following :

(a) when user clicks Clear button , all the values stored in text fields and radio buttons

should be cleared.

(b) Ensure that value entered in quantity text field is positive only.

(c) Close the application when exit button is clicked.

(d) when calculate button is clicked , sub total , tax ( 6.50% of Sub Total), delivery and

handling charges and total amount

are computed and displayed in respective text fields.

The criterion of Delivery and Handling charges is as given below :

Category of City Charges

A Rs. 2000. B Rs. 3000 C Rs. 3500

SQL ASSIGNMENT

1. Write SQL command to view the constraints to EMP table.

2. Mr. Naveen wants to remove the entire content of a table “RESULT” alongwith its

structure to release the storage space. What Mysql statement should be used?

3. Distinguish between Primary Key and Unique key.

4. Sheela created a table in Mysql later on she found that she did not need a

column “fee” . Which command should she use to delete the column from the

table.

5. Write a command to add a NOT NULL constraint on FEES column of a student

table.

6. In an item table columns include ItemCode, ItemName, Price and Qty. Which one

of these columns should be set as primary key and why?

XII HUMANITIES

7. Mr. Manjeet created two tables wit Department as Primary key in table 1 and

foreign key in Table2. While inserting a row in Table2. Mr. Manjeet is not able to

enter a value in the column Deptno. What could be the possible reason for it?

8. What is the purpose of GROUP BY clause in Mysql? How is it different from

ORDER BY clause?

9. There is a column SALARY in a table EMPLOYEE . The following two

statements are giving different outputs. What may be the possible reason?

SELECT COUNT(*) FROM EMPLOYEE;

SELECT COUNT(SALARY) FROM EMPLOYEE;

10. A table FLIGHT has 4 rows and 2 columns and another table AIRHOSTESS has

3 rows and 4 columns . How many rows and columns will be there, if we obtain

the Cartesian product of these two tables?

11. State two difference between date function NOW() and SYSDATE() of MySQL.

12. ShanyaKhanna is using a table EMPLOYEE . It has the following columns:

Admno, Name, Agg, Stream[Column Agg contains Aggregate Marks]

She wants to display highest Agg obtained in each stream.

She wrote the following statement:

SELECT Stream, Max(Agg) FROM EMPLOYEE;

But she did not get the desired result . Rewrite the above query with necessary

changes to help her get the desired output.

13. Write two eg. Of DML commands to SQL.

14. When using the LIKE clause, which wildcard symbol represents any sequence of

none, one or more characters?

15. Write the UPDATE statement in Mysql to increase the commission by 100.00 in

the “Commission” Column in the ‘EMP’ table.

16. Rewrite the following SQL statement after correcting error(s) .underline the

corrections made.

INSERT IN STUDENTS(RNO, MARKS) VALUE(5,78.5);

17. Distinguish between ALTER TABLE and UPDATE commands of mysql.

18. Mention any two categories in which Mysql Commands are broadly classified.

19. Give any two characteristics of Primary key.

20. Write two examples of DBMS software.

21. Define Foreign key with reference to DBMS.

22. Write the command to display the list of existing databases.

23. Mr. William wants to remove all the rows from the INVENTORY table to release

the storage space, but he does not want to remove the structure of the table.

What Mysql statement should be used.

24. Write Mysql command to open an existing database.

25. Write Mysqlcommand , which will be used to open an already existing database

“LIBRARY”.

XII HUMANITIES

26. Differentiate between alternate key and candidate key.

27. In mysqlReena andZebi are getting the following output of SELECT statement

on a table EMPLOYEE.

Which keyword has Zebi used with Select Statement to get the above output.

28. Write Mysql command, which will open an already existing database

“CONTACTS”.

29. Mr. James created a table CLIENT with 2 rows and 4 columns. He added 2 more

rows to it and deleted one column. What is the cardinality and degree of the

Table Client.

30. A table “Trains” has degree 3 and cardinality 8. What is the number of rows and

columns in it.

31. Sam , a student of class XI created a table “CLASS”. Grade is one of the column

of this table. To find the detail of students whose Grades have not been entered ,

he wrote the following Mysql query, which did not give the desired result.

SELECT * FROM CLASS WHERE GRADE=”NULL”;

Help Sam to run the query by removing the errors from the query and write the

correct query.

32. Amit, a salesman in an Outlet , create a table TRANSACTION on Amount is one

of the column of this table. To find the details of customer whose transaction is

more than 800, he wrote the following mysql query, which did not give the

desired result.

SELECT * FROM TRANSACTIONS

WHERE AMOUNT > “800”;

Help Amit to run the query by removing the errors from the query and write the

correct query.

33. Anushika , a salesman in an outlet, created a table Customers. Phoneno is one

of the column of the table , which is character type. To find the details of

customers whose Phoneno is 259624, she wrote the following Mysql query,

which did not give the desired result.

Reena

Lucknow

Delhi

Mumbai

Delhi

Kanpur

Delhi

Zebi

Lucknow

Delhi

Mumbai

Kanpur

XII HUMANITIES

SELECT * FROM CUSTOMERS WHERE PHONENO=259624;

Help Anushika to run the query by removing the errors from the query and write

the query.

34. The Fname column of table ‘Friends ‘ is given below:

FNAME

Aakash

Ashna

Ena

Gavi

Arjav

Based on the information , find the output of the following :-

i. SELECT FNAME FROM FRIENDS WHERE FNAME LIKE “%V”;

j. SELECT FNAME FROM FRIENDS WHERE

FNAME LIKE “%e%”;

35. Ms. Pushpa wishes to change the size of column ‘Publisher’ of author table from

15 characters to 25 characters.Write the statement for the same.

36. Write the correct code for the following statement:

UPDATE FROM STUDENT;

SETS MARKS=MARKS+10;

37. Roli wants to list the names of all the tables in her database named ‘Gadgets’

.Which command should she use to get the desired result?

38. Observe the given statements carefully:

i. SELECT * FROM CLUB WHERE SALARY BETWEEN 20000 AND

30000;

ii. SELECT * FROM CLUB WHERE SALARY IN(20000,30000);

iii. SELECT * FROM CLUB WHERE SALARY>=20000 OR

SALARY<=30000;

iv. SELECT * FROM CLUB WHERE SALARY=20000 OR

SALARY=30000;

Make pairs of the equivalent SQL statements given above (which

give the same output ) and place each pair in a group.

SQL 6 MARKS QUESTIONS

39. Consider the following table:

XII HUMANITIES

RxID Drug ID

DrugName Price Pharmacy Name

PharmacyLocation

R1000 5476 Amlodipine 100.00 Rx Pharmacy Pitampura, Delhi

R1001 2345 Paracetamol 15.00 Raj Medicos Bahadurgarh, Haryana

R1002 1236 Nebistar 60.00 MyChemist Rajouri Garden, Delhi

R1003 6512 VitaPlus 150.00 MyChemist Gurgaon,Haryana

R1004 5631 Levocitrezine 110.00 RxPharma cy South Extension,Delhi

Write commands in SQL for (i) to (iv):

i. To increase the price of “Amlodipine” by50. ii. To display all those medicines whose price is in the range 100 to150. iii. To display the Maximum price offered by pharmacy located in

“Gurgaon” iv. To display the Drug ID, DrugName and Pharmacy Name of all the

records in descending order of theirprice. On the basis of the Table Pharma ,write the output(s) produced by executing the following queries:

v. SELECT RxID, DrugName, Price from PharmaDB where PharmacyName IN (“Rx Parmacy”, “RajMedicos”);

vi. SELECT PharmacyName, COUNT(*) FROM PharmaDB GROUP BY PHARMACYNAME;

40. Srishti has created the following table with thename‘Veterinary’.

Col u mn Na me Co n straint

AnimalId Primary Key

VaccinationsDate

AnimalName Not Null

OwnerName

One of the rows inserted is as follows :

An imalId VaccinationDate An imalNa

me Ow n erNa me

A101 2015-02-12 Sheru Amit Sharma

a. What are the data type of columns AnimalId and

VaccinationDate in the table Veterinary?

b. Srishtiisnowtryingtoinsertthefollowingrow:

XII HUMANITIES

AnimalId Vaccination Date AnimalNa

me Ow n erNam e

A102 2015-08-09 NULL Abhimanyu Shah

41. Will she be able to successfully insert it ? Give reason. Table:TEACHER

No. Name Age Department Dateofadm Salary Sex

1 Jugal 34 Computer 10/01/97 12000 M

2 Sharmila 31 History 24/03/98 20000 F

3 Sandeep 32 Maths 12/12/96 30000 M

4 Sangeeta 35 History 01/07/99 40000 F

5 Rakesh 42 Maths 05/09/97 25000 M

6 Shyam 50 History 37/06/98 30000 M

7 Shivam 44 Computer 25/02/97 21000 M

8 Shalakha 33 Maths 31/07/97 20000 F

(i) To show all information about the teachers of Historydepartment.

(ii) To list the names of female teachers who are in Mathsdepartment.

(iii) To list names of all teachers with their date of admission in ascendingorder.

(iv) To insert a new row in the TEACHER table with the followingdata: 9,’Raja’, 26,’Computer’, ‘13/05/95’,23000,’M’

(v) Give the output of the following SQLstatements.

(a) Select COUNT(DISTINCT department) fromTEACHER;

(b) Select MAX(Age) from TEACHER where SEX=’F’; (c)Select AVG(Salary) from TEACHER whereSEX=’M’;

(d) Select SUM(Salary) from TEACHER where Date<{12/07/96};