Rex,

The applications I've seen and worked with (not developped by me), use a single database for all tables but if it's multicompany, they use a separate database for each company. Sometime they have a separate database for common tables like companies info, user info and access security info.

EX:

GlobalDatabase

CieABCDatabase
CieXYZDatabase
CieDemoDatabase
etc.

This setup make it easy to copy information from a live database to a demo database or for you to have multiple database if you have more then one customer using your apps.

HTH