Heroku Postgres and ER diagrams

How to create ER diagram of PostgreSQL database running in Heroku? With Moon Modeler, the process is simple. Just create a database connection, retrieve the information from Heroku Postgres and create a project containing the ER diagram. But let’s start one step at a time.

What is Heroku and Heroku Postgres?

Read the rest
GraphQL schema - starwars

How to make a diagram of your GraphQL schema

Several tools can be used to visualize existing GraphQL schemas. Some of them allow you to browse the structure in the form of a hierarchical tree. Moon Modeler, on the other hand, offers the ability to visually model new GraphQL schemas and also automatically create diagrams from existing sources.

GraphQL data modeling

Before we show how to make a diagram of your GraphQL schema, let’s take a look at how to easily create a brand new GraphQL schema diagram.… Read the rest

Import GraphQL from URL

Importing a GraphQL schema from URL

In Moon Modeler you can

  • model new GraphQL schema diagrams,
  • import an existing schema defined in JSON format,
  • and also import GraphQL schema from online sources.

In this section, you will learn how to import a GraphQL schema from an online source and how to modify the visualization. The StarLink schema, available at https://api.spacex.land/graphql/Read the rest

Crow’s foot notation in ER diagram

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:

Symbols in crow’s foot notation

A crow’s foot graphics represents “many” or “infinite”.… Read the rest

NoSQL data modeling

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).

Advantages of data modeling

  • Fewer design and development errors
  • Easy and fast design, especially in the early stages of development
  • Better communication between team members
  • Time saving
  • Lower development costs
  • and many others

MongoDB schema design and noSQL database modeling

But what is the advantage of data modeling when we talk about noSQL databases?… Read the rest

What is Entity Relationship Diagram (ERD)?

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:

  • Entities (tables)
  • Attributes (table columns)
  • Relationships (relationships between tables)

Why create entity relational diagrams?

Read the rest

One-to-one relationships

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:

one-to-one relationship

One-to-one relationships in Moon Modeler

Every time you create a new relationship between tables, a one-to-many relationship is created.… Read the rest

Quick links

Free Trial Buy Now!

Blog categories