What in the world is "Oracle" besides the name of a major software company??
Please type your subject in the School Subject box. Any other words, including obscure abbreviations, are likely to delay responses from a teacher who knows that subject well.
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
2 answers
Actually, Oracle is also the name of their flagship database and software applications.