From the course: Database Foundations: Data Structures

Unlock the full course today

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

Second normal form

Second normal form

From the course: Database Foundations: Data Structures

Start my 1-month free trial

Second normal form

- [Instructor] The goal of the second normal form is to remove the redundancy that was introduced when we were converting our data table in to first normal form. We'll do that by first making sure that we've satisfied the requirements of 1NF and then create related tables to store those redundant pieces of information. At this point, our pet owners table is in first normal form, but we have some redundant data issues to work out. We need to go through each column in this table and determine if it describes the main topic of the table, or if it's a descriptive attribute of something else. In database terminology, what we're looking for is called functional dependency. So if this table is supposed to be storing information about owners, then we can ask if each attribute column is functionally dependent on a specific owner. The first and last names are attributes that describe each owner in the table, so they're fine. The…

Contents