It is very difficult to say whether to prefer one large table or multiple small tables. It depends −
However, there are many key points, through which we can say that multiple small tables are good in that situation.
Suppose many developers are going to develop multiple tables, then there is a need to split them into multiple small tables.
A situation when you are giving authority to many developers. This authority is for different parts of data. In this case, a need arise to split into multiple small tables arise.
Suppose, we are moving data from different places then there is a need for multiple small tables.