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...
Which problem definition topic is most likely to require primary data collection?
a. to determine the percent of females living in Florida b. to determine a retailer's image based upon fashion leadership and pricing variables c. to determine the growth in the service economy in terms of employment d. to analyze the percent of adult females that work on a full-time basis
In echo checking, the receiver
a. repeats everything back to the transmitter for confirmation b. repeats only questionable data back to the transmitter for confirmation c. sends a checksum to the transmitter for confirmation and waits for it to be echoed back d. none of the above
If the parties to a sale under the UCC do not specify when the title to the goods passes, then, assuming goods have to be shipped, title passes to the buyer when:
a. the buyer delivers "payment in full" b. the seller requests payment c. the buyer inspects the goods d. the buyer makes "substantial" payment e. none of the other choices
A control that can ensure that receiving clerks are not influenced by quantity information while actually counting incoming goods is to:
A. send a "blind" copy of the purchase order to receiving B. establish a "tickler" file for completed purchase orders C. send copies of a receiving report to accounts payable D. establish "blanket orders" in purchasing