Re: Creating Database Structure

[Peter Brawley]

InnoDb, one db.

Re SQL you're looking at a steep learning curve, the equivalent of at least a college semester. Read about relational database use and design. Download MySQL 5.7 and work through the intro/tutorial chapters of the manual. Study existing databases that are somewhat like what you hope to implement, there's a trove of db models at http://www.databaseanswers.org/data_models/index_all_models.htm.

Re PHP, do you have a programming background, say in C or C++/ If so, PHP learning curve will be shallow. Lots on the web about PHO & MySQL.

Finally, when you're ready to start designing, follow a method, eg http://www.artfulsoftware.com/dbdesignbasics.html.