O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

We started the chapter by getting you acquainted with the visual data modeler of Navicat, the metaphors it introduces, and how to design tables, fields, constraints, and relationships between these objects. These are both visual and form-based tools, which resemble other tools of Navicat covered in the previous chapters.

Using these tools, you learned how to design a database model from scratch and then actually generated that database from the model.

Finally, we reverse-engineered a larger, existing database and automatically generated its visual model with a one-click wizard, and you have learned how you can synchronize your changes back to the database as you progress on the model.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required