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
From the course: Database Foundations: Data Structures
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.