This makes sense. But I imagine it that it will be complicated provided that one table has a lot of other dependent tables associated with it. Am I right to assume this?

Perhaps if I had foreseen this, I would have made my database schema easier to archive. :-(