import sqlite3
connection = sqlite3.connect("college.db")

cursor = connection.cursor()

sql_command = ''' 
CREATE TABLE attendance(
rollno INTEGER,
fname VARCHAR(20),
lname VARCHAR(30),
day DATE,
status CHAR(1) ); '''

cursor.execute(sql_command)

