SQL数据库设计：创建学生表和课程表并添加测试数据

创建学生表student和添加测试数据的SQL语句如下：

-- 创建学生表student CREATE TABLE student ( Stuid INT PRIMARY KEY AUTO_INCREMENT, StuName VARCHAR(50) NOT NULL, StuGender VARCHAR(2) DEFAULT '男', StuAge INT(2) CHECK (StuAge >= 0), StuEmail VARCHAR(50) UNIQUE );

-- 添加测试数据 INSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('张三', '男', 20, 'zhangsan@example.com');

INSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('李四', '女', 21, 'lisi@example.com');

INSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('王五', '男', 22, 'wangwu@example.com');

INSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('赵六', '女', 23, 'zhaoliu@example.com');

INSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('陈七', '男', 24, 'chenqi@example.com');

创建课程表course和添加测试数据的SQL语句如下：

-- 创建课程表course CREATE TABLE course ( CourseId INT PRIMARY KEY AUTO_INCREMENT, CourseName VARCHAR(50) NOT NULL );

-- 添加测试数据 INSERT INTO course (CourseName) VALUES ('语文');

INSERT INTO course (CourseName) VALUES ('数学');

INSERT INTO course (CourseName) VALUES ('英语');