A book checkout report for a library is shown in the figure. Normalize this report into third normal form tables for use in a relational database. 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 report similar to the procedures found in the chapter and show the linkages between the related tables (primary keys and foreign keys). Make the following assumptions: The call number is unique to the book, and not to the event of borrowing the book. Also assume that more than one copy of the book may exist in the library and that all copies have the same call number.

Transcribed Image Text:

STUDENT ID NUMBER 678-98-4567 678-98-4567 244-23-2348 398-34-8793 398-34-8793 678-98-4567 244-23-2348 STUDENT FIRST STUDENT NAME LAST NAME Amy Amy Ramesh James James Amy Ramesh Baker Baker Sunder Talley Talley Baker Sunder NUMBER OF BOOKS OUT 4 4 1 3 3 4 1 BOOK DATE CALL NO BOOK TITLE OUT hf351.j6 Avalanches hf878.k3 Tornadoes 1835.123 Politics k987.d98 Sports d879.39 p987.187 q875.176 Legal Rights Earthquakes Past Heroes DUE DATE 09-02-xx 09-16-xx 09-02-xx 09-16-xx 09-02-xx 09-16-xx 09-02-xx 09-16-xx 09-02-xx 09-16-xx 09-03-xx 09-17-xx 09-03-xx 09-17-xx