Question A2 Consider the following business rules: 1. Each game company creates several games for players. Each company has a company ID and company name. Each player has a player ID and player name. Each game has a game ID and game name. 2. Each game is created by one company. 3. All games can be played by multiple players at the same time. 4. Every player can play as many games as they like. 5. There is no collaboration among the game companies. (a) Draw a basic entity relationship diagram (without attributes) which reflects the above business rules using Crow's Foot notation. (b) Assume you are building the above data model in Microsoft Access, identify those attributes which are necessary with appropriate domain and write the SQL statements that create those tables in the database which implement the relationships in part (a) of this question

Data management is creating, organizing, storing and managing the data collected and created by any organization.Effective data management is a crucial part of today's world. Data management provides analytical information on the vast amount of data coll…