HOLIDAYS HOMEWORK (2018-19)

CLASS – XII SUBJECT – ENGLISH 1. Make 2 Invitation Cards

a. Annual day b. Marriage

2. On half cartridge sheet make two posters on the following topics given below: a. Environment(Go green) b. Conservation of Resources c. Keeping your school clean

SUBJECT – PHYSICS 1. Solve the assignment of optics.

2. Prepare NCERT questions of Ch-9 and 10.

3. Prepare for the test from same chapters. 4. Submit a project report on topic allotted to you.

5. Read the chapters 12(Atoms) and Ch-13(nuclei) for the class test.

Note: the work is to be submitted on first week of July.

SUBJECT – CHEMISTRY

1. NCERT question of Lesson – Haloalkanes and Haloarenes.

2. NCERT question of lesson – Alcohols, Phenols & Ethers

3. NCERT question of lesson – Aldehydes, Ketones & Carboxylic Acids

SUBJECT – BIOLOGY

1. Revision of the syllabus covered.

2. Power point presentation (on the allotted topics)

3. Project report (for submission at the time of CBSE examination.

SUBJECT – MATHEMATICS Solve the assignments given in the class.

SUBJECT – PSYCHOLOGY

1. Complete Practical work in Practical File.

2. Prepare a detailed case study of one individual.

a. Make use of different methods of data collection –

b. Observation

c. Interview

d. Questionnaire

e. Rating scale

f. Case study

3. Revise the chapters 1, 3 and 4.

4. Read Ch – 8, Psychology and Life and do assignment in register.

5. Write Ques. /Ans. Of Chapter – 4 in assignment register.

SUBJECT – BUSINESS STUDIES

Project (Any one)

1. Make a project on Fayol’s Principles of Management or Taylor’s Principle of Management.

The students are required to visit any one of the following:

i) A departmental store

ii) An industrial unit

iii) A fast food outlet They are required to observe the application of the general principles of Management

advocated by Fayol.

i) Division of Work

ii) Unity of Command

iii) Unity of Direction

iv) Scalar chain

v) Espirit de Corps

vi) Fair remuneration to all

vii) Order

viii) Equity

ix) Discipline

x) Subordination of Individual Interest to General Interest

xi) Initiative

xii) Centralization and decentralization

xiii) Stability of tenure

xiv) Authority and responsibility Application of Scientific Management techniques by F.W.Taylor

i) Functional Foremanship ii) Standardization and simplification of work

iii) Method study

iv) Motion study

v) Time Study

vi) Fatigue Study

vii) Differential piece rate system

OR

Make a project on Elements of Business Environment from the following topics

a) Changing role of women in the past 25 years relating to joint families, nuclear families, women as bread earners of the family.

b) A study on child labor laws, their implementation and consequences.

OR c) Make a project on manufacturing and marketing of following products

1. Tooth paste 2.Noodles 3.Jams and pickles

4. Toothbrush 5.Jeans 6.Jewellery

7. Fairness Cream 8.Ladies Bag 9. Any other product of your choice

OR d) Make a project on Stock exchange

1. History of Stock exchange

2. Companies listed in NSE

3. Pick any 5 portfolios

4. Holidays in NSE/BSE

5. Share price quotation in opening price, high price, low price, slogging price

6. Graphical representation of share prices of 5 companies.

7. Causes of share price fluctuations

8. Conclusion

Q2) Thoroughly revise chapters-1, 2, 3 and do the case studies related to above mentioned chapters.

SUBJECT – HOME SC. 1. Complete the Ques. /Ans. of Chapters covered in your class register. 2. Complete the assignment given (board questions of past 10 years) in your assignment

register. 3. Collect at least 20 recipes of healthy dishes. 4. Visit a bank/post office and collect the following forms: withdrawal slip, cheque, pay in slip. 5. Complete the project report and survey report from unit 1 and unit 5. 6. Complete your file(Unit-1 and Unit-2)

SUBJECT – POLITICAL SC. 1. Revise Ch-1 to 5 of Contemporary world.

2. Complete the Ques. /Ans. of Chapters 1 to 4 of Politics of India since Independence.

3. Frame short question answers of Ch-5 of CWP in Pol. Sc. Register.

SUBJECT – HISTORY

1. Complete the notes copies with exercise question answers from Theme: 5, 6, 7, 8, 9,

10, 11 and 15 (Theme 15 is for self study)

2. Complete the Part – 1 project according to the themes selected and signed by the

