Objective: Normalize a table by splitting it into smaller, related tables to reduce redundancy and improve data integrity.
Normalization involves organizing data into tables based on functional dependencies. For example, a Task Table might include Task ID and Task Description to avoid duplicating task details.
| Task ID # | Task Description | Employee ID # | Due Date | Last Name |
|---|