Individual Database Assignment: Game Store (Worth up to 2.5 points, including ERD) 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. Game Title Supplier Contact Name Product Category Retail Price Contact Phone Product Location Shelf 11 Coding with Rover $24.95 Games for Kids Riley Wilson Coding Coding Math Shelf 11 Code like a Pro $19.95 Fun Learning Chas Taylor Shelf 27 Academic Tools Jean Francis Learning Tree Susanne Lee Jean Francis Reading Shelf 15 Math Shelf 27 Reading Shelf 15 Typing Shelf 30 Coding Shelf 11 Typing Shelf 30 Math Shelf 27 Counting Pizza $9.95 Fun Letter Sounds $25.95 Flipping Fractions $15.95 Ski Reading Fun $11.95 Home Row Typing $14.95 Fun with Coding $21.95 Sports Words $25.95 How to Tell Time $ 8.95 Academic Tools Learning Tree Games for Kids (805) 555-7788 (408) 555-2345 (602) 555-5678 (714) 555-1212 (602) 555-5678 (714) 555-1212 (805) 555-7788 (805) 555-7788 (408) 555-2345 (408) 555-2345 Games for Kids Fun Learning Fun Learning Susanne Lee Riley Wilson Riley Wilson Chas Taylor Chas Taylor Items to submit for grading: 1. ERD and Relations drawings with the following: a. Show all entities with primary keys identified and relationship lines (-25 point); b. Show all relations with primary and foreign keys identified, and foreign key mappings (.25 point); b 2. Create a Microsoft Access database, including: a. Create all tables with appropriate field formats and primary keys identified (.5 point); Establish correct table relationships (.25 point); Enter all data (efficiently; i.e., without duplication) (-25 point); d. Create a Form for entering new games from these same suppliers (.25 point); e. Create a Query to show only games under $24.00 (.5 point); a Report to see the (you can use Report Wizard) (-25 point). c f. Please submit your ERD and the Access file [LastName].accdb on Canvas. 1|Page