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.

Consider the following database which keeps track of games purchased from a game store.

TransID TransDate 1/1/2017 1/1/2017 1/2/2017 1/2/2017 1/1/2017 1 1 2 2 3

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

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

Step by Step Solution

★★★★★

3.28 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To tackle this problem we can go stepbystep according to the tasks given a Draw the Dependency Diagr... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Suppose that you want to output 0 with probability 1/2 and 1 with probability 1/2. At your disposal is a procedure BIASED-RANDOM, that outputs either 0 or 1. It outputs 1 with some probability p and...

Suppose that you want to send an MP3 file to a friend, but your friend's ISP limits the amount of incoming mail to 1 MB and the MP3 file is 4 MB. Is there a way to handle this situation by using RFC...

Suppose that you want to study retroviral integration mechanisms by determining the nucleotide sequence at the integration site several dozen nucleotides on each side of the viral-cellular DNA...

Discuss how efficiency and effectiveness are used to aid in decision making within a healthcareorganization. Is one more important than the other? Describe the importance of financial information in...

Morrison and Amato have decided to form a partnership. They have agreed that Morrison is to invest $150,000 and that Amato is to invest $50,000. Morrison is to devote one-half time to the business...

discuss different ways of entering foreign markets.

=+37. Stock patterns. Some people believe that the stock market shows patterns according to the day of the week or the month of the year (Sell in May and walk away). We have the closing price of the...

Felde Company had $150,000 of net income in 2011 when the selling price per unit was $150, the variable costs per unit were $90, and the fixed costs were $570,000. Management expects per unit data...

On January 1, 2019, ABC Company leased office furniture from Floor Company. The terms of the lease require annual payments of $25,000 for 20 years with the first payment being due on December 31,...

Spears was seeking employment and negotiating both with Amazon.com and with a firm called Intelligrated. Amazon made 2 offers to Spears which he rejected, because he believed they did not pay enough,...

For #11-12, determine whether the given function is continuous as the specified value of x. Remember to use ALL three tests to justify your answer. 11) Determine whether f(x) is continuous at x = -1....

The temperature T = T(x,y) in C at point (x,y) satisfies Tx (1,2)=4 and Ty (1,2)=-8. If 4t-4 x = e t=1 sec. cm and y = 2 + In t cm, find the rate at which the temperature T changes when When t = 1...

Exercise: Let f(x) = 8x-4 - (a) Plot the graph of f(x) and f'(x). (b) Identify the points where f(x) is not differen- tiable..

. Straight rankings . Paired comparisons . Forced distribution Critical incident method

In the "Short-Answer Questions" section found in Chapter 16, answer question 1. In your explanation, describe in detail why litigation may not be as cost efficient as other methods of dispute...

Briefly describe 3 key lessons learned from reading Simon Sinek's book "Start with Why"?

A project that provides annual cash flows of $16,000 for 5 years costs $49,000 today. a. If the required return is 10 percent, what is the NPV for this project? $ 10,487.33 $10,487.33 $11,652.59...

The Smiths buy a house. They borrow 80 percent of the purchase price from the local ABC Savings and Loan. Before they make their first payment, ABC transfers the right to receive mortgage payments to...

Repeat Exercise 22.25, but use the multiversion timestamp ordering method.

Consider the following relation: CAR_SALE (CarID, Option_type, Option_Listprice, Sale_date, Discounted_price) This relation refers to options installed on cars (e.g.- cruise control) that were sold...

Suppose we have the following requirements for a university database that is used to keep track of students' transcripts: (a) The university keeps track of each student's name (SNAME), student number...

What are the three primary colors as proposed by the trichromatic theory? a. red, green, blue b. red, yellow, blue c. white, black, brown d. white, black, red

Colleen stares at a fixed spot in her bedroom using only one eye. After a while, what might happen to her vision? a. Objects will become more focused the longer she looks at them. b. Any object she...

In farsightedness, also known as _____________, the focal point is _____________ the retina. a. presbyopia; above b. hyperopia; beyond c. myopia; below d. presbyopia; in front 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.

Step by Step Solution

Students Have Also Explored These Related Databases Questions!

Related Book