Explain the below diagram Game GameLoan Game_ID [PK] 1...1 0... Game ID[PK][FK] 0...* 1...1 Gamer_ID Game_Name Game_Author
Fantastic news! We've Found the answer you've been seeking!
Question:
Explain the below diagram
Transcribed Image Text:
Game GameLoan Game_ID [PK] 1...1 0... Game ID[PK][FK] 0...* 1...1 Gamer_ID Game_Name Game_Author Gamer_ID[PK][FK] Loan_Star [PK] Loan_Duration Gamer Gamer_ID [PK] Gamer_FirstName Gamer_LastName Gamer_Phone Gamer_Email We are still debating what would be the best design to accommodate loan renewals (extensions). We have received new information to the effect that we have to ensure the extensions can be traced to the original loan, because the store wants to enforce a limit on the number of extensions. Which of the following is the best design for such a requirement? (The strong entities Game and Gamer have been omitted in the answers.) A) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK] Loan_EndDate 1...1 0... Loan Extension Gamer_ID [PK][FK] Game_ID[PK][FK] Extended_On [PK] Extension_No [PK] Extended_Date B) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK] Loan_EndDate C) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK] Loan_EndDate D) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK][FK] Extension_No [FK] Loan_EndDate 1...1 0...* 1...1 0...1 1...1 Loan Extension Gamer_ID [PK][FK] Game_ID[PK][FK] Loan_StartDate [PK][FK] Extension No [PK] Extended_Date Loan Extension Gamer_ID [PK][FK] Game_ID[PK][FK] Loan_StartDate [PK][FK] Extended_Date Loan Extension 0... Gamer_ID [PK] Game_ID[PK] Loan_StartDate [PK] Extension No [PK] Extended Date Game GameLoan Game_ID [PK] 1...1 0... Game ID[PK][FK] 0...* 1...1 Gamer_ID Game_Name Game_Author Gamer_ID[PK][FK] Loan_Star [PK] Loan_Duration Gamer Gamer_ID [PK] Gamer_FirstName Gamer_LastName Gamer_Phone Gamer_Email We are still debating what would be the best design to accommodate loan renewals (extensions). We have received new information to the effect that we have to ensure the extensions can be traced to the original loan, because the store wants to enforce a limit on the number of extensions. Which of the following is the best design for such a requirement? (The strong entities Game and Gamer have been omitted in the answers.) A) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK] Loan_EndDate 1...1 0... Loan Extension Gamer_ID [PK][FK] Game_ID[PK][FK] Extended_On [PK] Extension_No [PK] Extended_Date B) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK] Loan_EndDate C) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK] Loan_EndDate D) GameLoan Game_ID[PK][FK] Gamer_ID[PK][FK] Loan_StartDate [PK][FK] Extension_No [FK] Loan_EndDate 1...1 0...* 1...1 0...1 1...1 Loan Extension Gamer_ID [PK][FK] Game_ID[PK][FK] Loan_StartDate [PK][FK] Extension No [PK] Extended_Date Loan Extension Gamer_ID [PK][FK] Game_ID[PK][FK] Loan_StartDate [PK][FK] Extended_Date Loan Extension 0... Gamer_ID [PK] Game_ID[PK] Loan_StartDate [PK] Extension No [PK] Extended Date
Expert Answer:
Posted Date:
Students also viewed these databases questions
-
A lottery offers one $1,000 prize, two $500 prizes, and seven $10 prizes. Fifty tickets are sold for $4 each. a) Construct a probability distribution for the data. Wins Correct (No commas and from...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
The following auditors report was drafted by a staff accountant of Turner & Turner, CPAs, at the completion of the audit of the financial statements of Lyon Computers, Inc. (a non-public company) for...
-
What do you think are the most important recruiting metrics? Why?
-
The Commercial Division of Galena Company has income from operations of $12,680,000 and assets of $74,500,000. The minimum acceptable return on assets is 12%. What is the residual income for the...
-
Data for the Jim Carrey Company are presented in P12-5A. Further analysis re- veals the following. 1. Accounts payable pertains to merchandise creditors. 2. All operating expenses except for...
-
You are the manager of a midsized company that assembles personal computers. You purchase most componentssuch as random access memory (RAM)in a competitive market. Based on your marketing research,...
-
Find the measure (in degrees, not equal to the given measure) of the least positive angle that is coterminal with A A=27" The measure of the least positive coterminal angle is (Simplify your answer.)
-
Short Island Company has projected current sales (all on credit) of 50,000 units at a selling price of $30 per unit. Selling expenses are 90% of the selling price. The company is considering changing...
-
You purchase equipment for $154,431. The company's marginal tax rate is 21%. Three-, five- and seven-year MACRS schedules: Year 3-Year 5-Year 7-Year 1 33.33% 20.00% 14.29% 2 44.45% 32.00% 24.49% 3...
-
Instructions: Prepare one 2022 Income Tax and Benefit return for each of the following taxpayers (married couple) using ProFile software. Show all of your work (and any calculations performed) in a...
-
The following financial statements are for Microsoft, Inc. FY2023 and FY2022. Calculate the cash flows from operations as it would appear on the FY2023 statement of cash flows. (Hint: include all...
-
Caspian Sea is considering raising $37.00 million by issuing preferred stock. They believe the market will use a discount rate of 9.61% to value the preferred stock which will pay a dividend of...
-
A speculator believes that the price of oil will rise during the next seven months. On February 3, 2022, she takes a speculative position in five NYMEX September 2022 Light Sweet Crude Oil futures...
-
bert Ward, the accountant for Andersen Company, must complete Form 941 for the first quarter of the current year. Bob gathered them ew the employees' payroll information for January ew the employees'...
-
Reichenbach Co., organized in 2018, has set up a single account for all intangible assets. The following summary discloses the debit entries that have been recorded during 2018 and 2019. Instructions...
-
A company often test-markets a proposed product in a specific area or location. Suppose that you wish to test-market your new, revolutionary SuperWax car wax, which requires only one application for...
-
The idea for New Belgium Brewing Company began with a bicycling trip through Belgium, where some of the worlds finest ales have been brewed for centuries. As Jeff Lebesch, a U.S. electrical engineer,...
-
It is helpful to think of a total product offering as having a combination of three interdependent elements: the core product itself, its supplemental features, and its symbolic or experiential...
Study smarter with the SolutionInn App