Our house has 2 dining areas. One is small breakfast nook and the other is a medium size formal dining area. Neither is big enough for a large dining table. When all our kids are home, we need seating for at least 9, and sometimes more.
I would prefer to have one big table but what works for us it is bring the breakfast room table in and set it beside the table in the formal dining room. You can't tell it from the picture but the small table is almost in the front foyer.
It is not perfect but we all can sit together and it works good enough.