3. Notice that the Data Modeler software SHOULD HANDLE all of the transforming of relationships to foreign key attributes for you. If you modeled attributes that have been replaced by foreign keys, be sure to delete the modeled version of the attribute. If you don't see a foreign key in a related entity, double-click the relationship line to open the Relationship Properties window, then close the relationship properties window. This should update the foreign key. Some foreign key additions are not automatically updated by the software. If you have questions about foreign keys, be sure to ask. TASK 3: NORMALIZATION - 20 Points: In this task, you will verify your design using the Normalization process. Ensure all your tables are normalized to 3NF. For each of your tables, identify the primary key, all the functional dependencies in the table, and the level of normalization of the table. All tables MUST be in 3NF when submitted with Part 2. The only exception are tables containing the Zip Code. Those tables may remain in 2NF as long as all other attributes are fully determined by the primary key. For any other table that is not in 2NF, move columns to their appropriate tables until all tables are in 3NF