Asked by vsu
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
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
Answers
Answered by
Writeacher
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.
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.
Answered by
Leo
Actually, Oracle is also the name of their flagship database and software applications.
There are no AI answers yet. The ability to request AI answers is coming soon!