It?s Aa Grindd Coffee Shop It?s A Grind Coffee Shop is an Oakland, California, neighborhood coffee shop. Besides serving gourmet coffee, It?s A Grind dishes up sandwiches and desserts. Local bands, Internet connections, and floor-to-ceiling books on every wall provide entertainment. Kate Fitzgerald, the proprietor, has decided that a database would be helpful in the acquisition of new books. Although customers rarely buy books, they do disappear or fall apart from use. Kate needs a way to keep track of which books she has so that she does not pick up duplicates. She has hired you to help design a database to keep track of the books. To assist with the design, Kate has provided you with some data in an Excel spreadsheet, T6_ItsAGrindCoffee_ Data.xls. The spreadsheet is not normalized; Kate asks you to assist with that before you start to create the database. Specifically, Kate wants you to:

1. Create a Microsoft Access database. 2. Create the tables, fields, data types, and primary key(s) for the database using the structure provided in the T6_ItsAGrindCoffee_Data.xls fi le. 3. Create the relationship(s) needed between the tables. 4. Populate the database with the data provided in the T6_ItsAGrindCoffee_Data.xls fi le.

Transcribed Image Text:

Author 12 Hersey O'Connor 10 Faulkner Fitzgerald 8 Fitzgerald\Runy 3 Doyle, Sir Arthur 19 Poe, Edgar Allan 1 Verne, Jules 7 Anth:Faulkner\Joyce 4 Crane, Stephen 5 James, Henry 18 Hemmingway Joyce 13 Lynn, Kenneth 9 Faulkner Capote 20 Lamb\Hawthorne 16 Caldwell Stuart 17 Hemmingway Ohen. 11 Maugham\Benet 2 Doyle, Sir Arthur 6 Melville, Herman 14 Evans, Bergen 15 Cervantes Borge Book ID Title Stories Of Sudden Truth Stories For The Here And Now Manhattan:Stories From The Heart Memoirs Of Sherlock Holmes, The Masterpieces Of Mystery From The Earth To The Moon Six Great Modern Short Novels Red Badge Of Courage, The Turn Of The Screw+Daisy Miller Short Story Masterpieces Comic Tradition In America, The Great Tales Of The Deep South Selected English Short Stories Story Pocket Book, The Pocket Book Of Short Stories, The Great Tales Of Fantasy & Imagination Casebook Of Sherlock Holmes, The Shorter Novels Of Herman Melville Natural History Of Nonsense, The Spanish Stories And Tales Notes West Saroyan Capote Maugham Shaw Et. Al Crane Wharton\Ohara Melville Gogol\Et. Al Year Is A Guess Steinbeck\Fitz.Et. Al T.Williams\Et. Al Poe\Dickens\James\Et Al Faulkner\Saroyan\Et. Al Tolstoi Cather\Et. Al Wells Poe\Kipling Unamuno\Baroja Et.Al Year 1953 Ballantine 1951 Bantam 1954 Bantam 1963 Berkley 1941 Books, Inc. 1958 Crest Books Publisher 1954 Dell 1966 Dell 1960 Dell 1954 Dell 1958 Doubleday 1955 Lion Library 1921 Oxford Univ.Pr. 1945 Pocket Books 1941 Pocket Books 1954 Pocket Books 1950 Pocket Books 1960 Premier 1958 Vintage Books 1968 Washington Square Binding Condition Bought Price $5.00 $3.00 $3.50 $7.50 $5.00 Paper Fair Paper Fair Good Good Hardcover Good Cardboard Very Poor Leather Good Cardboard Good Soft Soft None Excellent Paper Good Paper Good Paper Fair Hardcover Fair Paper Fair Fair Paper None Poor Paper Fairy Hardcover Good Good Good Paper Paper $7.00 $8.00 $3.00 $5.00 $5.50 $5.00 $5.00 $5.00 $4.00 $5.00 $7.00 $6.00 $5.00 $4.00 $3.50 Author 12 Hersey O'Connor 10 Faulkner Fitzgerald 8 Fitzgerald\Runy 3 Doyle, Sir Arthur 19 Poe, Edgar Allan 1 Verne, Jules 7 Anth:Faulkner\Joyce 4 Crane, Stephen 5 James, Henry 18 Hemmingway Joyce 13 Lynn, Kenneth 9 Faulkner Capote 20 Lamb\Hawthorne 16 Caldwell Stuart 17 Hemmingway Ohen. 11 Maugham\Benet 2 Doyle, Sir Arthur 6 Melville, Herman 14 Evans, Bergen 15 Cervantes Borge Book ID Title Stories Of Sudden Truth Stories For The Here And Now Manhattan:Stories From The Heart Memoirs Of Sherlock Holmes, The Masterpieces Of Mystery From The Earth To The Moon Six Great Modern Short Novels Red Badge Of Courage, The Turn Of The Screw+Daisy Miller Short Story Masterpieces Comic Tradition In America, The Great Tales Of The Deep South Selected English Short Stories Story Pocket Book, The Pocket Book Of Short Stories, The Great Tales Of Fantasy & Imagination Casebook Of Sherlock Holmes, The Shorter Novels Of Herman Melville Natural History Of Nonsense, The Spanish Stories And Tales Notes West Saroyan Capote Maugham Shaw Et. Al Crane Wharton\Ohara Melville Gogol\Et. Al Year Is A Guess Steinbeck\Fitz.Et. Al T.Williams\Et. Al Poe\Dickens\James\Et Al Faulkner\Saroyan\Et. Al Tolstoi Cather\Et. Al Wells Poe\Kipling Unamuno\Baroja Et.Al Year 1953 Ballantine 1951 Bantam 1954 Bantam 1963 Berkley 1941 Books, Inc. 1958 Crest Books Publisher 1954 Dell 1966 Dell 1960 Dell 1954 Dell 1958 Doubleday 1955 Lion Library 1921 Oxford Univ.Pr. 1945 Pocket Books 1941 Pocket Books 1954 Pocket Books 1950 Pocket Books 1960 Premier 1958 Vintage Books 1968 Washington Square Binding Condition Bought Price $5.00 $3.00 $3.50 $7.50 $5.00 Paper Fair Paper Fair Good Good Hardcover Good Cardboard Very Poor Leather Good Cardboard Good Soft Soft None Excellent Paper Good Paper Good Paper Fair Hardcover Fair Paper Fair Fair Paper None Poor Paper Fairy Hardcover Good Good Good Paper Paper $7.00 $8.00 $3.00 $5.00 $5.50 $5.00 $5.00 $5.00 $4.00 $5.00 $7.00 $6.00 $5.00 $4.00 $3.50

Answer rating: 100% (QA)

Norm... View the full answer