Skip to content
Posted on: 2019-07-29 2020-06-13 Categories: 강의자료, 데이터베이스, 프로젝트기반
CREATE TABLE"tbook"(
"no"TEXT,
"title"TEXT,
"pric"INTEGER,
"publ"TEXT,
PRIMARY KEY("no")
);
CREATE TABLE"tmember"(
"name"TEXT,
"dept"TEXT,
"major"TEXT,
CREATE TABLE"tlend"(
"bno"TEXT,
"mno"TEXT,
"cdate"NUMERIC DEFAULT CURRENT_TIMESTAMP,
"days"INTEGERDEFAULT14,
PRIMARY KEY("no"),
FOREIGN KEY("bno")REFERENCES tbook(no)
ON DELETE SET NULL
ON UPDATE CASCADE,
FOREIGN KEY("mno")REFERENCES tmember(no)
ON UPDATE CASCADE
FOREIGN KEY("bno")REFERENCES "tbook"("KEYWORDASCOLUMNNAME")
FOREIGN KEY("mno")REFERENCES "tmember"("KEYWORDASCOLUMNNAME")
CREATE VIEW vlendablebook AS
SELECT *FROM tbook
WHERE no NOTIN(SELECT bno FROM tlend);
CREATE VIEW vlendbook AS
SELECT tlend.no,tlend.bno,tlend.mno,tlend.cdate, tlend.days,
tbook.title astitle,
tmember.name asname
FROM tlend,tbook,tmember
WHERE tlend.bno=tbook.no ANDtlend.mno=tmember.no
error: Content is protected !!