基于‘教材发放管理系统’与‘用户手册’的试用分析

-- 创建教材表

CREATE TABLE Textbook (

id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(100) NOT NULL,

author VARCHAR(50),

edition VARCHAR(20)

);

-- 创建学生表

CREATE TABLE Student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

major VARCHAR(50),

grade INT

);

-- 创建发放记录表

CREATE TABLE DistributionRecord (

id INT AUTO_INCREMENT PRIMARY KEY,

textbook_id INT,

student_id INT,

distribution_date DATE,

FOREIGN KEY (textbook_id) REFERENCES Textbook(id),

FOREIGN KEY (student_id) REFERENCES Student(id)

);

]]>