05/30/2012 at 9:17 am #5915
Anonymous
Participant
What I'd suggest is to have one Catalog per Database not one Catalog per Table or Business logic (ie department, unit, etc).
When you present the data try to have stored procedures that would display the data from multiple tables (using JOIN conditions) and when you updata the data you can update a single table or multiple tables if that is required by your design/logic.