create database example
use example
create table major
(
spno varchar(10) primary key not null,
spname varchar(20) not null
)
create table student
(
sno varchar(10) primary key not null,
sname varchar(10) not null,
ssex varchar(2) not null,
spno varchar(10) foreign key references major(spno)
)
create table course
( cno varchar(10) primary key not null,
cname varchar(10) not null
)
create table scourse
(
sno varchar(10) foreign key references student(sno),
cno varchar(10) foreign key references course(cno),
gmark int
)
insert into major values('001','英语')
insert into major values('002','语文')
insert into major values('003','数学')
insert into major values('004','生物')
insert into major values('005','物理')
insert into major values('006','化学')
insert into student values('2007151301','bobo','男','001')
insert into student values('2007151302','roy','男','002')
insert into student values('2007151303','max','男','004')
insert into student values('2007151304','tony','男','004')
insert into student values('2007151305','jaims','男','005')
insert into student values('2007151306','wing','男','006')
insert into student values('2007151307','allen','男','001')
insert into student values('2007151308','heng','男','002')
insert into student values('2007151309','chart','男','003')
insert into course values('001','乒乓球')
insert into course values('002','篮球')
insert into course values('003','足球')
insert into course values('004','网球球')
insert into course values('005','舞蹈')
insert into course values('006','瑜伽')
insert into course values('007','游泳')
insert into scourse values('2007151301','001','88')
insert into scourse values('2007151302','002','88')
insert into scourse values('2007151303','003','88')
insert into scourse values('2007151304','004','88')
insert into scourse values('2007151305','005','88')
insert into scourse val
