A departmental store "ABC" is considering maintaining their inventory using SQL to store data and maintain basic transactions. As a database manager, Mehak has to create two tables as Customer & Transaction:

Table: CUSTOMER

CNo	CNAME	ADDRESS
101	Richa Jain	Delhi
102	Surbhi Sinha	Chennai
103	Lisa Thomas	Bengaluru
104	Imran Ali	Delhi
105	Roshan Singh	Chennai

Table: TRANSACTION

Dept	CNO	AMOUNT	TYPE	DOT
T001	101	1500	Credit	2017-11-23
T002	103	2000	Debit	2017-05-12
T003	102	3000	Credit	2017-06-10
1004	103	12000	Credit	2017-09-12
T005	101	1000	Debit	2017-09-05

(i) Identify the attribute best suited to be declared as a Primary key in customer table.

(ii) Help Mehak to display details of all transactions of TYPE Credit from Table TRANSACTION.

(iii) Mehak wants to display all CNO, CNAME and DOT (date of transaction) of those CUSTOMERS from tables CUSTOMER and TRANSACTION who have done transactions more than or equal to 2000 for the Balance Sheet.

(iv) Mehak wants to display the last date of transaction (DOT) from the table TRANSACTION for the customer having CNO as 103. Which command will she use?

Sonia was writing a code to insert multiple rows in the cust.csv file. By mistake her younger sister removed some parts of it. Now she is totally confused about used module and other options:

from csv import writer 
with ............... ("cust.csv", "a", newline = "\n") as f:     #line 1
    dt = writer(...............)                                #line 2
    while True:                                                #line 3 
        sno= int (input ("Enter Serial No: ") )
        cust_name = input ("Enter customer name: ")
        city = input ("Enter city: ")
        amt = int (input ("Enter amount: ") )
        dt. ............... ( [sno, cust name, city, amt] )          #line 4
        print ("Record has been added.")
        print ("Want to add more record?Type YES!!!")

        ch = input()                                                       #line 5
        ch = ch.upper()
        if ch=="YES": 
            print("*")
        else:
            break

Attempt any 4 out of the given questions:

(i) Name the method Sonia should use in Line 1.

(ii) Which object Sonia should use to connect the file in Line 2?

(iii) What is the use of Line 3?

(iv) Name the method she should use in Line 4.

(v) What is the use of Line 5?

Write the output of the code given below:

p=8
def sum(q=5, r=6) :
    p=(r+q)**2
    print(p, end= '#')
sum(p)
sum(r=3,q=2)

The code given below accepts the roll number of a student and deletes the record of that student from the table STUDENT. The structure of a record of table Student is: RollNo — integer; Name — string; Class — integer; Marks — integer.

Note the following to establish connectivity between Python and MySQL:
• Username is root, Password is A5_b23.
• The table exists in a MySQL database named SCHOOL.

Write the following missing statements to complete the code:

Statement 1— to create the cursor object

Statement 2 — to execute the query

Statement 3 — to make the deletion in the database permanent

import mysql.connector as mysql
def sql data(): 
    conn=mysql.connect(host="localhost",
                        user="root",
                        password=" ",
                        database="school")
    ...............                                               #Statement 1
    rno=int(input("Enter Roll Number : "))
    qry="delete from student where RollNo={}".format(rno)
    ...............                                               #Statement 2 
    ...............                                               #Statement 3
    print ("Record deleted")