EER Diagram in MySQL
EER(Enhanced entity-relationship) diagrams are basically a more expansive version of ER diagrams. EER models are helpful tools for designing databases with high level models, with their enhanced features. you can plan databases more thoroughly by delving into the properties & constraints with greater precision.
It is to establish structured metadata commonality for the master data entities between the set of logical ER models.
After creating database script, import data into MySQL workbench using new schema. To create EER diagram, we need to follow these steps. select Database -Reverse Engineer (ctrl+R)- Hostname password- select schema- select objects to Reverse engineer- Execute. It will show EER diagram with our tables and their relationships automatically.
Here relationship created using primary & Foreign keys in the tables. Relations can be one - to- one or many - to- one or one - to - many.
My EER diagram is created with telco fictional company dataset contains 7k customers & 33 attributes. I created 7 tables from 33 columns along with 4 new columns for primary keys. With help of primary key & Foreign keys relationships are formed in EER diagram.
GitHub link to view as MySQL file
To follow in LinkedIn
To follow in GitHub