What Is Normalization?
In this lesson, we will learn about the different normalization forms and why we use the normalization technique.
We'll cover the following...
Normalization should be part of the database design process. However, it is difficult to separate the normalization process from the ER modeling process so the two techniques should be used concurrently.
We use the entity relation diagram (ERD) to provide the big picture, or macro view, of an organization’s data requirements and operations. This is created through an iterative process that involves identifying relevant entities, their attributes, and their relationships. ...