2.4 Normalize a library's database Given below is the table of data for a library. First, determine which attribute is the best primary key. Second, examine the table and indicate the anomalies that may occur with the original design of this database. Why? Third, normalize the table into the third normal form to prepare it for use in a rela- tional database environment.

Transcribed Image Text:

Call# Title Borrower First Name Last Name Date Out Date Due ID# K561.02 Soccer S551442 John Austin 12-03-05 01-03-06 D221.67 US Presidents S702361 James Wilson 12-20-05 01-20-06 1264.89 HR Laws & F012618 Mark Ding 12-20-05 03-20-06 Regulations H122.34 Volcanoes S702361 James Wilson 12-20-05 01-20-06 K249.02 Swimming S002579 Freddie Sunder 01-03-06 02-03-06 M426.52 Egypt S002579 Freddie Sunder 01-03-06 02-03-06 K922.4 Badminton F012618 Mark Ding 01-05-06 04-05-06