alter_tables3.sql

ssd7 ex3 答案

  ALTER TABLE book4 ADD FOREIGN KEY (borrowerid) REFERENCES member4(libid);
  ALTER TABLE book4 ADD FOREIGN KEY (callnumber) REFERENCES title4(callnumber);
  ALTER TABLE read_by4 ADD FOREIGN KEY (callnumber) REFERENCES title4(callnumber);
  ALTER TABLE read_by4 ADD FOREIGN KEY (libid) REFERENCES member4 (libid);
  ALTER TABLE ordered4 ADD FOREIGN KEY (callnumber) REFERENCES title4(callnumber);
  ALTER TABLE ordered4 ADD FOREIGN KEY (ponum) REFERENCES purchase_order4(ponum);
  ALTER TABLE ordered4 ADD FOREIGN KEY (supplier_id) REFERENCES supplier4(supplier_id);