【【2019-2020春学期】数据库作业春学期】数据库作业14:第五章::第五章: 数据库完整性数据库完整性 习题习题 + 存储过程存储过程
6、、
(1)
/*定义关系模式职员*/
CREATE TABLE Staff
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Sage SMALLINT,
SJob CHAR(10),
Sal INT,
Dno CHAR(20)
)
/*定义关系模式部门*/
CREATE TABLE Department
(Dno CHAR(20) PRIMARY KEY,
Dname CHAR(20),
Manager CHAR(20),
Tel CHAR(10)
)
(2)
CREATE TABLE Department
(Dno CHAR(20) PRIMARY KEY,
Dname CHAR(20),
Manager CHAR(20),
Tel CHAR(10)
)
CREATE TABLE Staff
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Sage SMALLINT,
SJob CHAR(10),
Sal INT,
Dno CHAR(20),
FOREIGN KEY(Dno) REFERENCES Department(Dno)
)
(3)
CREATE TABLE Department
(Dno CHAR(20) PRIMARY KEY,
Dname CHAR(20),
Manager CHAR(20),
Tel CHAR(10)
)
CREATE TABLE Staff
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Sage SMALLINT CHECK(Sage<=60),
SJob CHAR(10),
Sal INT,
Dno CHAR(20),
FOREIGN KEY(Dno) REFERENCES Department(Dno)
)
进行检测:
INSERT INTO Staff(Sno,Sname,Sage,SJob,Sal)
VALUES('20121501','佟陆陆',26,'经理',5000)
SELECT * FROM Staff