Summary
In this chapter, you learned how to work with the Workbench GUI to create a complete database with tables and columns, import new tables from an SQL file, create indexes and foreign keys, and create an EER model and diagram by reverse engineering the database. The ability to reverse engineer a database to create the model will make working with existing databases easier. Following this, you learned how to modify the EER diagram and forward engineer the changes to the model. Additionally, you explored how to synchronize the model with the production database.
In the next chapter, you will be using SQL statements to work with the database. You will learn how to back up and restore the database using MySQL Workbench and perform different operations using SQL statements.
