Let us suppose that an e-commerce company wants to expand its business worldwide. As such, the Datawarehouse team wants to store the purchase details country wise, keeping the purchase id continuous. That is, if there are 3 tables {PurchaseID_India, PurchaseID_UK, PurchaseID_Canada} and 5 purchases {2 in India, 1 in the…