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 GameIDGameName Price Quantity 1/1/2017 1/1/2017 1/2/2017 1/2/2017 1/1/2017 Halo 5 NBA 16 FIFA 13 NBA 16 Dirt Rally S30 $25 $10 S25 S25 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 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 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