2. It’s A Grind 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 file. : x v fxA1Book IDABDEFGHIKBinding Condition Bought PriceРаperРаper1 Book IDYear### BallantineAuthorTitleNotesPublisher12 Hersey\O'Connor10 FaulknerFitzgerald8 Fitzgerald\Runy3 Doyle, Sir Arthur19 Poe, Edgar Allan1|Verne, Jules7 Anth:FaulknerJoyce4 Crane, Stephen5 James, Henry18 HemmingwayJoyce13 Lynn, Kenneth9 FaulknenCapote20 Lamb\Hawthome16 CaldwellStuart17 Hemmingway\Ohen11 Maugham\Benet2 Doyle, Sir Arthur6 Melville, Herman14 Evans, Bergen15 Cervantes\BorgeStories Of Sudden TruthStories For The Here And NowManhattan:Stories From The Heart Crane\Wharton\OharaMemoirs Of Sherlock Holmes, TheMasterpieces Of MysteryFrom The Earth To The MoonSix Great Modem Short NovelsRed Badge Of Courage, TheTurn Of The Screw+Daisy MillerShort Story MasterpiecesComic Tradition In America, TheGreat Tales Of The Deep SouthSelected English Short StoriesStory Pocket Book, ThePocket Book Of Short Stories, The TolstoiCather\Et. AlGreat Tales Of Fantasy & Imaginat Wells\Poe\KiplingCasebook Of Sherlock Holmes, TheShorter Novels Of Herman MelvilleNatural History Of Nonsense, TheSpanish Stories And TalesWest\Saroyan\CapoteMaugham\Shaw\Et. Al ### Bantam$5.00$3.00$3.50$7.502Fair3Fair### Bantam### Berkley### Books, Inc.###Crest Books### Dell### Dell### Dell### Dell### Doubleday### Lion Library4SoftGoodSoftGoodHardcove GoodCardboar Very PoorLeather GoodCardboar GoodNone|РaperРаper$5.00$7.00$8.006.78Melville\GogoEt. AIYear Is A GuessSteinbeck\Fitz.Et. Al$3.00$5.00$5.5010Excellent11GoodGood$5.00$5.001213T.Williams\Et. AlРаperHardcove Fair|РаperРаperNoneFairPoe\Dickens\James\Et A ### Oxford Univ.Pr.Faulkner\Saroyan\Et. Al ### Pocket Books$5.00$4.00$5.00$7.00$6.00$5.001415Fair### Pocket Books### Pocket Books### Pocket Books### Premier### Vintage BooksUnamuno\Baroja\Et.AI ### Washington Squa Paper16Fair17Рoor18FairyHardcove GoodРаperРаper19$4.00$3.5020Good21Good22232425262728

2. It’s A Grind 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 file.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

2. It’s A Grind 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 file.

: x v fx
A1
Book ID
A
B
D
E
F
G
H
I
K
Binding Condition Bought Price
Раper
Раper
1 Book ID
Year
### Ballantine
Author
Title
Notes
Publisher
12 Hersey\O'Connor
10 FaulknerFitzgerald
8 Fitzgerald\Runy
3 Doyle, Sir Arthur
19 Poe, Edgar Allan
1|Verne, Jules
7 Anth:FaulknerJoyce
4 Crane, Stephen
5 James, Henry
18 HemmingwayJoyce
13 Lynn, Kenneth
9 FaulknenCapote
20 Lamb\Hawthome
16 CaldwellStuart
17 Hemmingway\Ohen
11 Maugham\Benet
2 Doyle, Sir Arthur
6 Melville, Herman
14 Evans, Bergen
15 Cervantes\Borge
Stories Of Sudden Truth
Stories For The Here And Now
Manhattan:Stories From The Heart Crane\Wharton\Ohara
Memoirs Of Sherlock Holmes, The
Masterpieces Of Mystery
From The Earth To The Moon
Six Great Modem 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 TolstoiCather\Et. Al
Great Tales Of Fantasy & Imaginat Wells\Poe\Kipling
Casebook Of Sherlock Holmes, The
Shorter Novels Of Herman Melville
Natural History Of Nonsense, The
Spanish Stories And Tales
West\Saroyan\Capote
Maugham\Shaw\Et. Al ### Bantam
$5.00
$3.00
$3.50
$7.50
2
Fair
3
Fair
### Bantam
### Berkley
### Books, Inc.
###Crest Books
### Dell
### Dell
### Dell
### Dell
### Doubleday
### Lion Library
4
Soft
Good
Soft
Good
Hardcove Good
Cardboar Very Poor
Leather Good
Cardboar Good
None
|Рaper
Раper
$5.00
$7.00
$8.00
6.
7
8
Melville\GogoEt. AI
Year Is A Guess
Steinbeck\Fitz.Et. Al
$3.00
$5.00
$5.50
10
Excellent
11
Good
Good
$5.00
$5.00
12
13
T.Williams\Et. Al
Раper
Hardcove Fair
|Раper
Раper
None
Fair
Poe\Dickens\James\Et A ### Oxford Univ.Pr.
Faulkner\Saroyan\Et. Al ### Pocket Books
$5.00
$4.00
$5.00
$7.00
$6.00
$5.00
14
15
Fair
### Pocket Books
### Pocket Books
### Pocket Books
### Premier
### Vintage Books
Unamuno\Baroja\Et.AI ### Washington Squa Paper
16
Fair
17
Рoor
18
Fairy
Hardcove Good
Раper
Раper
19
$4.00
$3.50
20
Good
21
Good
22
23
24
25
26
27
28

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 10 steps with 10 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.