CREATE TABLE students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

student_id TEXT UNIQUE,

class TEXT,

major TEXT

);

import sqlite3

def add_student(name, student_id, class_name, major):

conn = sqlite3.connect('school.db')

cursor = conn.cursor()

cursor.execute("INSERT INTO students (name, student_id, class, major) VALUES (?, ?, ?, ?)",

(name, student_id, class_name, major))

conn.commit()

conn.close()

def get_students():

conn = sqlite3.connect('school.db')

cursor = conn.cursor()

cursor.execute("SELECT * FROM students")

result = cursor.fetchall()

conn.close()

return result