Accounting Information Systems 8th Edition by James Hall

Exercise 55

NORMALIZATION OF DATA
A table of data for a library is shown in the table for Problem 9. Normalize these data into the third normal form, preparing them 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.