I was in a group meeting for a project and my group members were talking about minimizing the number of tables and having two big
tables and one or two small tables connected to the main big ones. The question is : What is better to have less tables(putting most of the data in only two big tables which makes the search difficult ) OR to have a few more tables to help make the search easier( in my opinion) ? I could not find something wrong with having many tables in a DB. But, some of you may have sligtly different opinoins on this.
I would love to hear from you guys.