Relational modelling and forward engineeringVerified code
Coworking database with MySQL
Schema for managing coworking entities and relationships through relational design.
- Challenge:
- Translate coworking-management requirements into consistent tables, keys and relationships before application implementation.
- Solution:
- Entity-relationship diagram, physical model and scripts generated through forward engineering.
- Technical role:
- Normalization, ER design, key definition and physical-schema generation.
- Value:
- The repository preserves models, relationships, foreign keys and SQL for tracing logical design into a physical schema.
- What you can inspect:
- Public description and MySQL Workbench artefacts with SQL, tables, foreign keys and relational models.
MySQL WorkbenchSQLPL/SQLER modellingForward engineering
Database design
In practice: Relational modelling and normalization with MySQL Workbench, from the entity-relationship diagram to the physical schema generated through forward engineering.