import sqlite3
def create_tables():
conn = sqlite3.connect('alumni_system.db')
cursor = conn.cursor()
# 创建校友信息表
cursor.execute('''
CREATE TABLE IF NOT EXISTS alumni (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
graduation_year INTEGER,
major TEXT
)
''')
# 创建课程表
cursor.execute('''
CREATE TABLE IF NOT EXISTS course_schedule (
id INTEGER PRIMARY KEY AUTOINCREMENT,
course_name TEXT NOT NULL,
start_time TEXT,
end_time TEXT,
classroom TEXT
)
''')
# 创建教师信息表
cursor.execute('''
CREATE TABLE IF NOT EXISTS teacher (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
department TEXT
)
''')
conn.commit()
conn.close()
create_tables()
]]>
def check_conflicts(course_a, course_b):
if course_a['classroom'] == course_b['classroom']:
if (course_a['start_time'] < course_b['end_time']) and (course_a['end_time'] > course_b['start_time']):
return "Conflict detected!"
return "No conflict."
]]>