Database Query Using–SQL — Computer Science STD 12 Science — Question

Write a program that reads a string and check whether it is palindrome or not.

Observe the table ‘Club’ given below:

Table: Club

Member_id	Member_Name	Address	Age	Fee
M001	Sumit	New Delhi	20	2000
M002	Nisha	Gurgaon	19	3500
M003	Niharika	New Delhi	21	2100
M004	Sachin	Faridabad	18	3500

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

(ii) 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.

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 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]

Write a function delrecord() to delete the record form the binary file “employee”. The record should be delete on the basis of employee number.

What is Vectorization in Python pandas?

What is Trojan Horse?     

Write script to input two integers and find their LCM.

Write different Time Complexity and Space Complexity of Bubble Sort, Selection Sort and Insertion Sort.

What are the duties of a citizen against e-waste?