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