Here it is. I have 8 people (including myself) working on creating a new database. The tables and data (all fictional as it is just a project) will follow a real-world application of the flow of a computer business. 4 people will be creating the data while 4 others will be building the tables.

That's the background info. The question is, what is the best way to piece each person's part together to get the completed project?

The data will be put in a text file and I will use LOAD DATA INFILE to populate the tables, but I'm not sure on how I can get the tables (which will be built on different computers) together into one database.

Does that make sense?