New table vs new database
I wonder when to create a separate table in the same database, and when to create a new database. I'm not clear about the significance of the difference between those two entities.
Let's say I have records of places and times. One can be at any one place many different times. Places and times (schedules) are inserted, updated and deleted in different activities, but one activity combines places with times. Should I make two databases, or two tables in the same database? Can they be linked relationally even if they are in two different databases (files)?
And should one create a new DBAdapter class for each table?
|