Vertabelo
  • Features
  • Pricing
  • Academy
  • Learn SQL
  • Log in
  • Sign up
MENU CLOSE
  • Home
  • Features
  • Pricing
  • Academy
  • Learn SQL
  • Log in
  • Sign up
  • All Articles
  • Design Fundamentals
  • Design Patterns
  • Example ER Diagrams
  • Database Internals
  • Others
Technical

What Are the Symbols Used in an ER Diagram?

by Katarzyna Piskała
14 Jan 2021 Find out what symbols are used in the Entity-Relationship Diagram (ERD) and what they mean. The most popular notation in ER diagrams is the Information Engineering (IE) notation, also called crow’s foot notation. This is the default ER diagram notation used in Vertabelo. There are a few standard symbols used in logical and physical ER diagrams, and some useful additional non-standard symbols that you can use in Vertabelo. We’ll discuss them in this article.
Read more
Technical

How to Generate a Physical Diagram from a Logical Diagram in Vertabelo

by Vertabelo Team
12 Jan 2021 Have you finished preparing your logical data model in Vertabelo? Awesome! In this article, we'll show you how to generate the physical data model from the logical model in Vertabelo. It’s just a few clicks away. Ready? Let's dive into it. Quick Intro In this article, we'll deal with a slightly modified version of Microsoft's Northwind Database. We often use it in our LearnSQL courses, such as Customer Behavior Analysis in SQL.
Read more
Technical

What Is a One-to-Many Relationship in a Database? An Explanation with Examples

by Lisandro Fernigrini
7 Jan 2021 One-to-many relationships are one of the most common database relationships. If you want to learn when and how to use one-to-many relationships, then this article is a great starting point. You will surely use one-to-many relationships to store information in any relational database, whether you are designing enterprise-level software or just creating a simple database to keep track of your uncle’s stamp collection. A Brief Introduction to the Relational Model Relational databases are a core component of any modern transactional application.
Read more
Technical

Top 7 Entity Relationship (ER) Diagram Online Tools

by Shamal Jayawardhana
5 Jan 2021 Are you searching for the best online ER diagram tool? Read on and discover our top picks. Data modeling is one of the most critical parts of a software project. Database architects use ER diagrams (also called ERDs or Entity Relationship Diagrams) as a data modeling technique. Many ER diagram tools are available, but choosing the best tool for your project can be hard. Still, your data model is a key factor in the success of your entire project; it’s important to get it right.
Read more
Technical

2020 Was Vertabelo Database Modeler’s Year. It’ll Get Even Better in 2021.

by Jarosław Błąd
29 Dec 2020 2020 is coming to an end. It's been a busy year for us, so let's summarize what we did at Vertabelo. I will also show you how the Vertabelo database modeler will evolve in 2021. This is already a great tool, but it will be even better. See what we plan to do. I am not exaggerating when I say that we had our hands full in 2020. In addition to constantly improving the Vertabelo database modeler and creating new Vertabelo Academy courses, we have launched completely new platforms for learning SQL and Python.
Read more
Technical

How to Implement a Conceptual, Logical, and Physical Data Model in Vertabelo

by Tihomir Babic
24 Dec 2020 This article will lead you through the differences between the conceptual, logical, and physical data models. It will also show you how to create each one.  What are conceptual, logical, and physical data models? What do they do, and what are the differences between them? That’s what I’ll answer in this article. It won’t be only theory; I’ll also show you how to create different data models using Vertabelo.
Read more
Technical

How to Draw an ER Diagram Online

by Zahin Rahman
22 Dec 2020 In this article, I will be listing some of the top tools for drawing ER diagrams online. Priority will be given to ease of use, user experience, and functionality. An entity relationship diagram, or ER Diagram (ERD), is a visual model of your database schema. It describes the database structure and helps conceptualize how pieces of data interact with one another across a robust database. To some extent, ER diagrams look like flowcharts; they show the database tables as rectangles, with connecting lines representing the relationships between tables through primary and foreign keys.
Read more
Technical

What is Amazon Redshift?

by Vertabelo Team
17 Dec 2020 Amazon Redshift is one of the most popular cloud databases. Could it be your data-warehouse solution? Read on to find out if Amazon Redshift meets your needs. In 2012, Amazon announced its new cloud database system called Redshift. Basically, it is a data-warehouse solution intended for analytical systems, which can handle huge volumes of data—up to 1 petabyte (1024 TB). Amazon Redshift is available as a service (Database as a Service) and is a part of a bigger cloud ecosystem called Amazon Web Services (AWS).
Read more
Technical

Explaining an ER Diagram, With Steps and Use Cases

by Sudip Sengupta
15 Dec 2020 Get to know what an ER Diagram is through use cases and examples. Explore the notations for the essential components of an ERD. Entity-relationship diagrams (ERDs) are used to visualize data and relationships among the entities of a system. At its core, an ER Diagram explains the logical structure and the flow of information within a data model. To do so, an entity-relationship diagram highlights entities, attributes, and relationships through predefined symbols for effective visualization of the architecture.
Read more
Technical

What Are the Steps in Database Design?

by Kovid Rathee
10 Dec 2020 Database design is one of the most important factors contributing to the performance of an application. Consequently, how well the database is designed is of utmost importance. Database design is all about efficiently organizing data based on product workflows, future roadmap, and expected usage patterns. The output of a database design exercise is a data model. A data model represents all the objects, entities, attributes, relationships, and constraints in the system.
Read more
  • ««
  • «
  • 1
  • 2
  • 3
  • »
  • »»

Site Footer

Quick links

Vertabelo Blog
Documentation
FAQ
Features
Pricing
Academy

Support

If you have any questions or you need our help, you can contact us through our
Support site

Follow Us

Copyright ©2013-2018 Vertabelo SA All rights reserved
Terms of Service Privacy Policy Imprint Investor relations