student (it carries 20 marks for Term 1 exams)

3. Prepare Power Point Presentation for the assigned project ( 12 slides with sound

effect)

4. Map work-On the outline map of India show the extent of Vijaynagar empire (Theme 7) and extent of Mughal empire (Theme 8/9)

Topics for Power Point Presentation –

a) Major centres of Heritage declared under UNESCO (at International level)

b) Major religious centres declared under UNESCO (at World Level)

SUBJECT – INFORMATION TECHNOLOGY

Paper-Data Management Applications Code: 795 Perform the following questions in MYSQL and get the printouts Create the following tables and perform the queries. TABLE 1 : GRADUATE S.NO NAME STIPEND SUBJECT AVERAGE DIVISION

1 KARAN 400 PHYSICS 68 1 2 DIWAKAR 450 COMP. Sc. 68 2

3 DIVYA 300 CHEMISTRY 62 1

4 REKHA 350 PHYSICS 63 1

5 ARJUN 500 MATHS 70 3

6 SABINA 400 CHEMISTRY 55 1

7 JOHN 250 PHYSICS 64 2

8 ROBERT 450 MATHS 68 3

9 RUBINA 500 COMP. Sc. 62 1

10 VIKAS 400 MATHS 57 2

(a) List the names of those students who have obtained DIV I sorted by NAME. (b) Display NAME, STIPEND of the teachers teaching MATHS.

(c) To display the number of students who are either PHYSICS or COMPUTER SC graduates.

(d) To insert a new row in the GRADUATE table: 11,”KAJOL”, 300, “COMP. SC.”, 75, 1

(e) Display the list of unique subjects present in the table. (f) To display the names having ‘a’ in it. (g) To enlist students having either 1 or 3 division (h) List the records where average falls in range 50-75

Table2: BOOKS

Book_Id Book_Name Author_Name Publishers Price Type Quantity

C01 Fast Cook Lata Kapoor EPB 355 Cookery 5

F01 The Tears William Hopkins First 650 Fiction 20

T01 My C++ Brain & Brooke FPB 350 Text 10

T02 C++ Brain A.W.Rossaine TDH 350 Text 15

F02 Thunderbolts Anna Roberts First 750 Fiction 50

a) To display the list of all cookery books.

b) To display the names and price from books in ascending order of their price.

c) To display books whose price is either 5, 10, 15.

d) To display the Book Name, Quantity_Issued and Price for all books of EPB publishers

e) To display the list of all books whose author name begins from ‘a’.

Table 3: Supplier

a) Display all records where quantity supplied is within the range 10-15 b) Display the records of Item 12, 13. c) Display the items where qty_supp is not within the range 20-40. d) Display the list of all the suppliers from Delhi whose status is ‘L’. e) Remove the column status from the table.

Table 4: School Bus

Rtno Area_overed Capacity Noofstudents Distance Transporter Charges

1 Vasantkunj 100 120 10 Shivamtravels 100000

2 HauzKhas 80 80 10 Anandtravels 85000

3 Pitampura 60 55 30 Anandtravels 60000

4 Rohini 100 90 35 Anandtravels 100000

5 YamunaVihar 50 60 20 BhallaCo. 55000

6 KrishnaNagar 70 80 30 YadavCo. 80000

7 Vasundhara 100 110 20 YadavCo. 100000

8 PaschimVihar 40 40 20 Speedtravels 55000

9 Saket 120 120 10 Speedtravels 100000

10 JanakPuri 100 100 20 KisanTours 95000

a) To show all information of students where capacity is more than the no of student in sorted order of rtno.

b) To show area_covered for buses covering more than 20 km., but charges less than 80000. c) Add a new record with following data:

(11, “Motibagh”,35, 32,10,”kisantours“, 35000)

d) To show the list of unique transporters.

Table 6 : Emp

Write a SQL command to create the following emp table.

EMPNO INTEGER

ENAME VARCHAR(10)

JOB VARCHAR(9)

MGR INTEGER

HIREDATE DATE

SAL DECIMAL(7,2)

COMM DECIMAL(7,2)

DEPTNO INTEGER

Insert the following data into the table.

Table EMP

EMPNO ENAME JOB MGR HIREDATE SAL COMM

7876 SMITH ANALYST 7782 12-Aug- 2010

9600 20

7499 ALLEN CLERK 7876 1-Apr- 2005

19200 30

7698 WARD MANAGER 7900 2-Jul-2001 15000 30

