Lesson 1
First, second, and third normal formsRelational Databases
Relational databases work because they are based on logically sound elements of set theory. Fortunately, you don't have to become an
expert in a highly theoretical branch of mathematics to design efficient databases. But if you learn a few of the principles without delving
into the underlying theory, you will be a better designer. This module introduces techniques you can use to improve your database designs
without worrying about the math.
Learning objectives
After completing the lessons in this module, you should be able to:
- Define the concept of normalization
- Explain the requirements for first normal form (1NF)
- Identify repeating groups
- Explain the requirements for second normal form (2NF)
- Identify functional dependencies
- Describe the limitations of 2NF