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

Write a Python program to check if a given key already exists in a dictionary.

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

Write two advantages of 3G over 2G Mobile Telecommunication Technologies in terms of speed and services. 

Write a python script to read a number from the user and print the Fibonacci series up to that number.

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

Find and write the output of the following Python code :

Observe the following table and answer the parts (i) and (ii) accordingly

Table: Product

Pno	Name	Qty	PurchaseDate
101	Pen	102	12-12-2011
102	Pencil	201	21-02-2013
103	Eraser	90	09-08-2010
109	Sharpener	90	31-08-2012
113	Clips	900	12-12-2011

(a) Write the names of most appropriate columns, which can be considered as candidate keys.

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

How will you add a column to a pandas DataFrame?

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 update() to accept the values as parameter and update the record according to the passed values. Assuming that values exist in the table.