Task

Question#1

Using the Book List shown above Identify and describe at least three of the following

issues:

a)

Any problems with unnecessarily repeated (i.e. redundant) data.

b)

Any problems with atomicity that is columns that store more than one piece of

information. For example: multiple dates, multiple names, or multiple pieces of

address information.

c)

Any NULL values (if any).

d)

Any groupings of columns that really belong in separate tables because they really

describe different entities.

NOTE: it is common for book titles to be reformatted so that the word The is not at the

start of the title listing this is not a problem it makes searching by title easier.

Question#2

Try to separate out all of the information stored in the above Book List into outlines for

three new tables called: Book, Author, and Publisher. For each new table include only

columns from the Book List that really belong to that new table.

For example, the new Book table should only contain columns from the Book List that

describe book specific attributes (e.g. Book Title). The Publisher table should only

include columns that really describe something about the publisher (e.g. Publisher

Name). The Author table should only include author information from the original Book

List.

In your listing of the new tables you do not have to list all the data in the Book List only

the column headings. Please make sure all the columns in your new tables are split up

properly so they are atomic (i.e. store only one piece of information). Try and identify a

unique lookup on each table (it is ok to make up a new column if you want). NOTE: it is

ok to rename or split up columns from the original Book List but you cannot just throw

away any of the original columns from the Book List!

Sample New Table Listings:

Book(Title, etc...)

Publisher(PublisherName, etc....)

Author( etc...)

NOTE:

GRC through

211 TILT,

SBCTC,

CC BY 4.0

The etc... here denotes the rest of the property associated, atomic columns that should

be grouped under their correct table. You should not have the same column in more

than one table!

Criteria for Success

Question#1 (3 points):

At least three specific problems identified about the original Book List.

Question#2 (6 points):

Listing of three new tables (i.e. entities) and their columns (i.e. attributes)

2 BKNOL TITLE Casebook Of Sherlock Holmes, The Red Badge Of Courage, The 5 Turn of the Screw YEAR PRICE PUBLISHER LOCATION AUTHOR 1950 4.25 Pocket New York, NY Doyle, Sir Arthur Books Conan 1966 5.75 Dell Chicago, IL Crane, Stephen LIVED 1910- 1980 1920- 1975 1914- 1984 1920- 2010 1940- 1960 6.50 Dell Chicago, IL James, Henry 22 Pock, The New York, NY Benet, Stephen 1946 6.25 Pocket Books 1966 6.50 Dover 31 Hopalong-Freud & Other Parodies Peterkin Papers, The 64 1963 6.75 Dover Los Angeles, Wallach, Ira CA Los Angeles, Hale, Lucretia Los Angeles, Hale, Lucretia (CA New York, NY Vandercook, John 65 Last Of The Peterkins, The 1965 5.50 Dover 1925- 1985 1925- 1985 1930- 2005 1950- 70 Black Majesty: Life of Christop Book Of The Dun Cow, The 1952 9.00 Pocket Books 1979 8.50 Pocket Books 75 New York, NY Wangerin, Walter