基于迎新管理系统的高校新生入学流程优化研究——以广东某高校为例

CREATE TABLE Student (

student_id INT PRIMARY KEY,

name VARCHAR(50),

gender CHAR(1),

birthday DATE,

major VARCHAR(50)

);

CREATE TABLE Dormitory (

dorm_id INT PRIMARY KEY,

dorm_name VARCHAR(50),

capacity INT

);

CREATE TABLE Enrollment (

教材管理系统

student_id INT,

course_id INT,

FOREIGN KEY (student_id) REFERENCES Student(student_id),

FOREIGN KEY (course_id) REFERENCES Course(course_id)

);