Question

I am supposed to do the following problem: Alter the s_ord table to add a foreign key, CUSTOMER_ID, to the CUSTOMERID of the s_customer table. In addition, make sure ORD_ID of the s_item table is a foreign key to the ORDERID of the s_ord table. You need to use “ON DELETE CASCADE.”

Solution i came up with is below would like someone to check and see if this is right

ALTER Table s_ord
ADD (CONSTRAINT fk_ordA FOREIGN KEY (Customer_ID)
REFERENCES S_customer(CustomerID),
CONSTRAINT fk_ordb FOREIGN KEY(ORDERID) REFERENCES s_item(ORD_ID) ON DELETE CASCADE

Answer 1

What in the world is "Oracle" besides the name of a major software company??

Please type your <u>subject</u> in the <b>School Subject</b> box. Any other words, including obscure abbreviations, are likely to delay responses from a teacher who knows that subject well.

Answer 2

Actually, Oracle is also the name of their flagship database and software applications.