Consider a video game store for each game the

Assignment Help Database Management System

Reference no: EM13380056

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game. For each character in the game, it contains the character's name. The video games may be available at the store in different formats. Different formats may have different prices. Each game and format has a status indicating whether it is discontinued or not.

1. Draw the ER diagram for the database described above.

2. Create a relational database schema for this model assuming

a) Each video game in the database is available at the store in exactly one format.

b) Some video games in the database may not be available at the store and others may be present in more than one format.

Provide the name of the table, primary key, and other attributes for each table in your solution. Think intelligently between various choices available to map the E/R diagram to relations, to get best design for the problem in hand. Minimize the use of NULLs. Your representation will be evaluated based on correctness and succinctness.

Reference no: EM13380056

Questions Cloud

What needs to be considered in devising a companys policy : what needs to be considered in devising a companys policy for selecting a methodology to develop software

Open source technology is a reliable basis for system-level : open source technology is a reliable basis for system-level software and open source tools are finding their way into

Consider the eer diagram for a car dealer in the figure : consider the eer diagram for a car dealer in the figure below. map the eer schema into a set of relations. for the

You are to design a database for an insurance company the : you are to design a database for an insurance company. the data will include information about customers name address

Consider a video game store for each game the : consider a video game store. for each game the databasenbspcontains information aboutnbsptitle producing company name

1 create a new database named membership2 write the create : 1 . create a new database named membership.2. write the create table statements needed to implement the following

Many midsized firms are investing in erp system packages : many midsized firms are investing in erp system packages such as sap and peoplesoft.comment on what you think might be

You are a manager in a company that has a lot of in-house : you are a manager in a company that has a lot of in-house is expertise.what might be your key decision rules for when

Is there a place for ethics in iton march 15 2005 michael : is there a place for ethics in it?on march 15 2005 michael schrage published an article in cio magazine entitled ethics

User Account

All Pages