Read articles about ERD creation in Moon Modeler. Tips and tricks, articles about how to create ER diagrams for various databases.
Use crows foot notation to represent relationships between entities in an entity relational diagram. Entities are connected by lines, and symbols at the beginning or end of the line describe cardinality.
Relationship types and cardinality:
A crow’s foot graphics represents “many” or “infinite”.… Read the rest
Entity relationship diagram describes the structure of the database. The entity relationship diagram shows entities (tables in relational databases) and relationships between tables that exist in the database. For a good database design, it is very important to have an entity relationship diagram.
In an entity relationship diagram, the basic elements are:
Looking for a free ER diagram tool? There are many on the market and Moon Modeler is one of them.
This free ER diagram tool can be used to visually define smaller database structures for relational database systems such as MariaDB, MySQL, PostgreSQL, SQLite, and NoSQL databases such as MongoDB, or object-document mappers such as Mongoose.… Read the rest
Connection to SQLite database is not classic, so you will not find the option of this database in the connections section. To visualize an existing SQLite database structure, go to the Projects section and import SQLite from a file.
Select the database file. In this example, we will load the chinook.db… Read the rest
Quick start guide for SQLite database design in Moon Modeler.
To create a new project, click New on the toolbar and select the MariaDB project type.
New database tables can be inserted into projects by clicking Table on the toolbar and then by clicking the main diagram area.… Read the rest
All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MySQL and enter the connection details.
When you are finished, click the Save Connection button.
Your new MySQL connection will appear in the list of all database connections.… Read the rest
To generate SQL script from your project click the Script icon on the main toolbar. New modal opens. Click Save Scripts and select a location where the files should be stored.
Option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.
#
To define or edit table keys, edit your table and navigate to tab Keys or change values directly in the right-side panel in section Keys.
A primary key exists in every table. If you wish to add a new alternate key, click the button + Add Key.… Read the rest
In Moon Modeler you can easily draw MySQL structures.
Database tables are displayed as graphical boxes with all column fields.
One of the main advantages of Moon Modeler is the possibility to visually display nested structures.
The structures are displayed inside tables and also as separate graphical objects.… Read the rest
To create a new relation between two tables, click Relation on the toolbar and then click parent and child tables in your diagram.
In this example, click table customer and then table order.
The new relation line appears in the diagram and column customer_id is added to the child table order automatically.… Read the rest