Functions — Computer Science STD 12 Science — Question

Write the function Insertion() to sort the list using Insertion sort technique. The function will take the list as parameter.

Write SQL commands for the following queries on the basis of Club relation given below:

Relation: Club

Coach-ID	CoachName	Age	Sports	date_of_app	Pay	Sex
1	Kukreja	35	Karate	27/03/1996	1000	M
2	Ravina	34	Karate	20/01/1998	1200	F
3	Karan	34	Squash	19/02/1998	2000	M
4	Tarun	33	Basketball	01/01/1998	1500	M
5	Zubin	36	Swimming	12/01/1998	750	M
6	Ketaki	36	Swimming	24/02/1998	800	F
7	Ankita	39	Squash	20/02/1998	2200	F
8	Zareen	37	Karate	22/02/1998	1100	F
9	Kush	41	Swimming	13/01/1998	900	M
10	Shailya	37	Basketball	19/02/1998	1700	M

(a) To show all information about the swimming coaches in the club.

(b) To list the names of all coaches with their date of appointment (date_of_app) in descending order.

(c) To display a report showing coach name, pay, age, and bonus (15% of pay) for all coaches.

(d) To insert a new row in the Club table with ANY relevant data:

(e) Give the output of the following SQL statements:

(i) Select COUNT(Distinct Sports) from Club;

(ii) Select Min(Age) from Club where SEX = “F ”;

Write a menu driven python program using function InQ(), DelQ() and DisplayQ() to implement the Queue. The program will store the name of the books.

Write a function search () to search a record in a binary file according to the student number entered by the user. Also display the message “Record not found” in case record not found in the file.

WAPssuming the given dataset answer the questions below:

https://data.gov.in/catalog/statistical-hand-book-2009-education?filters%5Bfield_catalog_reference%5D=6690578& format=json&offset=6&limit=6&sort%5Bcreated%5D=desc

Schools for Professional Education 2007-08 : SHB 2009

(i) Write a python / statement to read the data frame.

(ii) Write a python code to plot the pie chart of all the institutions which have more than hundred teachers. Also display the values of portion.

(iii) Write a python code to plot the horizontal bar chart to plot the Type of institution and Total students.

(iv) Write a python code to plot the scatter diagram boys vs girls students.

(v) Write a python code to plot the histogram for no. of institution.

Write a script to create a list of 10 random floating point numbers and then
(a) Find the mean of the elements present in the list (without using sum() function)
(b) Find the mean of all those elements of the list which are more than the mean calculated in 5c (above part of the question)

Write algorithm for PUSH(insert) operation in stack.

Write a program to enter a string and remove all punctuation characters from the following string.

Write a script to create two lists of 5 floating point values each and then
(a) Sort the first list using sort() method and display it without using any loop
(b) Reverse the second list using reverse() method and display it without using any loop
(c) Append the second list to the first list using extend() method
(d) Delete all the elements from the second list using clear() method
(e) Display the first list (after performing the above operations)
(f) Input an integer from the user and find how many times does it exist in the first list using count() method

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