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 the tables.
4. Create 3NF table designs.

Note: Task 1 and task 2 should be done on the same diagram. Figure 9-16 on page 289 of your text is an example of how a system ERD looks. For task 3 and task 4, be sure that your table design is in standard notation format as described on page 292 of your text. This form looks like the following: