<aside> 💡 ok so these videos and guide I put together here walked me through step by step in making DBMS

</aside>

STEPS

1. ER

   1. Id entities required
   2. Attributes & primary key for each entity
   3. relationships needed
   4. cardinality & participation constraints

2. ERD (I recomend lucidchart for this)

3. Normalization (after this step, replicate or export the diagram to MySQL Workbench)

   Entity Relationship Diagrams (ERDs)

4. FORWARD ENGINEER button!

(the terms entity and table are used interchangeably)

<aside> 💡 I made my best to put them in a proper order

</aside>

• INFORMATIONAL vids

ER

Steps to draw ER DIAGRAM in Database management system

<aside> 💡 for cardinality the inner line (for 1) or circle (for 0) indicates the minimum required elment for this relationship to exist and the outer (One or Many) indicates the maximum. When refering to the many-to-many or 1-to-M we are generally refering to both of the outermost ends of this relationship's cardinality

</aside>

ERD

Example 1: Transforming ER Diagrams to a Relational Schema

How to convert an ER diagram to the Relational Data Model