I am building my house and my husband and I are doing everything ourselves. I need some kitchen design help! My plan in the kitchen was to build a large island with four barstools on one side ( I have four children and want a place for them to do homework and hang out). I found a picture in a magazine that I like and my husband prefers but it is totally different. It has an L shaped island sith bench seating on the inside of the L with a small breakfast table. My dining room however; is pretty much attatched to the kitchen. Is there a rule about how close two tables can be to each other? I'm worried about having my dining room table to close to this breakfast table. How close should the breakfast nook and dining room be to each other?

Yes, there are rules about how close tables should be to each other. The National Kitchen & Bath Association provides very useful guidelines that will keep you all from bumping into each other.

Our shortened version is here:
NKBA Guidelines

Here are the main points for you to read, however:

8. Traffic Clearance at Seating: In a seating area where no traffic passes behind a seated diner, allow 32 inches of clearance from the counter/table edge to any wall or other obstruction behind the seating area. If traffic passes behind the seated diner, allow at least 36 inches to edge past or at least 44 inches to walk past.

9. Seating Clearance: Kitchen seating areas should incorporate at least the following clearances: At 30-inch-high tables/counters, allow a 24-inch-wide by 18-inch-deep knee space for each seated diner. At 36-inch-high counters, allow a 24-inch-wide by 15-inch-deep knee space. At 42-inch-high counters, allow a 24-inch-wide by 12-inch-deep knee space.

I would urge you to work with a designer to develop a plan that maximizes your space and function. It will be well worth the money to pay a designer to create a plan, even if you want to purchase/install everything yourself. There are so many details that need to be brought up and discussed that you may never even think of. Spend a little - you could save $1000s in mistakes!