An Entity-Relationship model (ER) or Enhanced Entity-Relationship model (EER) is well suited to design a database structure.
An ER-model consists of a schema that shows the entities, relationships and attributes.
With this tool you can make a connection with a MySQL database.
When you finish your schema you can use MySQL Workbench to generate a database and its tables in MySQL.
Use the menu Database - Forward Engineer.