Vertabelo Database Modeler

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

1
2
3