Skip to content

Latest commit

 

History

History
36 lines (21 loc) · 1013 Bytes

README.md

File metadata and controls

36 lines (21 loc) · 1013 Bytes
Raw

ER-modelling

This is going to be a collection of ER-model examples. The focus will be on simplicity and completeness.

Some of the models will be done in English and some in Slovene.

Project files

  • README.md

    Project report with the image of the model and the explanation of the tables and attributes.

  • inserts.sql

    Sql INSERT statements that fill the tables with sample test data. You can always generate the model from mysql-model.mwb file via Forward Engineering.

  • queries.sql

    Some of the non-trivial queries that help you extract information from the model.

  • mysql-model.mwb

    The MySQL WorkBench model file.

  • mysql-model.svg

    The image of the model.

Naming conventions

Entity and table names shall be written in PascalCase, attribute and column names shall be written in snake_case