MySQL学生选修成绩表测试数据

最新推荐文章于 2024-09-05 16:12:59 发布

kk123k

最新推荐文章于 2024-09-05 16:12:59 发布

阅读量2.8k

点赞数 4

分类专栏： MySQL 文章标签： MySQL 测试数据

本文链接：https://blog.csdn.net/kk123k/article/details/80624447

版权

MySQL 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

建立以下表：

Student(Sno,Sname,Ssex) 学生表
Teacher(Tno,Tname) 教师表
Course(Cno,Cname,Tno) 选修课程表
SC(Sno,Cno,score) 成绩表

CREATE TABLE student 
  ( 
     sno   INT, 
     sname VARCHAR(32), 
     ssex  VARCHAR(8) ,
     primary key (sno)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE teacher 
  ( 
     tno   INT, 
     tname VARCHAR(32) ,
     primary key (tno)
  )ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE course 
  ( 
     cno    INT , 
     cname  VARCHAR(32), 
     tno    INT ,
     primary key (cno)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE sc 
  ( 
     sno    INT , 
     cno    INT , 
     score  INT ,
     primary key (sno,cno)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

测试数据：

insert into student values (1001,'牛一','男');
insert into student values (1002,'蔡二','女');
insert into student values (1003,'张三','男');
insert into student values (1004,'李四','女');
insert into student values (1005,'王五','男');
insert into student values (1006,'李志基','男');
insert into student values (1007,'陈李强','男');
insert into student values (1008,'王八','女');
insert into student values (1009,'张仲景','男');


insert into teacher values (1001,'叶平');
insert into teacher values (1002,'李金洋');
insert into teacher values (1003,'易法令');
insert into teacher values (1004,'李闵');
insert into teacher values (1005,'陈国华');


insert into course values (001,'高等数学',1001);
insert into course values (002,'马克思',1001);
insert into course values (003,'大学英语',1002);
insert into course values (004,'数据库',1002);
insert into course values (005,'数据结构',1003);



insert into SC values (1001,001,100);
insert into SC values (1001,002,80);
insert into SC values (1001,003,70);
insert into SC values (1001,004,60);
insert into SC values (1001,005,50);

insert into SC values (1002,001,60);
insert into SC values (1002,002,50);
insert into SC values (1002,003,80);
insert into SC values (1002,004,30);
insert into SC values (1002,005,100);

insert into SC values (1003,001,60);
insert into SC values (1003,002,80);
insert into SC values (1003,003,60);
insert into SC values (1003,004,40);

insert into SC values (1004,001,20);
insert into SC values (1004,002,100);
insert into SC values (1004,003,30);
insert into SC values (1004,005,40);

insert into SC values (1005,002,80);
insert into SC values (1005,003,60);
insert into SC values (1005,004,50);

insert into SC values (1006,002,100);
insert into SC values (1006,005,100);
insert into SC values (1007,001,50);
insert into SC values (1007,004,40);
insert into SC values (1008,003,60);