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 arerelated.

Transcribed Image Text:

NORMALIZATION OF DATA STUDENT FIRST ID NUMBER NAME LAST NAME NUMBER OF BOOKS OUT STUDENT STUDENT BOOK CALL NO TITLE BOO K DATE DUE OUT DATE 678-98-4567 Amy 678-98-4567 Amy 244-23-2348 Ramesh Sunder 398-34-8793 James 398-34-8793 James 678-98-4567 Amy 244-23-2348 Ramesh Sunder Baker Baker hf351.j6Avalanches 09-02-09 09-16-09 hf878k3 Tomadoes 09-02-09 09-16-09 i835123 Poliics k987.d98 Sports d879.39Legal Rights 09-02-09 09-16-09 p987.t87 Earthquaks 09-03-09 09-17-09 q875.176 Past Heroes 09-03-9 09-17-09 09-02-09 09-16-09 09-02-09 09-16-09 Talley Talley Baker