Moon Modeler version 4.1 released! Let’s start with the new features:
In this version we have modified the options for connecting to the MongoDB database. We have updated the connection method so that connecting to e.g. MongoDB Atlas should be very easy and convenient.
To connect to the MongoDB database you may need to set up authentication.… Read the rest
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
Settings for MongoDB ER diagram graphics can be defined on two levels in Moon Modeler. On a project level and on a selected object level.
Click the MongoDB ER diagram area to make sure no object is selected. Then change the colors in section Graphics. Alternatively, edit Project properties and specify settings on tab Graphics of the modal form.… Read the rest
You can manually write SQL scripts in your favorite SQL editor and execute individual SQL commands directly on the connected database. However, another option is to use a data modeling tool in which you design the database structure visually, using an ER diagram.… Read the rest
Data modeling is the process of visually creating a graphical representation of a system or database. In the case of relational databases, we can mention the creation of entity-relational diagrams in which entities, attributes and relationships between entities are displayed. (Read more information about ER diagrams).
But what is the advantage of data modeling when we talk about noSQL databases?… 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:
Moon Modeler is available in two editions, Basic and Professional.
| Moon Modeler Features | Basic | Professional |
|---|---|---|
| Supported platforms | ||
| MongoDB |  | |
| Mongoose | | |
| PostgreSQL | | |
| MariaDB | | |
| MySQL | | |
| SQLite | | |
| GraphQL | | |
| Data modeling | ||
| ER diagrams and visual schema design | | |
| Support for platform specific objects | | |
| Visualization of nested/embedded objects | | |
| Automatic creation of foreign keys | | |
| Default values for a project | | |
| Custom data types for a project | | |
| User interface | ||
| Dark and light theme | | |
| Custom colors for items on ER diagrams | | |
| Undo | | |
| Find an object | | |
| Objects filtering | | |
| Automatic object resizing | | |
| Multiple objects alignment and resizing | | |
| Multiple line modes | | |
| Multiple display modes | | |
| Optional display of embedded objects on diagram | | |
| Optional display of database/schema name | | |
| Autolayouts | | |
| Zoom | | |
| Subdiagrams | ||
| Subdiagrams for objects in a subject area | – | |
| Subdiagram creation for schema/database | – | |
| Code generating | ||
| Generating project script | | |
| Generating subdiagram script | – | |
| Settings for output formatting (relational databases) | | |
| Order items (relational databases) | | |
| Reporting | ||
| Export to PDF | | |
| Export subdiagram to PDF | – | |
| Interactive HTML reports | – | |
| Multiple styles for HTML reports | – | |
| Visualization of existing structures | ||
| Basic database connections & reverse engineering | | |
| Secure SSH connection & reverse engineering | – | |
| Secure SSL/TLS connection & reverse engineering | – | |
| Import from SQLite files | | |
| Import from GraphQL files | | |
| Pricing | ||
| List price | 99 USD | 149 USD |
One to many relationship is a type of cardinality that refers to a relationship between two entities in an entity relational diagram (between two tables in a database). A simple example would be a binding between the entities person and birth_certificate. Each person must have their own birth certificate.
Graphically, the one to one relationship is shown as follows:
How it works in version 4.2:
Every time you create a new relationship between tables, a one-to-many relationship is created.… Read the rest
Many-to-many relationship is a type of cardinality that refers to a relationship between two entities in an entity relational diagram (between two tables in a database). A simple example would be a relationship between the entities student and course. Each student can have multiple courses and each course is for multiple students.… Read the rest
One to many relationship is a type of cardinality that refers to a relationship between two entities in an entity relational diagram (between two tables in a database). A simple example would be a binding between the entities order and item. Each order may have multiple items, but a product (e.g.,… Read the rest