COMM 226 Introduction to Business Technology Management Assignment 2 ALL ANSWERS 100% CORRECT FALL-2021 LATEST SOLUTION GUARANTEED GRADE A+

1. ERD of the Gametopia Database: Assumptions: _One customer can only register for one account; Account ID is unique assigned to a customer. _A customer can place many orders; each order is corresponded to only one customer’s account ID. _Each video game has a unique ID which is ISAN (International Standard Audiovisual Number) in which the game information such as its title, genre, console system, etc. can be traced. _The Game_Ordered Table is designed to address each game ordered by a customer listed in an order; the table contains a unique ID of a game and the quantity of the game ordered by the customer. _There can be many games ordered by a customer listed in an order; each represents a game and its quantity. _Games are distributed by a single distributor which is the publisher; One publisher can distribute one or many games. _Each video game can be developed by one or many different developers. _A video game may have many or may not have any review; a review refers to only one video game. _A customer can write many game review; however, he/she is not obligated to.