Posts Categorized in Redgate Data Modeler
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
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
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
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
In part 2 of our series, we’ll analyze the differences between products and services, how they impact the database model, and how we can accommodate both on one database. Read more
As an SQL consultant, I often work with others to create new database models from scratch or modify existing schemas. Aside from the technical aspects, collaborations on database models can be tricky. Moving from environment to environment poses its own challenges: security restrictions sometimes prevent direct access to SQL instances, and technical resources from... Read more
The development release of MySQL 5.7 definitely introduces some exciting changes to the world of database management systems. Is it worth giving a try? Let's have a closer look at a few brand-new features that may help you decide to do so. Read more
