Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The question as below: Background The IT team at Game Technology is working on database design. Your job is to develop a recommendation for keeping
The question as below:
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 relationshipsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started