Cascading update and delete data?

Question

SQL

Suppose we have a Products table and an Orders table , which stores the details of the ordered product.
Obviously Orders.productId is a foreign key. How correct, from the point of view of the business process, is it to cascade the deletion of orders, following the products they refer to? From the point of view of information, information about completed orders is critically important, since the orders table accumulates almost all the basic information on the order. But what's the point of keeping it if the product has already been deleted, in terms of data integrity? Another contradiction arises.

Answer 1

How correct, from the point of view of the business process, is it to cascade the deletion of orders, following the products they refer to?

Completely wrong. The item just needs to be marked as unused.