SUMMER HOLIDAY WORK ON 29-5-24 CLASS 12th Commerce
SUMMER HOLIDAY WORK ON 29-5-24 CLASS 12th Commerce
SUMMER HOLIDAY WORK ON 29-5-24 CLASS 12th Commerce
Vacations are the most attractive and desirable part of school life! It’s time again for a
fun filled and relaxing summer break. However, during the scorching summer month,
when you are locked up inside your homes, time must be spent meaningfully and
interestingly. Keeping this in view, we have assigned Holiday Homework for you so
that you remain connected with your studies.
Summer Holiday Homework helps students to work on their own terms and pushes
them to get things done with an approaching deadline, and helps them retain the
important information they may otherwise forget a few short weeks after they have
been released from the school. It provides the students a way to be connected to
studies during the long-time break. Parents ensure that your ward completes his/her
Homework, assignments neatly.
Read any English newspaper daily. Cut and paste News Report on different issues in a separate
file. Highlight the difficult words and write their meaning.
Note: REMEMBER THIS PROJECT FILE IS A PART OF INTERNAL ASSESSMENT AND MARKS WILL
BE ADDED IN FINAL BOARD EXAMS.
i. Harmony not discord ii. Science not rule of thumb iii. Standardization and simplification
Social
Economic
Lgal
Chapter-1
Question Nos.:-4, 18, 25, 44, 53, 54, 56, 68, 70, 72
Chapter 2
ACTIVITY 11:- To interpret geo metrically the manning of √ and its integral powers.
To prepare activity on chapter – 15 Linear Programming from Exercise 15.2 and 15.3 use paper
cutting/colors to show the feasible region | Lines etc.
1) PA-1
1) - (self-Introduction)
2) - (Index)
3) - (Acknowledgement letter)
4) - (Certificate)
5)
6)
7) - : , , इ औ
, ,
8) - : , औ
, ,
9) इ
10) / /
11)
Completed Painting Folder ( 10 sheets)
INSTRUCTIONS: Do the following queries in project file neatly and with tables.
Question 1:
Write queries for (i) to (iv) and find ouputs for SQL queries (v) to (viii), which are based on
the tables.
Table :
VEHICLE
Note:
PERKS is Freight Charges per kilometer.
Km is kilometers Travelled
NOP is number of passangers travelled in vechicle.
1. To display CNO, CNAME, TRAVELDATE from the table TRAVEL in
descending order of CNO.
2. To display the CNAME of all customers from the table TRAVEL who are
travelling by vechicle with code Vo1 or Vo2
3. To display the CNO and CNAME of those customers from the table TRAVEL who
travelled between ‘2015-1231’ and ‘2015-05-01’.
4. To display all the details from table TRAVEL for the customers, who have travel
distacne more than 120 KM in ascending order of NOE
5. SELECT COUNT (*), VCODE FROM TRAVEL GROUP BY VCODE HAVING
COUNT (*) > 1;
6. SELECT DISTINCT VCODE FROM TRAVEL :
7. SELECT A.VCODE, CNAME, VEHICLETYPE FROM TRAVEL A, VEHICLE
B WHERE A. VCODE = B. VCODE and KM < 90;
8. SELECT CNAME, KM*PERKM FROM TRAVEL A, VEHICLE B WHERE
A.VCODE = B.VCODE AND A. VCODE ‘V05’;
Question 2:
Consider the following tables SCHOOL and ADMIN and answer this question :
Give the output the following SQL queries :
1. Select Designation Count (*) From Admin Group By Designation Having Count
(*) <2;
2. SELECT max (EXPERIENCE) FROM SCHOOL;
3. SELECT TEACHER FROM SCHOOL WHERE EXPERIENCE >12 ORDER BY
TEACHER;
4. SELECT COUNT (*), GENDER FROM ADMIN GROUP BY GENDER;
Write queries for (i) to (iv) and find ouputs for SQL queries (v) to (viii), which are based on
the table TRIP.
Note:
NO is Driver Number
KM is Kilometer travelled
NOP is number of travellers travelled in vehicle
TDATE is Trip Date
1. To display NO, NAME, TDATE from the table TRIP in descending order of NO.
2. To display the NAME of the drivers from the table TRIP who are traveling by
transport vehicle with code 101 or 103.
3. To display the NO and NAME of those drivers from the table TRIP who travelled
between ‘2015-02-10’ and ‘2015-04-01’.
4. To display all the details from table TRIP in which the distance travelled is more
than 100 KM in ascending order of NOP
5. SELECT COUNT (*), TCODE From TRIP
GROUP BY TCODE HAVNING COUnT (*) > 1;
6. SELECT DISTINCT TCODE from TRIP;
7. SELECT A.TCODE, NAME, TTYPE
FROM TRIP A, TRANSPORT B
WHERE A. TCODE = B. TCODE AND KM < 90;
8. SELECT NAME, KM *PERKM
FROM TRIP A, TRANSPORT B
WHERE A. TCODE = B. TCODE AND A. TCODE = 105′;
YOGIC PRACTICES
Procedure for Asanas, Benefit and Contraindication for any 2 Asanas for