7782 JONES PRESIDENT 5670 4-Jun- 2009

95700 10

7902 MARTIN SALESMAN 7900 5-Jun- 2009

15000 20

7900 BLAKE ANALYST 7782 18-Jul- 2009

34200 30

7566 CLARK ANALYST 7782 22-May- 2007

29400 20

7839 SCOTT CLERK 7876 6-Mar- 2005

36000 10

7654 KING MANAGER 7900 19-Apr- 2003

60000 30

7934 TURNER CLERK 7876 30-Nov- 2004

18000 10

7788 ADAMS ANALYST 7782 13-Mar- 2007

13200 20

7369 JAMES CLERK 7876 18-Feb- 2005

11400 20

7844 FORD MANAGER 7900 12-Jan- 2007

36000 30

7521 MILLER CLERK 7876 22-Sep- 2008

15600 30

Write a statement to show the structure of the table emp.

1. Display names of all employee whose name include either of the substring ‘TH’ or ‘LL’ 2. Display data for all CLERKS who earn between 1000 and 2000; 3. Find the employees who are manager. 4. To display deptno, job, empname in reverse order of salary from emp. 5. Write a suitable sql statement to display employees name, salary and location of all the

employees working in new York. 6. Display name and annual salary for all employee. 7. Display names of all employee whose name is at least 4 characters long; 8. Write a SQL query to increase the salary of each employee by 200. 9. Display the different job from emp table.

Ques. 2) Solve the back exercise questions of unit 1 and unit 2 (shared on google classroom) in your class register Ques. 3) Paste and Solve the question paper of First unit in your register

Solve the Assignment in your class register

Multiple Choice questions

1. Which statement is used to extract data from a table?

A. SELECT

B. DISPLAY

C. READ

D. EXTRACT

2. How do you select all the columns from a table named "Employee"?

A. SELECT [all] FROM Employee;

B. SELECT Employee;

C. SELECT * BY Employee;

D. SELECT * FROM Employee ;

3. How do you select a column named "IName" from a table named "Inventory"?

A. SELECT Inventory FROM Iname;

B. DISPLAY Iname FROM Inventory;

C. SELECT Iname FROM Inventory;

D. SELECT Iname, Inventory FROM Iname;

4. Which of the following are valid column names?

A. Marks Eng

B. 66_Marks

C. Marks_Eng

D. #Eng_Marks

5. SELECT statement can be used to perform these functions.

A. Insert rows into a table.

B. Choose and display columns from a table.

C. Modify data in a table.

D. Select and display structure of a table

6. Which statement is used to insert new data in a table?

A. ADD RECORD

B. INSERT RECORD

C. INSERT INTO

D. INSERT ROW

7. How would you display all those rows from a table named "Friends" where the

value of the column "Hobbies" is "SWIMMING"

A. SELECT ALL FROM Friends WHERE Hobbies IS 'SWIMMING';

B. SELECT * FROM Friends WHERE Hobbies='SWIMMING';

C. SELECT * FROM Friends WHERE Hobbies = 'Swimming" ;

D. SELECT ALL FROM Friends WHERE Hobbies 'SWIMMING' ;

8. Which statement is used to modify data in a table?

A. CHANGE

B. MODIFY

C. UPDATE

D. SAVE AS

9. Which SQL statement is used to delete data from a table?

A. DELETE

B. DROP

C. TRUNCATE

D. REMOVE

10. How do you select all the rows from a table named "Student" where the value of

the column "FName" starts with "G"?

A. SELECT * FROM Student WHERE FName LIKE 'G_' ;

B. SELECT * FROM Student WHERE FName='G';

C. SELECT * FROM Student WHERE FName LIKE 'G%' ;

D. SELECT * WHERE Student WHERE FName='%G%' ;

11. The OR operator displays a record if ANY of the conditions listed are true. The

AND operator displays a record if ALL of the conditions listed are true

A. False

B. True

12. Which keyword is used to return only different values in a column?

A. DIFFERENT

B. EXCLUSIVE

C. DISTINCT

D. UNIQUE

13. Which SQL keyword(s) is/are used to sort the rows in the output:

A. SORTED ORDER

B. SORT

C. SORT BY

D. ORDER BY

14. How would you return all the rows from a table named "Item" sorted in

descending order on the column "IName"?

A. SELECT * FROM Item SORT 'IName' DESC;

B. SELECT * FROM Item ORDER BY IName DESC ;

