创建表.txt

来自「java平台开发学生管理系统 功能较全」· 文本 代码 · 共 40 行

CREATE TABLE STUDENT(
SNO CHAR(10) PRIMARY KEY,
SNAME CHAR(10),
SEX CHAR(4),
AGE SMALLINT,
USERNAME CHAR(10),
PASSWORD CHAR(10)
);


CREATE TABLE SC(
SNO CHAR(10),
CNO CHAR(10),
GRADE INT,
PRIMARY KEY (SNO,CNO),
FOREIGN KEY (SNO) REFERENCES STUDENT(SNO),
FOREIGN KEY (CNO) REFERENCES COURSE(CNO)
);



CREATE TABLE COURSE(
CNO CHAR(10) PRIMARY KEY,
CNAME CHAR(15),
CREDIT INT
);




CREATE TABLE MANAGER(
MNO CHAR(10) PRIMARY KEY,
MNAME CHAR(10),
MSEX CHAR(4),
MAGE INT,
USERNAME CHAR(10),
PASSWORD CHAR(10)
);