Author: Martyna Sławińska

Martyna is a software developer with a passion for programming, automation, and innovation. Currently working for the global corporate IT consulting sector, she is a new-generation techie who hails from Warsaw University of Technology, Poland. She has certifications in both database administration and Java development. Her interests include creating small automation devices using embedded systems and various electronic components. In her free time, she practices yoga, which helps her to center her thoughts and come up with new ideas.

Data Model Types: An Explanation with Examples

Data modeling is an essential part of designing a database. If you want to achieve the best outcome, make sure to utilize the available data models. Read on to find out more. Every relational database has clearly defined objects and relationships among these objects. Together, they comprise the data model. This article presents the concept of data modeling. First, we’ll go over data modeling and the steps of its process.

What Logical Models Data Types Are Available in Vertabelo?

Logical models define the initial blueprint of your database. Read along to learn how to create them and what attribute data types are available in Vertabelo. In this article, we’ll introduce the logical model. It essentially illustrates the structure of entities, attributes, and relationships in your database. Also, you’ll see the difference between logical and physical models. In the end, we’ll create a logical model in Vertabelo, which will include creating entities with attributes of specific data types.

How to Define a UNIQUE Key in Vertabelo

Among the many database constraints available to us, the UNIQUE key constraint ensures the uniqueness of data in a column or a set of columns. Read on to find out more about the UNIQUE key constraint and how to define it in Vertabelo. In this article, we’ll focus on the UNIQUE key constraint. We’ll start with its basic definition and usage and gradually build up to more advanced options. Also, we’ll jump into Vertabelo and create an ER diagram that uses the UNIQUE key constraint.

How to Model Snowflake External Tables in Vertabelo

There is a lot more data than stored in databases. This raises the question of how to access all the external data from the database. The external tables come to the rescue! Read along to learn more about external tables in Snowflake and how to model them in Vertabelo. This article focuses on external tables in the Snowflake database. We will first introduce the Snowflake database and the concept of external tables.

Vertabelo Editor Features That Make It Easier to Work on a Small Screen

Working on a small screen is quite different than working on a desktop with lots of screen real estate. Read on to find out how Vertabelo editor features simplify working on a small screen. Vertabelo provides you with features that make working on a small screen effective and seamless. These include showing and hiding items or panels, zooming in and out, or searching for specific objects. In this article, we’ll go through the features available in the main working areas of Vertabelo.

How to Define a Foreign Key in a Physical Model

A foreign key is one of the fundamental concepts of relational databases. You don’t store all your data in one table, but many different tables. Nonetheless, all your data is related. That’s where the foreign key comes into play. It facilitates the process of linking the tables. Read on to find out more. This article focuses on the concept of the foreign key in a physical model. First, we’ll briefly go over foreign key basics.

What Is a Primary Key?

Keys are one of the most vital features in a relational database. Among the many types of keys, the primary key is widely used and appreciated. Let’s find out what kinds of primary keys are available, what a primary key does, and how to use it in a table. In this article, you’ll learn all about primary keys in relational databases. The topics we’ll cover include: An overview of relational database keys.

Database Constraints in SQL Server and How to Model Them in Vertabelo

Database design – including where and how to use constraints – is essential to the correct function of your database. To properly implement database constraints in SQL Server, you must understand all the requirements and execute them accordingly. How would you do this? This article will explain it in detail! To design your database, you need a database blueprint, database constraints, indexes, database design software like Vertabelo – and more.

Constraints in MySQL and How to Model Them in Vertabelo

Before you do anything, you start with designing the database. It includes columns, tables, and relationships among them, as well as constraints. Database constraints play a crucial role in that they let you prevent any undesired data from being stored in a column or table. Let’s see how to make use of database constraints in MySQL. In this article, we’ll go through all database constraints available in a MySQL database:

Constraints in PostgreSQL and How to Model Them in Vertabelo

Database constraints allow you to give a certain shape to your data, tables, and columns. Are you planning to use PostgreSQL as your database? Check out what PostgreSQL constraints can do! In this article, we will go over PostgreSQL’s database constraints and see how to model them in Vertabelo. For each of the constraints, I’ll provide: A definition of the constraint. A usage example. Instructions on how to model the constraint in Vertabelo.