I. OBJECTIVES At the end of this exercise, students must be able to: 1. Analyze data and identify the functional dependencies 2. Normalize data to third normal form II. BACKGROUND INFORMATION What is Normalization? Normalization is a formal process for deciding which attributes should be grouped together in a relation. Steps: 1. Remove multivalued attributes (1NF) 2. Remove partial dependencies (2NF) 3. Remove transitive dependencies (3NF) Figure 4.1 INVOICE data of Pine Valley Furniture Company Functional dependency The value of one attribute (the determinant) determines the value of another attribute. Figure 4.2 Functional Depen