1. Do a listing that represents the entities and attributes in the Book List. Select or create an appropriate primary key column for each entity. Make sure your data is atomic. List at least three entities: Book, Author, and Publisher.

*PLEASE NOTE: I want a listing of the attributes that you think should be there (e.g. columns split up for atomicity, surrogate keys, etc.)

*PLEASE NOTE AS WELL: You have to store all of the information from the original list one way or another (you cannot "throw away" columns)

Example of a Listing:

EntityName(primary key, attribute1,attribute2,attribute3)

where: EntityName

attribute1

Also, describe at least three specific problems with the Book List above (hint: look for redundant information, atomicity, etc.).

Book List BKNO TITLE YEARIPRICE PUBLISHER LOCATION AUTHOR LIVED asebook Of Sherlock olmes, The 1950 4.25 Pocket 19665.75 Dell 1960 6.50 Dell 1946 6.25 Pocket New York, NY Doyle, Sir Arthur 1910- 1980 1920 1975 1914 1984 New York, NY Benet, Stephen 1920- 2010 1940 Books Conan 4 Red Badge Of Courage Chicago, IL Crane, Stephen urn of the Screw hicago, IL James, Henry 22 Pock, The Books s Angeles, Wallach, Ira s Angeles, Hale, Lucretia s Angeles, Hale, Lucretia 31 Hopalong-Freud & Other 19666.50 Dover Parodies 64 Peterkin Papers, The 1925- 1985 1925- 1985 New York, NY Vandercook, John 1930- 2005 New York, NY Wangerin, Walter1950- 1963 6.75 Dover 65 ast Of The Peterkins, The 1965 5.50 Dover 70 Black Majesty: Life Of Christo Book Of The Dun Cow 1952 9.00 Pocket Books 1979 8.50 Pocket Books 75