Student Result Management System

import sqlite3

def init_results_db():
    with sqlite3.connect("results.db") as conn:
        cursor = conn.cursor()
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS courses (
                code TEXT PRIMARY KEY,
                name TEXT NOT NULL,
                credits INTEGER NOT NULL
            )
        """)
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS grades (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                student_id TEXT NOT NULL,
                course_code TEXT NOT NULL,
                grade_point REAL NOT NULL,
                FOREIGN KEY(course_code) REFERENCES courses(code),
                UNIQUE(student_id, course_code)
            )
        """)
        conn.commit()