course 系统1.2

create table grade(

id int primary key auto_increment,

gno int,

gcno int not null,

ggrade float(3,1));

alter table grade change gno gno int not null;

insert into grade values(null,1,2017001,98),(null,2,2017001,95),(null,3,2017001,91),(null,1,2017002,88),(null,2,2017002,85),(null,3,2017002,81),(null,1,2017003,78),(null,2,2017003,75),(null,3,2017003,71);

select * from grade where gcno=2017002;

select * from course inner join grade on course.cno=grade.gno;

create table student(

sno int primary key,

sname varchar(20));

insert into student values(2017001,"tom"),(2017002,"jerry"),(2017003,"jack");

select * from student inner join grade on student.sno=grade.gcno;