I always strive for simplicity. To that end, we have ONE app. At last count, it has about 75 tables. Not everything in it is needed by anyone in our company (75 employees), but every table is connected to at least one other table, and since our clients are at the center of everything we do, the Client table is the hub of the system. I can control which tables can be viewed/modified by each role (we have about 20 roles). I can control which tables appear as a tab for each role. And I can set different dashboards by role. Frankly, I don't understand why anyone would want to do it any other way than having one app.
