Write a program to read the records from laps.csv.

(a) To display the CODE and NAME of all salesperson having “I7” item Type Code from the table SALESPERSON.
(b) To display all details from table SALESPERSON in descending order of SALARY.
(c) To display the number of SALESPERSON dealing in each TYPE of ITEM.(Use ITCODE for the same)
(d) To display NAME of all the salesperson table along with their corresponding ITEMTYPE from the ITEM table.
(e) Select max(salary) from salesperson;
(f) Select distinct itcode from salesperson;
(g) select code,name,i.itcode from sales persons, item i where s.itcode=i.itcode and turnover>=7000000;
(h) Select sum (salary)from salesperson where itcode=”i2”;

→

Out of the following, which all comes under cyber crime? [Delhi 2015]

(a) Stealing away a brand new computer from a showroom.

(b) Getting in someone’s social networking account without his consent and posting pictures on his behalf to harass him.

(d) Viewing sites on a internet browser.

→

Write the Law related to Identity theft in India.

→

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

→

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.

→