From the course: Database Foundations: Data Structures

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

First normal form

First normal form

From the course: Database Foundations: Data Structures

Start my 1-month free trial

First normal form

“

- [Instructor] Let's take a look at meeting the requirements of the first normal form. In order to get our data table into 1NF, we need to make sure that it's in an entity format and remove repeating groups of values. We can do this by ensuring that at least one column will store a unique identifier for each record, and then remove the ability to store multiple values in a single field, or have repeating lists of the same kind of data. Let's think about what all this means by creating a simple database to store information about pets and their owners. Here I have a simple spreadsheet with the information for a single pet owner named Tabitha. She lives in Houston, Texas, and has two pets, a goldfish named Bubbles and a dog named Buddy. The first step in the database normalization process is to make sure that no single column holds multiple values. So instead of storing Tabitha's first and last name in a single column, we can…

Contents