Based on the structure of the ORDERITEMS table, which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?
a. ALTER TABLE orderitemsADD FOREIGN KEY isbn REFERENCES BOOKS TABLE (isbn);
b. ALTER TABLE orderitemsMODIFY FOREIGN KEY (isbn) REFERENCES books(isbn);
c. ALTER TABLE orderitemsCREATE FOREIGN KEY (isbn) REFERENCES books(isbn);
d. ALTER TABLE orderitemsADD FOREIGN KEY (isbn) REFERENCES books(isbn);
d
You might also like to view...
Corporate bonds are less risky if they are ________ bonds and municipal bonds are less risky if they are ________ bonds
A) secured; revenue B) secured; general obligation C) unsecured; revenue D) unsecured; general obligation
A state college receives an annuity gift of $200,000 from an individual. The individual is to receive $18,000 a year for 10 years. The present value of the payments to the individual is $150,000
How much revenues should the college report from this transaction? A. $0. B. $20,000. C. $50,000. D. $200,000.