Merise modeling: from MCD to SQL
- MCD: add entities (E) and associations (A), link them (L) and set cardinalities in the inspector; give each attribute an SQL type.
- The Checks panel flags modeling errors (missing identifier, redundancy, cardinality…).
- MLD: the relational model is derived automatically.
- SQL: choose the DBMS (PostgreSQL, MySQL, SQLite, SQL Server, Oracle) and download the full script, or only the changes since the last export.
Can’t find the answer? Write to us