Its 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 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 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. the data for the coffee shop is provided in the attached spreadsheet - t6_itsagrindcoffee_data. xls
2. create microsoft access database and create the tables. based on input from a database design expert, the database would be best designed if it is normalized into 5 tables:
a. author (authorid, authorname)
b. binding (bindingid, binding)
c. publisher (publisherid, publishername)
d. condition (conditionid, condition)
e. book (bookid, authorid, title, notes, year, publisherid, bindingid, conditionid, price)

3. create the foreign key relationship(s) needed between the tables.