C. SELECT * FROM Item ORDER IName DESC ;

D. SELECT * FROM Item SORT BY 'IName' DESC ;

15. How can you insert a new row into the "Store" table?

A. INSERT (1,'Abc Rice') INTO Store;

B. INSERT VALUES (1,'Abc Rice') INTO Store ;

C. INSERT INTO Store VALUES (1,'Abc Rice');

D. ADD ROW Store values(1,'Abc Rice');

E. Answer the following questions.

a) Define the following terms: i) Keyword ii) Clause iii) Statement

b) Which statement is used to select a database and make it current?

c) How is a database related to table(s)?

d) Write SQL statement to view names of all the tables contained in the current

database.

e) Which keyword is used to eliminate redundant data?

f) In INSERT INTO statement, while giving data values, how should text values be

supplied?

g) What is NULL? What happens when you perform arithmetic calculations on NULL

values?

h) Write SQL statement to display the result of arithmetic expression 78*2 on screen?

i) Is there any difference in the output of the following statements :

Select * from Emp;

SELECT * FROM EMP;

j) List two categories into which MySQL statements can be categorized. Give

examples of 2 statements in each category.

k) Write the minimum number of column(s) that must be specified while creating a

table using CREATE TABLE statement.

l) What happens if you give a CREATE TABLE statement to create a table named

'Item' and a table named 'Item' already exists?

m) Write any 4 things that are displayed when you display the structure of a table

using DESCRIBE statement.

n) Consider the following INSERT INTO statement:

INSERT INTO Emp(Empid,Salary) VALUES ('I201',25000);

What values are assigned to the columns Empid and Salary respectively?

o) In which order are the columns displayed when we give a SELECT

statement?

p) What is the difference in the output of SELECT statement if we write the keyword

ALL in place of DISTINCT?

q) What is the purpose of a Column Alias?

r) Write the purpose of the following SELECT statement?

SELECT Itemcode,IName AS "Item Title" FROM Item;

s) What does the Modulus arithmetic operator do?

t) List six relational operators used in SQL.

u) How are operators with equal priority evaluated in an expression?

v) Which statement is used to modify data in a table?

w) Which statement is used to remove a column from a table?

x) What is the purpose of "ORDER BY" clause?

y) What value is assigned to a Nullable field if its value is not assigned in the INSERT

INTO statement?

Assignment2

1. What is redundancy? What are the problems associated with redundancy. 2. What is a foreign key? What is its importance? 3. What are constraints? Are constraints useful or are they hindrances to effective management of

databases? 4. In a database there is a table Cabinet. The data entry operator is not able to put NULL in a

column of Cabinet? What may be the possible reason(s)? 5. In a database there is a table Cabinet. The data entry operator is not able to put duplicate values

in a column of Cabinet? What may be the possible reason(s)? 6. Do Primary Key column(s) of a table accept NULL values? 7. There is a table T1 with combination of columns C1, C2, and C3 as its primary key? Is it possible

to enter? a. NULL values in any of these columns? b. Duplicate values in any of these columns?

8. What are the differences between DELETE and DROP commands of SQL? 9. What is Referential Integrity? 10. What is Normalization? Why is there a need to normalize data? 11. What is ALTER TABLE ? 12. What is DROP TABLE? 13. What is Data Independence? Explain different types of data independence.

Paper-Web Applications Code: 796 Q1. Make a movie on the topic assigned to you:

1. Safe Internet Practices.(some DO’s and Dont’s) [Aakash, Abhishek, Lakshay]

2. Cyber Bullying [Astha, Avitosh, Nitish, Pratham]

3. Tips to Be cyber smart citizen [Aryan, Sakshi, Rohit]

4. Top 10 Apps used for Education [Bobby, Deepak Singhal, Sheetal]

5. Be Cyber Safe [Eshika, Kashish,Sonika Bhatt]

6. Common Internet Frauds [shivam, Shivani]

7. Net Etiquettes [Vaishnavi, Ashish]

8. Real world vs Virtual World- (a world of twitter, youtube, facebook)- Which is better??

[Vaibhav, Simran, Shubhi]

Note: Get at least 5 Colored printout of any poster/slogans related to above topics on light color A4 sheet.

Q2. Solve the assignment related to movie maker given in the class (shared on Google

classroom) in your register. Q3. Solve the MCQ’s related to multimedia quiz as shared

with you through drive link.

Q4. Paste and Solve the Question paper of First unit exam in your register.

SUBJECT – ECO