create database stuexpm;
use stuexpm;
create table studentinfo
(
studentid varchar(6) not null primary key comment '学号',
Name varchar(8) not null comment '姓名',
Sex varchar(2) not null comment '性别',
Birthday date not null comment '出生日期',
Speciality Varchar(12) null comment '专业',
Address varchar(20) null comment '家庭地址'
);
use stuexpm;
insert into Teacherinfo
values
('100005','李慧强','男','1968-09-25','计算机学院','北海市海定区'),
('100024','刘松','男','1976-02-17','计算机学院','北京海定区'),
('400021','陈霞飞','女','1975-12-07','通信学院','上海市黄浦区'),
('800004','刘泉明','男','1978-08-16','数学学院','广州市越秀区'),
('120007','张莉','女','1982-03-21','外国语学院','城都市锦江区');
use stuexpm;
create table Courseinfo
(
Courseid varchar(6) not null primary key comment '课程号',
CourseName varchar(16) not null comment'课程名',
Credit tinyint null comment '学分'
);
use stuexpm;
create table Scoreinfo
(
Studentid varchar(6) not null comment '学号',
CourseID varchar(4) not null comment '课程号',
Grade tinyint null comment '成绩',
primary key(studentID,CourseID)
);
use stuexpm;
create table Teacherinfo
(Teacherid varchar(6) not null primary key comment '教师编号',
teacherName varchar(8) not null comment '姓名',
TeacherSex varchar(2) not null default '男' comment '性别',
Teacherbirthday date not null comment '出生日期',
School varchar(12) null comment '学院',
Address varchar(20) null comment '地址'
);
select * from Teacherinfo;
use stuexpm;
insert into studentinfo
values
('181001','成志红','男','1998-08-17','计算器','北京市海淀区'),
('181002','孙红梅','女','1997-11-23','计算器','成都市锦江市'),
('181003','朱莉','女','1998-02-19','计算器','北京市海淀区'),
('184001','王智勇','男','1997-12-05','电子信息工程','NULl'),
('184002','周璐璐','女','1998-02-24','电子信息工程','上海浦东区'),
('184004','郑永波','男','1997-09-19','电子信息工程','上海浦东区');
select * from studentinfo
use stuexpm;
insert into Scoreinfo
values('181001','1004',95),
('181002','1004',91),
('184001','8001',85),
('184004','8001',NULL),
('181003','1004',91),
('184004','8001',94),
('184001','4002',93),
('181001','1201',92),
('184002','4002',76),
('181002','1201',78),
('184004','4002',88),
('181003','1201',94),
('181001','8001',94),
('184002','1201',79),
('181002','8001',89),
('184002','1201',79),
('181003','8001',86),
('184004','1201',94);
select * from Scoreinfo;
use stuexpm;
insert into Teacherinfo
values
('10005','刘慧强','男','1968-09-25','计算机学院','北京市海淀区'),
('100024','刘松','男','1976-02-17','计算机学院','北京市海淀区'),
('400021','陈霞飞','女','1975-12-07','通信学院','上海市黄浦区'),
('800004','刘明泉','男','1978-08-16','数字学院','广州市越秀区'),
('120007','张莉','女','1982-03-21','外国语学院','城都市靖江区');
select * from Teacherinfo
————————————————
版权声明:本文为CSDN博主「zhou202109525」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/zhou202109525/article/details/129686105