MYSQL with Python Interface — Computer Science STD 12 Science — Question

Find and write the output of the following Python code :

Write the function definition for the following: (a) A function ADD() accepts two parameters. (b) A function ADD() accepts two parameters and returns a single value. (c) A function Vote_Casting() will accepts age and citizen as parameter returns Boolean value. (d) A function Show () accepts no parameters and returns nothing.

Write a program using recursion function to accept the list from the user and print sum of all the elements in the list.

Write a menu driven program to calculate the total surface area and volume of a cube, cuboid, or sphere depending upon user's choice. The program should continue until the user selects the option to exit the program.
Script:

Write a function to read the content from the "quotes.txt" and transfer the content to the file "Duplicate.txt" but while transfer all the upper case character to lower case character, lower case character to uppercase character and rest of the character as it is.

Write a program using pandas to do the following task

(a) To create the, Data Frame with columns Name, Occupation, Date of join, Age. The datafrme should contain only 2 rows.

(b) Add the index Emp001 and Emp002.

(c) Print the data

(d) Add a new row [Emp003]

Consider the following table Bank.

Table: Bank

AccNo	Cust_name	FD_Amount	Months	Int_Rate	FD_Date
1001	Arti Gupta	30000	36	6.00	2018-07-01
1002	Dilip Lal	50000	48	6.75	2018-03-22
1003	Navin Gupta	30000	36	NULL	2018-03-01
1004	D.P. Yadav	80000	60	8.25	2017-06-12
1005	Jyoti Sharma	20000	36	6.50	2017-01-31
1006	Rakesh Kumar	70000	60	8.25	2018-06-15
1007	K.D. Singh	50000	48	NULL	2018-07-05
1008	Anjali Sharma	60000	48	6.75	2017-04-02
1009	Swati Garg	40000	42	6.50	2018-06-15
1010	Rupinder Kaur	25000	36	6.50	2018-09-27

Write SQL commands for the statements (a) to (g) on the table BANK
(a) Display details of all the FD whose rate of interest is NOT NULL.
(b) Display amounts of various FD from the table Bank. An FD Amount should appear only once.
(c) Display the number of months of various loans from the table Bank. A month should appear only once.
(d) Display the Customer Name and FD Amount for all the Bank which do not have a number of months is 36.
(e) Display the Customer Name and FD Amount for which the FD amount is less than 500000 or int_rate is more than 7.
(f) Display the details of all FD which started in the year 2018.
(g) Display the details of all FD whose FD_Amount is in the range 40000 to 50000.

Write the python function to accept the name as parameter and find out whether record present in the table or not. (Assuming that table already exists)

Consider the table: CLUB as given below:

Table: CLUB

MEMBER_ID	MEMBER_NAME	ADDRESS	AGE	FEE
M002	NISHA	GURGAON	19	3500
M003	NIHARIKA	NEW DELHI	21	2100
M004	SACHIN	FARIDABAD	18	3500

(a) What is the cardinality and degree of the above given table?

(b) If a new column contact_no has been added and three more members have joined the club then how these changes will affect the degree and cardinality of the above given table.