RelationalDBDesign
Home
Search
SiteMap
Advanced SQL
Basic SQL
DB Creation Architect
Extended DB Features
Managing DB Objects
Oracle Net Topology
PL/SQL Programming
SQL Tuning
Database Analysis
Database Design
Oracle 8i PL/SQL
PL/SQL Objects
SQL Introduction
Select Statement
Relational Databases
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 .
