Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions

Question

2. How will the team select a leader?

Answered: 1 week ago

Question

3. What may be the goal of the team?

Answered: 1 week ago