in reply to (OT) Database design question

ablmf,

This is not really a Perl question. You could have given us some more information to help us to help you. Which database platform are you using? Your diagrams are little to work with. Perhaps you could describe your environment, and what exactly you are trying to achieve. I suspect you want to look into Replication (MySQL replication, MS SQL Server Replication for example). Please read the PerlMonks FAQ and How do I post a question effectively? if you have not already done so.

Martin