![在这里插入图片描述](https://img-blog.csdnimg.cn/20190317172800258.png)
-- CREATE table sourse(
-- couid char(4),
-- couName VARCHAR(20),
-- teacherName char(3),
-- PRIMARY KEY(couid));
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190317173031216.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Zvcl9zeXE=,size_16,color_FFFFFF,t_70)
-- CREATE table Dep(
-- DepID enum('1001','1002','1003','1004','1005'),
-- CouName char(8),
-- Director char(3),
-- phone char(11),
-- PRIMARY KEY(DepID));
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190317173105134.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Zvcl9zeXE=,size_16,color_FFFFFF,t_70)
-- CREATE TABLE scores(
-- stuid int(8) UNSIGNED auto_increment,
-- Term int(1),
-- couID char(4),
-- Score int(3),
-- PRIMARY KEY(stuid,couID));
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190317173135370.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Zvcl9zeXE=,size_16,color_FFFFFF,t_70)
-- CREATE table stu(
-- Stuid int(8) UNSIGNED auto_increment,
-- stuName char(3),
-- birthday date,
-- sex enum('男','女'),
-- phone int(11) UNSIGNED,
-- class char(15),
-- depID char(4),
-- remark VARCHAR(20),