- First you need to identify the joins available between the tables in the data model
- Check can the application leave without any one of them; if yes then remove it; if not then you can go ahead and create alias table using resident load e.g. create separate Demand table for Inventory and PO (make sure to rename to fields to avoid synthetic keys)
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.