Redgate Blog

Posts by

Redgate Data Modeler

Redgate Data Modeler

1 August 2014

Redgate Data Modeler

1 August 2014

Barker’s Notation

When looking at different kinds of ERD notations, it is hard not to come across Barker's ERD notation, which is commonly used to describe data for Oracle. Richard Barker and his coworkers developed this ERD notation while working at the British consulting firm CACI around 1981, and when Barker joined Oracle, his notation was... Read more

Redgate Data Modeler

31 July 2014

Redgate Data Modeler

31 July 2014

ERD Notations in Data Modeling

An entity relationship diagram (ERD) is a diagram that defines the structure of database instances. Choosing which notation to use is typically left up to personal preference or conventions. Here, you can find some useful information about each notation. Read more

Redgate Data Modeler

28 July 2014

Redgate Data Modeler

28 July 2014

How to Model Inheritance in a Relational Database

In the process of designing our entity relationship diagram for a database, we may find that attributes of two or more entities overlap. In this case, we may create a subtype of the parent entity that contains distinct attributes and supertype entity. The article presents how to model inheritance and what are the... Read more

Redgate Data Modeler

15 July 2014

Redgate Data Modeler

15 July 2014

How do I create a company account ?

If you need many accounts for your employees and don't want to pay for each account separately, create Vertabelo company account. A company account enables model sharing, inviting people, working on a model at the same time, and paying for group of workers. Read more

Redgate Data Modeler

15 July 2014

Redgate Data Modeler

15 July 2014

How do I pay for a company account after the trial period ends ?

If your 14 days company account trial period is going to end and you want to continue using the company account, there is an easy way to set up a monthly subscription for the appropiate number of users. Read more

Redgate Data Modeler

15 July 2014

Redgate Data Modeler

15 July 2014

N-ary relationship types

When we design a database, we draw an entity relationship diagram (ERD). It helps us understand what kind of information we want to store and what kind of relationships there are. It is imperative that this diagram is easy to read and understand. The number of entities in a relationship is the arity of this... Read more

Redgate Data Modeler

10 April 2014

Redgate Data Modeler

10 April 2014

Database Design 101: How to Start Creating a Database Model

In this video you will learn how to start creating your database model. You will find out why nouns are important and how you should handle them when creating a database model. Read more

Redgate Data Modeler

3 April 2014

Redgate Data Modeler

3 April 2014

The Boyce-Codd Normal Form (BCNF)

Why do you need all of this normalization stuff? The main goal is to avoid redundancy in your data. Redundancy can lead to various anomalies when you modify your data. Every fact should be stored only once and you should know where to look for each fact. The normalization process brings order to your... Read more

Redgate Data Modeler

1 April 2014

Redgate Data Modeler

1 April 2014

New Feature: Photo Reverse Engineering

We're happy to announce that Vertabelo has a new feature we've been working on for some time: Photo Reverse Engineering. This is the quickest way to transfer your hand-written design sketches into Vertabelo. Draw your model on a piece of paper, a whiteboard, or a blackbord, take a photo, upload it into Vertabelo and... Read more

Redgate Data Modeler

28 March 2014

Redgate Data Modeler

28 March 2014

SQL Performance Explained – the must-read book

Some time ago, the Vertabelo Team participated in the PostgreSQL Conference Europe 2013. Some of the talks were really nice. One of them stuck in my head for quite a long time. It was Markus Winand's lecture titled "Indexes: The neglected performance all-rounder." Although I had had a solid background in databases, this 50... Read more