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.
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
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.
Trending now
This is a popular solution!
Step by step
Solved in 10 steps with 10 images