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.

ER Diagram Cheat Sheet

An ER diagram is a database blueprint. It facilitates data visualization and database development processes. Read on to find out what ER diagrams are and how to create them in Vertabelo. In this article, we’ll explain what an ER diagram is and what elements it contains. We’ll discuss ER diagram abstraction levels, such as conceptual, logical, and physical diagrams. You’ll learn how to build ER diagrams using various notations, such as Crow’s Foot notation, Barker’s notation, and more.

Top 8 Database Schema Design Tools

Database modeling is the first and most crucial step in creating a database. Read on to find out about our favorite database diagramming tools. In this article, we’ll talk about database modeling and why you need data modeling in the first place. Then we’ll introduce several database modeling tools that facilitate database schema design, including: Online database modeling tools: Vertabelo SqlDBM DbDio SqlDBD Standalone applications for database modeling: Navicat ERBuilder SQL Developer Data Modeler MySQL Workbench The database design process is more than just creating an entity-relationship diagram, or ERD.

How to Export an SQL DDL File From SQL Server Management Studio for Reverse Engineering

Keep your database secure and up to date by deconstructing your database to extract and update its design. In this article, we show you how to export an SQL DDL file from SQL Server Management Studio, that is, export your SQL Server database in the form of an SQL script, and import it into Vertabelo. Also, you'll learn about the Vertabelo Reverse Engineering tool to export your entire database into an XML file and import it into Vertabelo for further processing.

How to Create a Database Diagram from a DDL

A database diagram, aka ER diagram, is a certain type of flowchart used in database design. It describes the entities and how they relate to one another. Vertabelo lets you create an ER diagram for your database by importing a DDL file. Read on to find out more. This article introduces what a DDL file is and why ER diagrams are an essential tool in the database development process. In the end, I’ll show you how to import a DDL file into Vertabelo to get an ER diagram of your database.

How to Put Tables in a Vertabelo Data Model Into a Particular Schema

There is more to a database structure than just tables. Tables are logically divided into groups and stored in database schemas. Read along to find out how to include schemas in your ER diagram using Vertabelo. A database consists of one or more database schemas, and a database schema consists of one or more tables. A good data modeling tool helps you set them all up. In this article, you’ll see how to create database schemas in Vertabelo and assign tables to them.

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.