In the previous section I briefly described the high-level design of the data structures that I'm going to use in the monitoring system. In this section I'm going to create the database layout and relationships between different database tables. Finally, this information will be mapped to the SQL statements that will be used to initialize the database.
The modeling tool I've used to create the diagrams and data model is MySQL Workbench, which is an open-source application you can download from http: //wb. mysql. com. MySQL Workbench is a powerful database and entity relationship (ER) visual design tool. You can create new visual designs and generate SQL scripts from the design.
Was this article helpful?