如何设计一个支持在线答题中的学习记录和学习历程可视化的系统

# 导入必要的库和模块：
import sqlite3

# 连接数据库：
conn = sqlite3.connect('learning.db')

# 创建学习者表格：
conn.execute('''CREATE TABLE IF NOT EXISTS learner
                (id INTEGER PRIMARY KEY AUTOINCREMENT,
                 username TEXT NOT NULL,
                 password TEXT NOT NULL,
                 email TEXT NOT NULL);''')

# 创建答题记录表格：
conn.execute('''CREATE TABLE IF NOT EXISTS answer
                (id INTEGER PRIMARY KEY AUTOINCREMENT,
                 learner_id INTEGER NOT NULL,
                 question_id INTEGER NOT NULL,
                 answer TEXT NOT NULL,
                 duration INTEGER NOT NULL,
                 FOREIGN KEY (learner_id) REFERENCES learner(id),
                 FOREIGN KEY (question_id) REFERENCES question(id));''')

# 创建问题表格：
conn.execute('''CREATE TABLE IF NOT EXISTS question
                (id INTEGER PRIMARY KEY AUTOINCREMENT,
                 content TEXT NOT NULL,
                 option_1 TEXT NOT NULL,
                 option_2 TEXT NOT NULL,
                 option_3 TEXT NOT NULL,
                 option_4 TEXT NOT NULL,
                 answer TEXT NOT NULL);''')

# 插入学习者数据：
conn.execute("INSERT INTO learner (username, password, email) VALUES ('learner1', 'password1', 'learner1@example.com')")
conn.commit()

# 插入问题数据：
conn.execute("INSERT INTO question (content, option_1, option_2, option_3, option_4, answer) VALUES ('问题1', '选项1', '选项2', '选项3', '选项4', '答案1')")
conn.commit()

# 插入答题记录数据：
conn.execute("INSERT INTO answer (learner_id, question_id, answer, duration) VALUES (1, 1, '答案1', 30)")
conn.commit()

# 查询学习者的答题记录：
cursor = conn.execute("SELECT * FROM answer WHERE learner_id = 1")

# 输出学习者的答题记录：
for row in cursor:
    print("学习者ID：", row[1])
    print("题目ID：", row[2])
    print("答案：", row[3])
    print("答题耗时（秒）：", row[4])
    
# 关闭数据库连接：
conn.close()