Sometimes, you want all identifiers in your SQL script to be quoted. For example, you want them to have a particular case. Luckily, Vertabelo allows you to quote all SQL identifiers in your generated script to prevent you from any SQL name conflicts. Read more
Sometimes there are columns in a table that don’t belong to primary key, but are still unique. To mark them as a unique, you have to create an alternate (unique) key containing it. Read more
Did you know that you can copy tables between models in Vertabelo? It's useful for instance with tables that appear in almost every database model like user_account, address, client or product, or with tables that are specific for your domain. You don't have to create all tables from scratch. Read more
In this article we will show you how to design a database structure for an educational institution to store information about students, lecturers, classes, attendance, students’ achievements, etc. Read more
Would you like to make your database modeling faster and more convenient? Of course you would! One way to achieve this is to learn your database modeling tool’s keyboard shortcuts. To check them when working in Vertabelo, press Ctrl + I. Read more
From today until Christmas Eve, we’re going to publish some tips & tricks for users modeling their databases in Vertabelo. Check our blog every day for a new one! Read more
You’re finally ready to get down to real data modeling. We’ll start off with entities and their attributes. Entities are the basic building block of every data model. In this post, you’ll find out what they are and how to identify them. Read more
Have you ever changed your mind about the order of columns in your table? You probably have! Fortunately, changing the order of columns in Vertabelo is as easy as pie. Read more
Database models require that objects be named. While several facets of naming an object deserve consideration, in this article we’ll focus on the most important one: defining a convention and sticking to it. But first off, let’s get the answer to the question why we should use naming conventions. Read more
In this final post of Kent Graziano’s series on Data Vault, you will learn the basics of how to project the Business Vault and Raw Data Vault tables into star schemas which form the basis for our Information Marts. Read more
