建立以下表:
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,'牛一',