Posts by
Redgate Data Modeler
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
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
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
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
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
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
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
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
Today we continue our series of posts on data normalization. In the previous post on data normalization I explained what functional dependency is. Today we will talk about candidate keys in a table. Read more
Do you remember the ? I promised you we'd explain how to design tables which have no update anomalies. Today we begin a series of posts on data normalization. We will talk about functional dependencies, a concept that needs to be explained before we dive deeply into database schema normalization.
The subject is rather abstract... Read more
Redgate Data Modeler