From the course: Learning Relational Databases

Unlock the full course today

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

First normal form

First normal form

From the course: Learning Relational Databases

Start my 1-month free trial

First normal form

“

- [Instructor] By now you should have a good idea of all the tables that you'll need to store your data as well as the individual fields or columns that'll be in those tables, including the primary keys. Now comes the process of adding additional tables and fields that will be required by the DBMS to do its job efficiently. This is a process called normalization. Normalization is a series of rules that your database's table structure must pass in order to be considered a good, relational design. The individual rules are called normal forms and they must be tested in order, like passing through a series of gates or checkpoints. In other words, you can't satisfy the requirements of the second normal form without first satisfying the requirements of the first normal form. Now, you might have actually accomplished some of these checks earlier in the process without realizing it. There are multiple ways to identify the issues that we're about to look for, but it's always a good idea to go…

Contents