www.databasejournal.com/sqletc/article.php/1474411
March 22, 2002
So, we go through all the fields. Project name is only dependent
on Project number. Employee name, Rate category and Hourly rate
are dependent only on Employee number. So we remove them, and
place these fields in a separate table, with the key being that
part of the original key they are dependent on. So, we are left
with the following 3 tables: Project number - primary key Employee number - primary key Project number - primary key
The table is now in 2nd normal form. Is it in 3rd normal form?
|
| Go to page: Prev 1 2 3 4 5 6 Next |
|
|
|
|
|
|