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

Reverse-engineering a database into a model

In the previous sections, we learnt how to design data models from scratch. Now that you're acquainted with the data modeling tools and diagram structures, we can move onto generating a model from an existing database.

For this part I have chosen the Sakila example database, which I introduced in Chapter 3, Data Management with Navicat. If you already followed the tutorials in the previous chapter, you must have a working copy of the sakila database available to be reverse-engineered into a data model. If not, now is a good time to take a look into it and at least follow the steps to get the sakila database imported into your MySQL server.

Go to Navicat's main window and locate the sakila database in the ...

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