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;

If a record is deleted from the CHANGEADDRESS view based on the Customer# column, the customer information is then deleted from which underlying table?

a. CUSTOMERS

b. ORDERS

c. CUSTOMERS and ORDERS

d. Neither—the DELETE command can’t be used on the CHANGEADDRESS view.