Reference no: EM13188114
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.
|
Design a database for an insurance company
: Don't forget to underline key attributes for entity sets and include arrowheads indicating the multiplicity of relationships
|
|
How many ways a vending company can buy three
: Determine how many ways a vending company can buy three of these units and receive (a) no defective units, (b) all defective units and, (c) at least one good unit.
|
|
How to design a breathing machine
: Get a glass and fill it with cold tap water. Observe the water in the glass as it warms to room temp. What effect does temp have on the amount of gas that can remain dissolved in water? Can you use this information to explain boiling?
|
|
What is the index of a radical
: What is the index of a radical? When working with radicals, can the radicand be negative when the index is odd? Can it be negative when the index is even?
|
|
Create a relational database schema
: Draw the ER diagram for the database described above and create a relational database schema for this model assuming
|
|
Determine the marginal product of capital
: You were recently hired to replace the manager of the Roller Division at a major conveyor-manufacturing firm, despite the manager's strong external sales record. Roller manufacturing is relatively simple, requiring only labor and a machine that cu..
|
|
Find the amount of each paycheck
: A salesperson's weekly paycheck is 15% more than her coworker's paycheck. The two paychecks total $1475. Find the amount of each paycheck. (Round your answer to the nearest cent).
|
|
What are the dimensions of such a cylinder
: A cylinder is inscribed in a right circular cone of height 3.5 and radius (at the base) equal to 2.5. What are the dimensions of such a cylinder which has maximum volume?
|
|
How would you counter the union officials arguement
: In an effort to stop the migration of many of the automobile manufacturing facilities from the Detroit area, Detroit's city council is considering passing a statute that would give investment tax credits to auto manufacturers. Effecively, this wou..
|