background

question

Individual Database Assignment: Game Store (Worth up to 2.5 points, including ERD) Price BUSINESS CASE Game Store is a small independent online business with a variety of educational games for children. This business has requested your assistance in creating a tracking database to help them organize their product shelf placement, product list and vendor contact information. The store manager provided the sample data from a spreadsheet they are currently keeping. Product Product Game Title Retail Supplier Contact Name Contact Phone Category Location Coding Shelf 11 Coding with Rover $24.95 Games for Kids Riley Wilson (805) 555-7788 Coding Shelf 11 Code like a Pro $19.95 Fun Learning Chas Taylor (408) 555-2345 Math Shelf 27 Counting Pizza $9.95 Academic Tools Jean Francis (602) 555-5678 Reading Shelf 15 Fun Letter Sounds $25.95 Learning Tree Susanne Lee (714) 555-1212 Math Shelf 27 Flipping Fractions $15.95 Academic Tools Jean Francis (602) 555-5678 Reading Shelf 15 Ski Reading Fun $11.95 Learning Tree Susanne Lee (714) 555-1212 Typing Shelf 30 Home Row Typing $14.95 Games for Kids Riley Wilson (805) 555-7788 Coding Shelf 11 Fun with Coding $21.95 Games for Kids Riley Wilson (805) 555-7788 Typing Shelf 30 Sports Words $25.95 Fun Learning Chas Taylor (408) 555-2345 $8.95 Fun Learning Chas Taylor (408) 555-2345 Math Shelf 27 How to Tell Time 2. Create a Microsoft Access database, including: 1. Create all tables with appropriate field formats and primary keys identified (.5 point); B. Establish correct table relationships (-25 point); c. Enter all data (efficiently; i.e., without duplication) (-25 point); d. Create a form for entering new games from these same suppliers (-25 point); . Create a Query to show only games under $24.00 (5 point); f. Create a Report to see the data (you can use Report Wizard) (-25 point). Please submit your ERD and the Access file [LastName].accdb on Canvas