Background The IT team at Game Technology is working on database design. Your job is to develop a recommendation for kee

[answerhappygod]

Background The It Team At Game Technology Is Working On Database Design Your Job Is To Develop A Recommendation For Kee 1 (64.74 KiB) Viewed 28 times

Background The IT team at Game Technology is working on database design. Your job is to develop a recommendation for keeping track of individual games and their authors. You will be expected to create an ERD and table designs. Here is what you know so far. • Every game has a product ID, name, version number, category code, and category description. • Every author has an author ID, name, mailing address, and e-mail address. • An individual author can develop one or more games • A game also can be developed by several authors. In this case, each author receives a specific percentage of the royalty that the game earns. This information must be stored in the database. Your plan is to develop an overall design, list all the individual data items, and then include them as fields in the tables you create. Your design must be in the form of an ERD that shows all the entities, including any associative entities, and their relationships. Also, all table designs must be in third normal form (3NF). Tasks 1. Draw an ERD showing all entities and their relationships 2. Indicate cardinality, 3. Identify all fields you plan to use in each table. 4. Create 3NF table designs.