This question is based on successful execution of the following statement:

CREATE VIEW changeaddress

AS SELECT customer#, lastname, firstname, order#,

shipstreet, shipcity, shipstate, shipzip

FROM customers JOIN orders USING (customer#)

WHERE shipdate IS NULL

WITH CHECK OPTION;

Assuming one of the orders has shipped, which of the following is true?

a. The CHANGEADDRESS view can’t be used to update an order’s ship date because of the WITH CHECK OPTION constraint.

b. The CHANGEADDRESS view can’t be used to update an order’s ship date because the Shipdate column isn’t included in the view.

c. The CHANGEADDRESS view can’t be used to update an order’s ship date because the ORDERS table is not the key-preserved table.

d. The CHANGEADDRESS view can’t be used to update an order’s ship date because the UPDATE command can’t be used on data in the view.