Review of Python – 1 — Computer Science STD 12 Science — Question

Write a menu based python program using function to find TSA and Vol of Cylinder, Sphere and Cone according to choice entered by the user.

Write AddClient(Client) and DeleteClient(Client) methods in python to add a new Client and delete a Client from a List of Client Names, considering them to act as insert and delete operations of the queue data structure.

Answer the following questions:

Students

Adm No	Name	Class	Sec	R No.	Address	Phone
1271	Utkarsh Madam	12	C	1	C-32, Punjabi Bagh	4356154
1324	Naresh Sharma	10	A	1	31, Mohan Nagar	435654
1325	Md. Yusuf	10	A	2	12/12, Chand Nagar	145654
1328	Sumedha	10	B	23	59, Moti Nagar	4135654
1364	Subya Akhtar	11	B	13	12, Janak Puri	Null
1434	Varuna	12	B	21	69, Rohini	Null
1461	David DSouza	11	B	1	D-34, Model Town	243554. 98787665
2324	Satinder Singh	12	C	1	1/2, Gulmohar Park	143654
2328	Peter Jones	10	A	18	21/328, Vishal Enclave	24356154
2371	Mohini Mehta	11	C	12	37, Raja Garden	435654, 6765787

Sports

Adm No	Game	CoachName	Grade
1324	Cricket	Narendra	A
1326	Volleball	M.P. Singh	A
1271	Volleball	M.P. Singh	B
1434	Basket Ball	I. Malhotra	B
1461	Cricket	Narendra	B
2328	Basket Ball	I. Malhotra	A
2371	Basket Ball	I. Malhotra	A
1271	Basket Ball	I. Malhotra	A
1434	Cricket	Narendra	A
2328	Cricket	Narendra	B
1364	Basket Ball	I. Malhotra	B

(a) Based on these tables write SQL statements for the following queries:

(i) Display the lowest and the highest classes from the table STUDENTS.

(ii) Display the number of students in each class from the table STUDENTS.

(iii) Display the number of students in class 10.

(iv) Display details of the students of Cricket team.

(v) Display the Admission number, name, class, section, and roll number of the students whose grade in Sports table is 'A'.

(vi) Display the name and phone number of the students of class 12 who are play some game.

(vii) Display the Number of students with each coach.

(viii) Display the names and phone numbers of the students whose grade is 'A' and whose coach is Narendra.

(b) Identify the Foreign Keys (if any) of these tables. Justify your choices.

(c) Predict the output of each of the following SQL statements, and then verify the output by actually entering these statements:

(i) SELECT class, sec, count(*) FROM students GROUP BY class, sec;

(ii) SELECT Game, COUNT(*) FROM Sports GROUP BY Game;]

(iii) SELECT Game FROM students, Sports WHERE students.admno = sports.admno AND Students.AdmNo = 1434;

WAP to generate n lines of the following pattern on the computer screen:

Answer the questions with reference to below data frame:

	class	order	max_speed
falcon	bird	Falconiformes	389.0
parrot	bird	Psittaciformes	24.0
lion	mammal	Carnivora	80.2
monkey	mammal	Primates	NaN
leopard	mammal	Carnivora	58.0

(i) To print the class wise sum.

(ii) To print the order wise mean

(iii) To sort the index.

(iv) To print the sum of the class wise along with orders columns indexing.

(v) To count the records.

Write python program using function to find the sum of first n terms of the following series:

where n and x have to be input from the user. The function should have two parameter n and x and return the sum of the series.

Write a python program using function to check whether a number is Armstrong or not. The function will accept a number as parameter.

Write a Function Filter() which will take a list as parameter and made the different lists Even[] and Odd[]. And then combine the two list and return the main list i.e. nested list.

Write the output for the following commands:

Table- Loan_accounts

account	cust_name	loan_amount	installment	int_rate	start_rate	interest
1	R.K. Gupta	300000	36	12.00	2009-07-19	Null
2	S.P. Sharma	500000	48	10.00	2008-03-22	Null
3	K.P. Jain	300000	36	Null	2007-08-03	Null
4	M.P. Yadav	800000	60	10.00	2008-12-06	Null
5	S.P. Sinha	200000	36	12.50	2010-01-03	Null
6	P. Sharma	700000	60	12.50	2008-06-05	Null
7	K.S. Dhall	500000	48	Null	2008-03-05	Null

(a)

(b)

(c)

(d)

(e)