Q 4. [28 Pt.] Database Design Basic. Q4-1. Consider the following database which keeps track of games purchased from a game store. TransID TransDate GamelD GameName PriceQuantity 1/1/2017 1/1/2017 /2/2017 1/2/2017 1/1/2017 Halo 5 NBA 16 FIFA 13 NBA 16 Dirt Rally $30 $25 $10 $25 $25 4 TransID: 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 GamelD: ID of the game. Each game has a unique IID 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 specific 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