项目管理

create database web;
use web;
create table stu(
Sno VARCHAR(20) NOT NULL,
Spassword VARCHAR(100) NOT NULL,
Ssex VARCHAR(100) NOT NULL,
Sname VARCHAR(100) NOT NULL,
Sphone VARCHAR(100) NOT NULL,
Sclass VARCHAR(100),
PRIMARY KEY(Sno)
)ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

insert into stu values(‘19130101’,’123456’,’男’,’cs1’,’1565111111’,’1’);
insert into stu values(‘19130102’,’123456’,’男’,’cs2’,’1565111111’,’1’);
insert into stu values(‘19130103’,’123456’,’男’,’cs3’,’1565111111’,’1’);
insert into stu values(‘19130104’,’123456’,’男’,’cs4’,’1565111111’,’1’);
insert into stu values(‘19130105’,’123456’,’男’,’cs5’,’1565111111’,’1’);
insert into stu values(‘19130106’,’123456’,’男’,’cs6’,’1565111111’,’1’);

create table cou(
Cno VARCHAR(20) NOT NULL,
Cname VARCHAR(100) NOT NULL,
PRIMARY KEY(Cno)
)ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

insert into cou values(‘0001’,’软件项目管理’);
insert into cou values(‘0002’,’软件项目管理’);
insert into cou values(‘0003’,’软件项目管理’);
insert into cou values(‘0004’,’软件项目管理’);

create table tea(
Tno VARCHAR(20) NOT NULL,
Tpassword VARCHAR(100) NOT NULL,
Tname VARCHAR(100) NOT NULL,
Tsex VARCHAR(100) NOT NULL,
Tphone VARCHAR(100) NOT NULL,
PRIMARY KEY(Tno)
)ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

insert into tea values(‘001’,’123456’,’laoshi1’,’nan’,’123456789’);
insert into tea values(‘002’,’123456’,’laoshi1’,’nan’,’123456789’);
insert into tea values(‘003’,’123456’,’laoshi1’,’nan’,’123456789’);
insert into tea values(‘004’,’123456’,’laoshi1’,’nan’,’123456789’);
insert into tea values(‘005’,’123456’,’laoshi1’,’nan’,’123456789’);
insert into tea values(‘006’,’123456’,’laoshi1’,’nan’,’123456789’);

create table SC(
Sno VARCHAR(20) NOT NULL,
Cno VARCHAR(100) NOT NULL,
Grade DOUBLE NULL,
State TINYINT null，
PRIMARY KEY(Sno,Cno),
FOREIGN KEY (Cno) REFERENCES cou(Cno) ON UPDATE CASCADE,
FOREIGN KEY (Sno) REFERENCES stu(Sno) ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

create table TC(
Tno VARCHAR(20) NOT NULL,
Cno VARCHAR(100) NOT NULL,
PRIMARY KEY(Tno,Cno),
FOREIGN KEY (Cno) REFERENCES cou(Cno) ON UPDATE CASCADE,
FOREIGN KEY (Tno) REFERENCES Tea(Tno) ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC