From the course: Relational Databases Essential Training

Unlock the full course today

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

Relational database normal forms

Relational database normal forms

From the course: Relational Databases Essential Training

Start my 1-month free trial

Relational database normal forms

- [Instructor] In Edgar Frank Codd's authoritative paper on the Relational Model, he defines a number of rules that data tables should adhere to in order to make up a well-structured database. He called tables that satisfied these requirements, "Normal Forms." And the process of assessing a table and making necessary changes to the structure, became known as "Normalization." Normalization is a series of rules that your databases 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. It's generally accepted that a relational database that meets the requirements of the third normal form is in pretty good shape, so that's…

Contents