One-to-many 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 order and item. Each order may have multiple items, but a product (e.g., a TV) may be delivered within a single order.

Graphically, a one-to-many relationship is usually represented in a logical model with crow’s foot notation on one side of the relationship.

One-to-many relationship

One-to-many relationships in Luna Modeler

Each time you create a new relationship between database tables, a one to many relationship is created.

How to create a new one to many relationship

  • Add two tables to the ER diagram: order and item.
  • Then create a new relationship. On the toolbar, click the Relationship button and first click the order table and then the item table.

Alternate solution – JSON

However, there are more options that may be suitable for similar cases. JSON data types can also be used.

SQL Script and JSON data type

Types of relationships in ER diagrams

Get started today and try Luna Modeler – ER diagram tool!

Download Read Quick Start Guides

DATA MODELING TOOLS
DRAW Diagrams and
GENERATE Scripts
Download data modeling tools
Blog Categories
Blog by Platforms