creating_ER_diagram_guide.md

Creating ER Diagram of SQLite database using MySQL Workbench - Tutorial

1. Softwares Required

DB Browser for SQLite - can be downloaded from sqlitebrowser.
I am using :
(DB Browser for SQLite Version 3.12.2
Built for x86_64-little_endian-llp64, running on x86_64
Qt Version 5.12.8
SQLite Version 3.35.5)

MySQL Workbench - can be downloaded from MySQL Installer.
I am using: MySQL Workbench Version 8.0.33

2. Creating .sql file of database in DB Browser for SQLite

Open the database .sqlite file using DB Browser.
Once opened go to File -> Export -> Database to SQL file

In the new window popup, select all the tables. Select Export schema only and Overwrite old schema under options and click save.

Then select the folder where you want to save the .sql file of the database which should be followed by notification of 'Export Completed'.

3. Creating ER Diagram in MySQL Worbench

Open MySQL Workbench.
Go to File -> New Model

The MySQL Model tab can be seen on left top corner of the screen as follows after the model creation.

Go to File -> Import -> Reverse Engineer MySQL Create Script..

Browse the .sql file generated by DB Browser for SQLite. Tick mark the Place imported objects on a diagram and Use ANSI quotes. Click on Execute.

Click next after the import is finished. Click finish after that.
Now you will see the ER diagram. Move the tables according to your liking and maximum readability.

If you want to export the image, go to File -> Export -> Export as PNG.