Database Table Normalization

Database Table Normalization - Exercise

Breaking apart a table
Objective: Understand normalization by breaking apart a table. Consider the following to-do list:

Task ID #	Task Description	Employee ID #	Due Date	Last Name
1	Management meeting	02	02/17/2008	Gauss
2	Create budget	02	01/01/2008	Gauss
3	Employee reviews	01	02/01/2008	Coulomb
4	Employee reviews	02	02/01/2008	Gauss

How can you break apart the table to normalize it for later use?
You might make several subsets of tables.
One example is a task table, which contains the task ID number and the task description.
Question: Can you name two more possible tables?
Type your answer in the text area below and click the Submit button to submit your answer .