I have attached a relationships diagram to help with this query I have.
I want to delete customers, however I know that if I simply do this all associated records will also be deleted.
I want the orders that these customers have made to remain within the database. So, when a customer is...