Data Modeling - Articles

Learn how to seamlessly connect to Supabase and visualize your database using Luna Modeler. Simplify your data workflow with our easy guide!

Learn how to use Luna Modeler to automatically infer dependencies between views, stored procedures, and tables for better impact analysis.

The best visual database design tool for consultants. Supports Oracle, PostgreSQL, SQL Server, MySQL and more.

Looking for a SAP PowerDesigner replacement for SQL modeling? Luna Modeler offers modern data modeling and cross-platform support.

Luna Modeler is an excellent alternative to Vertabelo. Simplify your database modeling with a user-friendly offline application.

Looking for a lightweight alternative to erwin Data Modeler? Luna Modeler is a modern, cross-platform database design tool.

Looking for an affordable alternative to ER/Studio? Discover Luna Modeler for intuitive data modeling for multiple database systems.

Explore the top 5 data modeling software options that empower software development, database design, analytics, and business processes.

What's the difference between primary keys and unique keys? Learn how to define a unique key, how to use the key for relationships and more.

Luna Modeler for Oracle database design. See how to visually create ER diagrams for Oracle Database and generate SQL Scripts.

Learn about data models and their key types - conceptual, logical, and physical. Discover powerful tools for the easy creation of data models.

Find the best data flow diagram tools for easy modeling and exporting. Create effective diagrams with the right software.

Discover the best FREE desktop flowchart diagram tools that run 100% offline - no SaaS, no cloud, no subscriptions.

All products in our portfolio allow you to use templates to generate your own scripts, html code, CSV files, javascript code snippets etc.

Discover how to build a professional flowchart diagram with Merit Modeler. Freeware, easy to use, and available for major operating systems

Discover how a data flow diagram can simplify your approach to software engineering and how to use the FREE Model Merit for drawing DFD

Find out how a use case diagram helps identify actor goals and interactions and how to draw use case diagrams in the Merit Modeler freeware.

Learn how to set default values for columns to your SQL Server database design. Explore Luna Modeler database design tool.

Discover the importance of ER diagrams when documenting databases. This article describes various aspects of database documentation.

Learn how to show collections in MongoDB. Use a command-line tool or create a diagram in Moon Modeler - data modeling tool for MongoDB.

Discover how to generate delta scripts for database changes with our easy-to-follow guide. Enhance your database management skills today!

Discover how to effectively compare SQL database schemas using Luna Modeler. Our guide offers step-by-step instructions.

Luna Modeler - a SQL database creator that allows you to generate SQL scripts for many databases. Draw diagrams and create SQL scripts.

Learn how to make a diagram of GraphQL schema, how to edit the diagram and create a PDF or interactive HTML report.

NoSQL data modeling and MongoDB schema design. Draw diagrams, describe database structures and improve productivity with Moon Modeler.

Many to many relationships in entity relationship diagrams explained. Draw ER diagrams and design database structures easily.

One to many relationships explained. Draw entity relationship diagrams, define entities, attributes and relationships easily in Luna Modeler.

Learn how to set up Postgres in Docker Desktop, connect it to Luna Modeler for visual schema design, and manage your database using pgAdmin.

Learn how to set up MySQL in Docker Desktop, create a data model in Luna Modeler and run generated SQL scripts using VS Code.

Discover the easiest way on how to setup MongoDB with Docker Desktop and manage your data models visually with Moon Modeler.

Explore the data model sport tournaments with a structured PostgreSQL approach for managing teams and matches effectively.

Learn the essentials of hierarchy modeling for NoSQL databases and enhance your data structures effectively.

Learn how to connect to Amazon DocumentDB using Moon Modeler and create a diagram of your database effortlessly.

Database modeling is an essential step in the database design process. Read more information and tips for using database modelling tools.

Creating ER diagrams is very easy in Luna Modeler. Learn how to create a connection to an Azure SQL Server database and how to create ERD.

Learn how to list databases and show tables in PostgreSQL. Use a command-line tool or create an ER diagram in Luna Modeler.

Learn how to connect to Heroku Postgres and how to create ER diagrams easily. Try Luna Modeler - database modeling tool.

Our data modeling tools are customizable. Add your own custom properties and turn the tool into RAD - rapid application development tool.

One to one relationships explained. Draw entity relationship diagrams with entities, attributes, relationships and describe your databases.

Use Ideamerit Designer - a software application for visual definition of OKRs, mindmaps and decision trees for your data modeling goals.

Learn how to use the CREATE TABLE statement in PostgreSQL database to create a new table and how to generate DDL scripts using Luna Modeler.

Learn how to create a connection to an SQL Server Express database and how to create ERD from existing database structure using Luna Modeler

Picking the right noSQL data modeling tool for noSQL databases can greatly influence the success of your project. Learn some tips and tricks.

Learn how database modeling for SQL Server database can help you manage data more effectively. Try Luna Modeler - a database modeling tool.

Learn the benefits of using multiple database systems for an e-commerce project and designing the structure in a data modeling tool.

Learn how to easily create an ER diagram for MongoDB in Moon Modeler - a database modeling and schema design tool.

Learn the top 5 benefits of database modeling tools and find out how Luna Modeler can increase your productivity and save you money.

Entity relationship diagram describes the database structure. Basic elements are entities, attributes and relationships. Read more.

Use crow's foot notation to represent relationships between entities in an entity-relational diagram. Draw ER diagrams in Luna Modeler.

Learn how to add an Identity column to your SQL Server database design in Luna Modeler database design tool.

Data modeling for Cosmos DB - Learn how to connect to Cosmos DB / MongoDB and how to create diagrams easily.

A list of ER diagram samples made with Luna Modeler - data modeling tool for anyone who needs to create effective ER diagrams.

Database design tool for macOS users. Read how to install Luna Modeler on macOS and explore the key features and benefits.

Learn how creating relationships in ER diagrams is essential for maintaining data integrity and improving data retrieval efficiency.

Try Luna Modeler - a database design tool for Linux. Read how to install Luna Modeler on Ubuntu and explore the key features and benefits.

See how to create MongoDB Atlas connection, connect to MongoDB Atlas and create data model or ER diagram from your existing MongoDB database.

Read about MongoDB vs PostgreSQL. Review differences in Luna Modeler and Moon Modeler - data modeling tools for various database platforms.

Learn how to convert a database schema from one database to another. Find out how to run the conversion successfully in Luna Modeler.

Learn what database entity is and how to design database entities with attributes and relationships in modeling tools.

Read how to set schema validation for fields in a project for MongoDB in Moon Modeler - a schema design tool for MongoDB and Mongoose.

Database normalization provides several benefits, including improved data integrity, better data consistency, reduced redundancy and more.

What's the difference between primary keys and foreign keys? Learn how to define a primary key, a foreign key, and how to visualize JSON.

Data modeling for Amazon DocumentDB - Learn how to connect to DocumentDB / MongoDB and how to create diagrams easily.