Societal Impacts — Computer Science STD 12 Science — Question

Write a program that reads a string and print and count the Upper case characters, Lower case characters and
other characters.

WAP to display all the prime numbers between m and n, where m and n have to be input from the user.

Write a program to read the records from laps.csv.

How can you get the sum of values of a column in pandas DataFrame?

Find the output:

Consider the following table Student & Stream.

Table: Student

Admno	Sname	Class	Sec	Fee	Mobile	Area	S_ID
1001	RAMESH	XII	A	2500	987654321	Madipur	10
1078	KRISHNA	XII	B	2400	999911111	Jawala Heri	30
1006	FARDEEN	XII	C	2600	987654321	Paschim Puri	40
1004	SUBHAM	XII	A	2500	963025874	Madipur	20
1029	KRITIKA	XI	C	2700	987456210	Madipur	30
1008	SAMEEKSHA	XII	A	2450	987123456	Mangol Puri	20
1025	SALMA	XII	B	2580	998877445	Madipur	30
1036	AMANDEEP	XII	B	2600	999333555	Khyala	40
1037	TEJAS	XI	C	2650	987951357	Paschim Puri	40
1029	HIMANSHU	XII	A	2750	951369874	Jawala Heri	10

Table : Stream

S_ID	Stream_name
10	MEDILCAL
20	NON MEDICAL
30	COMMERCE WITH MATH
40	COMMERCE WITH IP
50	HUMANITIES

Write SQL commands for the statements (a) to (h) on the above table: Student and Stream
(a) Identify Primary Keys and Foreign Key in the table student and primary key in Stream table given above.
(b) Display stream id and stream-wise total fee collected.
(c) Count no of students from each area.
(d) Display all the student details those who belongs to Madipur Area.
(e) Increase the fees of all students by10%.
(f) Display unique area from the student table.
(g) Display details of those students whose area contains ‘Puri’.
(h) Display the information of those students who are in class XII and section is either B or C.

What is a scam? Write a few examples.

What is child identity theft?

A school with 20 stand -alone computers is considering to network them together and adding a server. State two advantages of doing this.