Redgate Blog

Posts by
Redgate Data Modeler
Redgate Data Modeler

Redgate Data Modeler

Redgate Data Modeler

13 March 2014

Redgate Data Modeler

Redgate Data Modeler

13 March 2014

On Keys

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
Redgate Data Modeler

Redgate Data Modeler

7 March 2014

Redgate Data Modeler

Redgate Data Modeler

7 March 2014

On Functional Dependencies

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… Read more
Redgate Data Modeler

Redgate Data Modeler

28 February 2014

Redgate Data Modeler

Redgate Data Modeler

28 February 2014

Update Anomalies

In this article I will show you an example of the table that looks correct at first glance but when you try to modify data in it, several anomalies can occur. We'll discuss insert anomalies, update anomalies and delete anomalies. Read more