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 there’s only a primary key, and FOREIGN KEY constraints exist on the

underlying tables, which of the following commands returns an error message?

a. UPDATE changeaddress

SET shipstreet = '958 ELM ROAD'

WHERE customer# = 1020;

b. INSERT INTO changeaddress

VALUES (9999, 'LAST', 'FIRST', 9999,

'123 HERE AVE', 'MYTOWN', 'AA' 99999);

c. DELETE FROM changeaddress

    WHERE customer# = 1020;

d. All of the above

e. Only a and b

f. Only a and c

g. None of the above