建borrow表.sql

1.写出建立BORROW表的SQL语句

CREATE TABLE BORROW
  (CNO CHAR(8) NOT NULL,
   BNO CHAR(8)NOT NULL,
   
 RDATE DATETIME,
   PRIMARY KEY(CNO,BNO),
   FOREIGN KEY(CNO)REFERENCES CARD(CNO),
   FOREIGN KEY(BNO)REFERENCES BOOKS(BNO))