Relational Database and Normalization



Author: Zakhar Pidporinov

Course description

This course covers the theory of relational databases. It explains what relational databases are and contrasts them with non-relational databases. The course will guide you through the process of designing databases and introduce you to different types of relationships. You will also learn about normalization and normal forms, and how they can be used to create efficient and optimized databases.


Complete all chapters to get certificate


Database Models


In this section, you will become familiar with both relational and non-relational databases and learn how to create diagrams to represent database structures.


Difference between Relational and Non-relational Databases

Entity-Relationship Model

Entity-Relationship Model. Relationships

Relational Database


This section delves deeper into the topic of relational databases and provides a comprehensive overview of the key theoretical concepts. Topics covered include foreign keys, the different ON DELETE options, and the various types of relationships.

Structure. Primary Key and Foreign Key

Foreign Key Constraints. ON DELETE Options

Many-to-One and One-to-Many

One-to-One and Many-to-Many

Normalization and Normal Forms


It's time to learn how to construct databases, with a focus on ensuring a well-structured database for optimal functionality. In this section, you will familiarize yourself with the key principles for building a database for ease of use.


Unnormalized Form. First Normal Form

Second Normal Form

Third Normal Form

Boyce–Codd Normal Form

Denormalization. Summary