This document explores the process of database normalization, specifically focusing on the transformation of a home library database from its initial state to 3NF. The document outlines the steps involved in achieving 1NF, 2NF, and 3NF, highlighting the key concepts of functional dependencies, partial dependencies, and transitive dependencies. It also demonstrates the application of referential integrity to ensure data consistency and prevent redundancy across the normalized tables.