A table of data for a library is shown in the table for Problem. Normalize these data into the third normal form, preparing it for use in a relational database environment. The library’s computer is programmed to compute the due date to be 14 days after the checkout date. Document the steps necessary to normalize the data similar to the procedures found in the chapter. Index any fields necessary and show how the databases are related.
|
NORMALIZATION OF DATA |
|||||||
|
STUDENT ID NUMBER |
STUDENT |
STUDENT |
NUMBER |
BOOK |
BOOK |
DATE |
DUE |
|
678 98 4567 |
Amy |
Baker |
4 |
hf351.j6 |
Avalanches |
09 02 09 |
09 16 09 |
|
678 98 4567 |
Amy |
Baker |
4 |
hf878.k3 |
Tornadoes |
09 02 09 |
09 16 09 |
|
244 23 2348 |
Ramesh |
Sunder |
1 |
i835.123 |
Politics |
09 02 09 |
09 16 09 |
|
398 34 8793 |
James |
Talley |
3 |
k987.d98 |
Sports |
09 02 09 |
09 16 09 |
|
398 34 8793 |
James |
Talley |
3 |
d879.39 |
Legal Rights |
09 02 09 |
09 16 09 |
|
678 98 4567 |
Amy |
Baker |
4 |
p987.t87 |
Earthquakes |
09 03 09 |
09 17 09 |
|
244 23 2348 |
Ramesh |
Sunder |
1 |
q875.i76 |
Past Heroes |
09 03 09 |
09 17 09 |