创建数据库表及添加数据的sql语句

1,数据表的创建
create table Course (
cno char(8) not null,
cname varchar(50) not null,
cteacher varchar(20),
primary key (cno)
);
create table Student (
sno char(8) not null,
sname varchar(20) not null,
age smallint not null,
primary key (sno)
);
create table Relation (
sno char(8) not null,
cno char(8) not null,
score integer,
primary key (sno, cno)
);
create table dropTest(
dno char(8) not null,
dname char(8) not null,
dother integer,
primary key (dno)
);
//添加外键
alter table Relation
add foreign key FK_R_S (sno)
references Student (sno)
on update restrict
on delete restrict;

alter table relation
add foreign key FK_R_C (cno)
references Course (cno)
on update restrict
on delete restrict;
2，添加数据
insert into Student (sno, sname, age) values ('20080002', '杨二', 20);
insert into Student (sno, sname, age) values ('20080003', '张三', 21);
insert into Student (sno, sname, age) values ('20080004', '李四', 19);
insert into Student (sno, sname, age) values ('20080005', '王五', 20);
insert into Student (sno, sname, age) values ('20070005', '麻子', 20);
insert into Student (sno, sname, age) values ('20060005', '麻将', 20);
insert into Student (sno, sname, age) values ('20050005', '麻将', 25);

insert into Course (cno, cname, cteacher) values ('00000001', '计算机信息管理基础', '曾一');
insert into Course (cno, cname, cteacher) values ('00000002', '计算机文化基础', '赵六');
insert into Course (cno, cname, cteacher) values ('00000003', '大学英语', '郝七');

insert into Relation (sno, cno) values ('20080002', '00000001');
insert into Relation (sno, cno) values ('20080003', '00000001');
insert into Relation (sno, cno) values ('20080005', '00000001');
insert into Relation (sno, cno, score) values ('20080004', '00000002', 80);
insert into Relation (sno, cno, score) values ('20080005', '00000002', 95);
insert into Relation (sno, cno, score) values ('20080002', '00000003', 60);