--学生表CREATETABLEmember(midchar(10)primarykey,mnamechar(50)notnull,);--课程表CREATETABLEcourse(fidchar(10)primarykey,fnamechar(50)notnull,);--成绩表select*fromscoreCREA...
--学生表
CREATE TABLE member(
mid char(10) primary key,
mname char(50) not null,
);
--课程表
CREATE TABLE course(
fid char(10) primary key,
fname char(50) not null,
);
--成绩表
select * from score
CREATE TABLE score(
scid int identity(1,1) primary key,
fid char(10) foreign key(fid) references course(fid),
mid char(10) foreign key(mid) references member(mid),
sconum int,
);
--课程表中插入数据--
insert into course
values('F001','语文')
insert into course
values('F002','数学')
insert into course
values('F003','英语')
insert into course