Relational Databases  «Prev  Next»

Database Table Normalization - Exercise

Breaking apart a Database Table from de-normalized Form

Objective: Understand normalization by breaking a table into smaller parts. 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 .