My team( all freshers) are developing a project that will involve many Modules.
I want to know if it is a good practice to have different databases for a single project!!! I know that this could lead to a bad design, if you make the wrong decisions of placing the respective tables.
Each database of a module will contain only the module specific tables (that do not need communication to the other tables of other modules), commonly used tables will be placed in a common database.
I want to know the demerits of such a design, cause junking up a database with a lot of tables, seems to be a very complicated system to understand, I mean the documentation part.
Can we relate tables in different databases????