You need to find out  about additional statuses and rules dictating how entities are joined together. for example, if a customer is deleted, what happens to any orders they have?

It doesn't matter, In our table we will just create an add, edit and delete function for each entity. 

You need to find out  about additional statuses and rules dictating how entities are joined together. for example, if an order is deleted, what happens if the products on that order?

You need to find out  about additional statuses and rules dictating how entities are joined together. for example, if product is deleted, what happens if that product is on an order?