Tag Archive

Tag Archives for " Normalization "

Database Third Normal Form Explained in Simple English

Second Normal Form

This is the fourth in a series of posts teaching normalization.  The third post focused on the second normal form, its definition, and examples to hammer it home. Once a table is in second normal form, we are guaranteed that every column is dependent on the primary key, or as I like to say, the table serves […]

Continue reading

BI For Beginners – a Business Intelligence Interview with Brian Larson

Business Intelligence

I recently had the opportunity to ask Brian Larson some questions regarding Business Intelligence.  For those new to the field, Business Intelligence, or BI for short, is an rapidly expanding  field within the database realm. BI brings with it a different way of thinking!  We all struggled to understand normalization and create efficient transactional data […]

Continue reading

Learn about the First Normal Form and Database Design

First Normal Form

This is the second in a series of posts teaching normalization. The first post introduced database normalization, its importance, and the types of issues it solves. In this article we’ll explore the first normal form. For the examples, we’ll use the Sales Staff Information shown below as a starting point.  As we pointed out in the […]

Continue reading

Database Normalization Explained in Simple English

Database Normalization Explained

Introduction 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 sales people in […]

Continue reading