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

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.

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

Your solution is almost correct, but there is a small mistake in the syntax. The foreign key constraint for the `Customer_ID` column in the `s_ord` table is missing the proper syntax for referencing the `CustomerID` column in the `s_customer` table.

Here's the corrected solution:

```
ALTER TABLE s_ord
ADD CONSTRAINT fk_ordA FOREIGN KEY (Customer_ID)
REFERENCES s_customer(CustomerID),
ADD CONSTRAINT fk_ordB FOREIGN KEY (ORD_ID)
REFERENCES s_item(ORDERID) ON DELETE CASCADE;
```

In this solution:
- The first `ADD CONSTRAINT` statement adds a foreign key constraint named `fk_ordA` on the `Customer_ID` column in the `s_ord` table. It references the `CustomerID` column in the `s_customer` table.
- The second `ADD CONSTRAINT` statement adds a foreign key constraint named `fk_ordB` on the `ORD_ID` column in the `s_ord` table. It references the `ORDERID` column in the `s_item` table, and also specifies `ON DELETE CASCADE` to automatically delete related rows in the `s_ord` table when a row is deleted in the `s_item` table.

Make sure to run this SQL query in your database to apply the alterations to the `s_ord` table.