​Structure of the ORDERITEMS Table

Multiple Choice

​Structure of the ORDERITEMS table

-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 orderitems
ADD FOREIGN KEY isbn REFERENCES BOOKS TABLE (isbn) ;
B) ALTER TABLE orderitems
MODIFY FOREIGN KEY (isbn) REFERENCES books(isbn) ;
C) ALTER TABLE orderitems
CREATE FOREIGN KEY (isbn) REFERENCES books(isbn) ;
D) ​ALTER TABLE orderitems
ADD FOREIGN KEY (isbn) REFERENCES books(isbn) ;