Skip to content

Exercise: Creating a database for reverse engineering

Installing the database (running a sql script)

Basic procedure:

  • find a sql script containing CREATE (and INSERT INTO) commands
  • run it in your (test) environment

Example: https://dev.mysql.com/doc/sakila/en/

=> create a database to your MySQL environment

Reverse engineering a database

In order to create an ER diagram from a database, use an appropriate tool (e.g. MySQL Workbench) for that

Example: https://dataedo.com/kb/tools/mysql-workbench/how-to-reverse-engineer-database