| |
| | Normalization Example |
 | | By specifying the correct student number, we are able to retrieve information about the desired student named "Smith." Retrieving information about the specific "Smith" depends upon the specification of the correct student number. |
 | | Won't this eliminate any ambiguity when searching for students named "Smith?" The problem is not eliminated because it is possible (actually quite probable) that two or more students have the same last and first names, causing problems when searching for specific information. |
 | | Here we see that the student name, address, etc., are functionally dependent upon the student number in the STUDENT object (file), and that the class description, start date, building name, etc., are functionally dependent upon the Student Number and the Class Code in the ENROLL object (file). |
| www.uwf.edu /wbeatty/ism4113/chap69/normalize.html (1602 words) |
|