dbms.txt

来自「可实现科研信息管理系统的功能,有项目管理,教师管理,科研项目管理等多项内容」· 文本 代码 · 共 79 行

CREATE TABLE Department		/*部门信息表*/
(
DNO CHAR(10),
DNAME CHAR(20),
DMANAGER CHAR(8),
DADDRESS CHAR(20),
DZIPCODE CHAR(6),
DPHONE CHAR(12),
PRIMARY KEY(DNO)
);

CREATE TABLE Salary	/*薪水表*/
(
TOAT CHAR(6),
STATIONS NUMBER(5),
ALLOWANCE NUMBER(5),
PRIMARY KEY(TOAT)
);

CREATE TABLE Teacher	/*教师信息表*/
(
TNO CHAR(10),
TNAME CHAR(8),
TSEX CHAR(2),
TBIRTHDAY DATE,
TNATION CHAR(10),
TLEVEL CHAR(10),
TDNAME CHAR(20),
TSTARTTIME DATE,
TOAT CHAR(6),
TBASESALARY NUMBER(5),
PRIMARY KEY(TNO,TNAME),
FOREIGN KEY(TOAT) REFERENCES SALARY(TOAT),
FOREIGN KEY(TDNAME) REFERENCES DEPARTMENT(DNAME)
);

CREATE TABLE Project	/*工程信息表*/
(
PNO CHAR(10),
PNAME CHAR(30),
PTYPE CHAR(10),
PTREASURY NUMBER(10),
PTIME DATE,
PMANAGER CHAR(8),
PRIMARY KEY(PNO),
FOREIGN KEY(PMANAGER) REFERENCES TEACHER(TNAME)
);

CREATE TABLE Attender	/*参加人员表*/
(
PNO CHAR(10),
TNO CHAR(10),
CHARACTOR CHAR(8),
PRIMARY KEY(PNO,TNO),
FOREIGN KEY(PNO) REFERENCES PROJECT(PNO),
FOREIGN KEY(TNO) REFERENCES TEACHET(TNO)
);


CREATE TABLE Achievement	/*科研成果表*/
(
PNAME CHAR(30),
TYPE CHAR(10),
GRADE CHAR(5),
LEVEL CHAR(1),
TIME DATE,
PRIMARY KEY(PNAME),
FOREIGN KEY(PNAME) REFERENCES PROJECT(PANME)
);

CREATE TABLE Reward	/*证书排名表*/
(
PNAME CHAR(30),
TNAME CHAR(8),
ORDER CHAR(1),
PRIMARY KEY(PNAME,TNAME),
FOREIGN KEY(PNAME) REFERENCES PROJECT(PNAME),
FOREIGN KEY(TNAME) REFERENCES TEACHER(TNAME)
);