Given:

Student → Table Rollno, Sname, grade, gender, average, birth-date

Appointment → rollno, duty, age

Example

import sqlite3

connection = sqlite3.connect(“Academy.db”) cursor = connection.cursor( )

cursor.execute(“””DROP TABLE Appointment;”””) sql_command = “””

CREATE TABLE Appointment(rollnointprimarkey,Dutyvarchar(10),age int)”””

cursor.execute(sqlcommand)

sql command – ‘””INSERT INTO Appointment (Rollno,Duty ,age)

VALUES (“1” , “Prefect” , “17”);”””

cursor, execute(sql_command)

sql_command = ”””INSERT INTO Appointment (Rollno,Duty, age)

VALUES (“2” , “Secretary” , “16”);””” 

cursor.execute(sql_command)

# never forget this, if you want the changes to be saved:

connection.commit( )

cursor.execute(“SELECT student.rollno,student.sname,Appointment. 

Duty,Appointment.Age FROM student,Appointment where student.

rollno= Appointment.rollno”)

#print (cursor.description) to display the field names of the table

co= [i[0] for i in cursor.description] print(co)

# Field informations can be readfrom cursor.description.

result = cursor. fetchall( )

for r in result:

print(r)

OUTPUT

[‘Rollno’, ‘Sname’ , ‘Duty’ , ‘age’]

(1, ‘Akshay’ , ‘Prefect’ , 17)

(2, ’Aravind’ , ’Secretary’ , 16)