-- 教师信息表
CREATE TABLE teachers (
teacher_id INT AUTO_INCREMENT PRIMARY KEY,
teacher_name VARCHAR(10) NOT NULL,
gender CHAR(2)NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
PASSWORD VARCHAR(100) NOT NULL,
department VARCHAR(100)
);
-- 学生信息表
CREATE TABLE students (
student_id INT AUTO_INCREMENT PRIMARY KEY,
student_name VARCHAR(10) NOT NULL,
gender CHAR(2)NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
PASSWORD VARCHAR(100) NOT NULL,
enrolled_courses TEXT
);
-- 课程信息表
CREATE TABLE courses (
course_id INT AUTO_INCREMENT PRIMARY KEY,
course_name VARCHAR(100) NOT NULL,
teacher_id INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
DESCRIPTION TEXT,
FOREIGN KEY (teacher_id) REFERENCES teachers(teacher_id)
);
-- 作业信息表
CREATE TABLE assignments (
assignment_id INT AUTO_INCREMENT PRIMARY KEY,
course_id INT,
student_id INT,
submission_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
grade DECIMAL(5, 2),
FOREIGN KEY (course_id) REFERENCES courses(course_id),
FOREIGN KEY (student_id) REFERENCES students(student_id)
);
-- 学习进度表
CREATE TABLE progress (
progress_id INT AUTO_INCREMENT PRIMARY KEY,
student_id INT,
course_id INT,
last_accessed TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
completed_sections TEXT,
FOREIGN KEY (student_id) REFERENCES students(student_id),
FOREIGN KEY (course_id) REFERENCES courses(course_id)
);写出对应的功能流程图
博客提及了current包的类图，类图是信息技术中用于描述系统中类的结构及类之间关系的重要工具，在软件开发等领域有广泛应用。
扫一扫
173
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
