Student Attendance Tracker with SQLite

import sqlite3

def init_db():
    with sqlite3.connect("attendance.db") as conn:
        cursor = conn.cursor()
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS students (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                roll_num TEXT UNIQUE NOT NULL,
                name TEXT NOT NULL
            )
        """)
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS attendance (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                student_id INTEGER NOT NULL,
                date TEXT NOT NULL,
                status TEXT CHECK(status IN ('PRESENT', 'ABSENT', 'LATE')),
                FOREIGN KEY(student_id) REFERENCES students(id),
                UNIQUE(student_id, date)
            )
        """)
        conn.commit()