Consider the following database which keeps track of games purchased from a game store. TranslD: ID of
Question:
Consider the following database which keeps track of games purchased from a game store.
TranslD: ID of a transaction. Each transaction has a unique ID.
TransDate: The date of the transaction. There might be several transactions on the same date.
GameID: ID of the game. Each game has a unique ID.
GameName: Name of the game. Each game has a unique name.
Price: Price of the game. Several games might have the same price.
Quantity: The number of copies of a game sold in a speci?c transaction.
a. Draw the dependency diagram. Show the partial and transitive dependencies if applicable
b. Identify possible entities and draw E-R diagram
c. Suppose that you want to design your database using two tables. Identify the primary keys for each table and show the outline of this database
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe