2020-12-16

USE TSGL
CREATE TABLE CARD
(CNO NCHAR(6),
NAME NCHAR(6),
CLASS NCHAR(15),
PRIMARY KEY(CNO));

CREATE TABLE BOOKS
(BNO NCHAR(6),
BNAME NCHAR(15),
AUTHOR NCHAR(15),
PRICE MONEY,
QUANTITY INTERGER,
PRIMARY KEY(BNO));

CREATE TABLE BORROW
(CNO NCHAR(6),
BNO NCHAR(6),
RDATE DATE,
PRIMARY KEY(CNO,BNO),
FOREIGN KEY(CNO) REFERENCES CARD(CNO),
FOREIGN KEY(BNO) REFERENCES BOOKS(BNO));