【列表00000】

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