Third Normal Form (3NF)
Well we have already seen the Zero Normal Form (0NF), First Normal Form (1NF), and the Second Normal Form (2NF) databases. Now it is on to the nitty gritty, introducing the Third Normal Form (3NF) Below is a rendition of the 2NF database from the last page normalized to (3NF specifications.
| PersonID (PK) | FirstName | LastName | Middle Initial | Address | Location (FK) |
|---|---|---|---|---|---|
| 1 | Joseph | Dimaggio | P | 123 foo lane | 43235 |
| 2 | George | Ruth | H | 124 foo lane | 43235 |
| 3 | Reginald | Jackson | M | 125 foo lane | 10001 |
| 4 | Joseph | Torre | 126 foo lane | 10001 | |
| 5 | William | Martin | 127 foo lane | 10001 |
| StudentID (PK) | PersonID (FK) | DepartmentID (FK) | ProfessorID (FK) |
|---|---|---|---|
| 1 | 1 | 400 | 1 |
| 2 | 2 | 400 | 1 |
| 3 | 3 | 500 | 2 |
| LocationID | Location | Type |
|---|---|---|
| 1 | Columbus | city |
| 2 | Columbus | state |
| 3 | 43235 | zipcode |
| 4 | Bronx | city |
| 5 | New York | state |
| 6 | 10001 | zipcode |
| ProfessorID (PK) | PersonID (FK) | DepartmentID (FK) |
|---|---|---|
| 1 | 1 | 400 |
| 2 | 2 | 500 |
| DepartmentID (PK) | Department |
|---|---|
| 400 | Computer Science |
| 500 | Math |
home | me | faq | resume | portfolio | pics | site | asp | asp.net | java | javascript | sql | xml
algorithms | dbms | html | j2ee | mis | networking | os | se | more...
algorithms | dbms | html | j2ee | mis | networking | os | se | more...
Updated: Mar. 22, 2005; Joe Gakenheimer
© joegakenheimer.com