Data Structure — Computer Science STD 12 Science — Question

Write the freedom related to Open source softwares.

Write a script to create a list of 10 random integers and display it. Then input an integer from the user and check whether it is present in the list (use in operator) and display an appropriate message.

How to add an Index, row, or column to a Pandas DataFrame?

What are the adverse effects of technology?

Write a python program to create the list numeric values and sort the list using Bubble sort technique.

Write a function addrecord() a add new record to the binary file “student” using list. The list should consist of student number, student name and marks of the student.

Describe Data Operations in Pandas.

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

Consider the following tables WORKER and PAYLEVEL and answer (a) and (b) parts of this question:

Relation: WORKER

ECODE	NAME	DESIG	PAYLEVEL	DOJ	DOB
11	Radhey Shyam	Supervisor	P001	13-Sep-2004	23-Aug-1981
12	Chander Nath	Operator	P003	22-Feb-2010	12-Jul-1987
13	Fizza	Operator	P003	14-June-2009	14-Oct-1983
15	Ameen Ahmed	Mechanic	P002	21-Aug-2006	13-Mar-1984
18	Sanya	Clerk	P002	19-Dec-2005	09-June-1983

Relation: PAYLEVEL

PAYLEVEL	PAY	ALLOWANCE
P001	26000	12000
P002	22000	10000
P003	12000	6000

(a) Write SQL commands for the following statements:

(i) To display the details of all WORKERs in descending order of DOB.

(ii) To display NAME and DESIG of those WORKERs whose PLEVEL is either P001 or P002.

(iii) To display the content of all the WORKERs table, whose DOB is in between ’19-JAN- 1984 ’and ’18-JAN-1987 ’.

(iv) To add a new row with the following: 19, ‘Daya kishore ’, ‘Operator ’, ‘P003 ’, ’19-Jun-2008 ’, ’11-Jul-1984 ’

(b) Give the output of the following SQL queries:

(i) Select count(plevel), plevel from worker group by plevel;

(ii) Select max(dob), min(doj) from worker;

(iii) Select name, pay from worker w, paylevel p where w.plevel=p.plevel and w.ecode <13;

(iv) Select plevel, pay+allowance from paylevel where plevel=’p003 ’;

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 ”;