alterdbexam3.sql

ssd7考试exam3,绝对有用~欢迎下载

CREATE TABLE FavoriteTitles
(
TitleID		char(20) NOT NULL,
CustomerID	char(64) NOT NULL,
PRIMARY KEY (TitleID, CustomerID),
FOREIGN KEY (TitleID) REFERENCES Booktitle(callnumber),
FOREIGN KEY (CustomerID) REFERENCES Customer (customerID)
);