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

Transcribed Image Text:

TransID TransDate 1/1/2017 1/1/2017 1/2/2017 1/2/2017 1/1/2017 ⠀ 1 1 2 2 3 ⠀ GameID 1 2 3 2 4 GameName Price Halo 5 NBA 16 FIFA 13 NBA 16 Dirt Rally ⠀ $30 $25 $10 $25 $25 I Quantity 3 2 1 3 2 TransID TransDate 1/1/2017 1/1/2017 1/2/2017 1/2/2017 1/1/2017 ⠀ 1 1 2 2 3 ⠀ GameID 1 2 3 2 4 GameName Price Halo 5 NBA 16 FIFA 13 NBA 16 Dirt Rally ⠀ $30 $25 $10 $25 $25 I Quantity 3 2 1 3 2

Answer rating: 100% (QA)

a Dependency Diagram b Entities ... View the full answer