Bullying Survey for Students, Principals, Teachers and Counsellors

Bullying Survey for Students
This survey is about bullying. Completing this survey honestly will help CBSSE to understand the bullying behaviors that may be prevelant in your school. Answer the questions on this survey as carefully as you can.


Bullying In Schools (For Principals, Teachers and Counsellors)
This survey is an important need assessment component which would help CBSE understand more about the issue of bullying in schools, and subsequently design methodology to address this concern effectively. Kindly, take a few minutes to fill this questionnaire truly and frankly. All responses will be kept confidential.

courtesy @ cbse website

Hard work always pays in life. You can reach every aim you want.

To accomplish great things,
We must not only act,
Bt also dream,
Not only plan bt also believe,
Best wishes for exam.

Sample Question No. 7 for IP - Informatics Practices ( AISSCE 2014 ) _ B

Sample Question No. 7 for IP - Informatics Practices ( AISSCE 2014 ) _ B

[1+1+1+1+1+1+2+1+1]

Answer the following questions:

(a) Study the following table STAFF and SALARY and write MySQL command for the questions (i) to (iv) and give output for the (v) to (vi)

                                                                       Table : STAFF

ID	Name	DEPT	SEX	EXPERIENCE
101	Siddharat	Sales	M	12
104	Raghav	Finance	M	6
107	Naman	Research	M	10
114	Nupur	Sales	F	3
109	Janvi	Finance	F	9
105	Rama	Research	M	10
117	James	Sale	F	3
111	Binoy	Finance	F	12
130	Samuel	Sales	M	15

                                                                       Table : SALARY

ID	BAsic	Allowance	Commission
101	15000	1500	800
104	17000	1200	500
107	16000	1000	200
114	20000	2200	550
109	18000	1000	250
105	15000	1200	150
117	18000	1700	100
111	20000	1500	300
130	18000	1200	500

(i) Display NAME of all the staff who is in SALES having more than 10 years experience from the table staff.

(ii) Display the average Basic Salary of all staff working in “Finance” department using the table staff and salary.

(iii) Display the minimum ALLOWANCE of female staff.

(iv) Display the highest commission among all male staff.

(v) Select count(*) from STAFF where sex=’F’;

(vi) SELECT name, dept, basic FROM staff, Salary WHERE dept=’sales’ and staff.id=salary.id;

Answer the following question based on the table VOTER given below:

                                                                       Table : VOTER

Column Name	Data Type	Size	Constraints	Description
V_id	BIGNT	8	Primary Key	Voter identification
Vname	VARCHAR	25	Not Null	Name of the voter
Age	INT	3	Check > 17	Age should not less than equal to 17
Address	VARCHAR2	30		Address of voter
Phone	VARCHAR	10		Phone number of the voter

(i) Write an SQL command to create the above table.

(ii) Write the command to delete all the rows of particular voter from the table voter where voter ID between 10 and 20.

(iii) Delete the table physically.

Sample Question No. 7 for IP - Informatics Practices ( AISSCE 2014 ) _ A

Sample Question No. 7 for IP - Informatics Practices ( AISSCE 2014 ) _ A

[1+2+2]

(a) What is database connectivity?

(b) Write the societal impact of e-learning?

(c) Mr. Kunal is working as a booking clerk in Raj mahal Hotel. He wants to create the forms with the following functions. Choose appropriate controls from Text Field, Lable, Radio Button, Check Box, List Box, Combo Box and Command Button and write in the third column.

S.no	Control used for	Control
1	Choose room type from a list of Room Type
2	Display Room Number
3	To show list of booked room
4	To enter date of checkin

Sample Question No. 6 for IP - Informatics Practices ( AISSCE 2014 ) _ B

Sample Question No. 6 for IP - Informatics Practices ( AISSCE 2014 ) _ B

[2+2+6]

Answer the following questions.

(a) Write an SQL query to creat the table “Items” with the following structure -

Field	Type	Constraint
Item_id	Varchar(5)	Primary Key
Item_Name	Varchar(25)
Manufacturer	Varchar(15)
Color	Varchar(15)
Price	Integer	Must between 399 and 4999
Quantity	Integer	Not null

(b) in a database there are two tables ‘Dress’ and ‘Material’ shown below-

                                                                       Table : Dress

Dcode	Description	Price	MCode	LaunchDate
1002	Trouser	999	M002	15-12-2010
2006	Coat	1599	M001	27-09-2009
1036	Sweater	540	M001	11-01-2008
1789	Frock	1950	M003	31-12-2010

                                                                  Table : Material

MCode	Type
M001	Woolen
M002	Cotton
M003	Polyester
M004	Silk
M005	Denim

(i) Name the columns which can be made ‘Foreign Key’ in both the tables.

(ii) Write SQL statement to display the dress details which are made up of woolen?

(c) Consider the tables give below.

                                                                Table : Books

Book_Id	Book_Name	Author_Name	Publisher	Price	Type	Quantity
B0001	Harry Potter	J.K. Rolling	BPB	525	Fiction	15
B0013	Vision 2020	A.P.J.A. Kalam	TMH	333	Informative	10
B0152	Let Us C++	Y.K.	BPB	625	Text	50
B1102	Applied Physics	H. C. Verma		745	Text	44
B2314	Godan	Premchand		125	Novel	50

                                                                  Table : Issued

Book_Id	DateofIssue	Member_ID
B0152	15-12-2010	M008
B2314	25-10-2010	M112
B0001	31-12-2010	M110

With reference to these tables, write commands in SQL for (i) and (ii) and output for (iii) below-

(i) To display the name of the book issued to member M112.

(ii) To display the type wise no. of books and total quantity of all type of book.

(iii) SELECT Book_Name, Quantity FROM Books WHERE publisher IN(‘TMH’,NULL);