What is Normalization? | How to apply Normalization up to the 5th Normal Form?

“image: Freepik.com”. This cover has been designed using resources from Freepik.com


What is Normalization?

Fig: 1

What are data anomalies?

1st Normal Form

Fig: 2
Fig: 3
Fig: 4
Fig: 5

2nd Normal Form

Fig: 6

3rd Normal Form

Fig 7: Transitive dependency
Fig 8: New table for the projects
Fig: 9

Boyce and Codd Normal Form (BCNF)

Fig: 10
Fig: 11

4th Normal Form

Fig: 12
Fig: 13

5th Normal Form (Project join normal form)

Wrapping Up

#Programmer #FullStackDeveloper #TechGeek