Data Modeling Archives

Having a good understanding of data modeling enables you to write better queries.  Use the articles found on this page to familiarize yourself with these concepts such as database normalization.

I would start out by reading  Keep is Simple: Easy To Understand Data Modeling Concepts, once you have become familiar with those concepts, I would highly recommend reading Database Normalization Explained in Simple English.

Once you are familiar with the concepts, then check out

Data Modeling Principles in Action, it will put some of the theory in to practice.

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.  You can get started using these free tools using my guide Getting Started Using SQL Server

What is the difference between a primary and unique key?

Primary and Unique Key

In this article we learn the difference between a primary and unique key, and why both are important to maintaining a relational database structure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide Getting Started Using SQL […]

Continue reading
10

What is the Difference between a Primary Key and a Foreign Key?

Primary and Foreign Keys

In this article we learn the difference between a primary key and a foreign key, and why both are important to maintaining a relational database structure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide Getting Started […]

Continue reading
43

Database Normalization Explained in Simple English

Database Normalization Explained

Introduction to Database Normalization Database normalization is process used to organize a database into tables and columns.  The idea is that a table should be about a specific topic and that only those columns which support that topic are included. For example, a spreadsheet containing information about sales people and customers serves several purposes: Identify […]

Continue reading
4

Keep is Simple: Easy To Understand Data Modeling Concepts

Relational Database Data Models

When working with SQL databases it is often useful to create diagrams of the database tables and their relationships.  These may be done during the design process, as  your data modeling, or once the database is created, in order to document the tables’ dependencies.  As I explain various concepts in my lessons, I’ll sometimes use […]

Continue reading