Question: I have this ERD created with Oracle's Data Modeler however I am unsure how to make the relationships between them The rules as a business

I have this ERD created with Oracle's Data Modeler however I am unsure how to make the relationships between them

The rules as a business are that an account can own many games but not the multiple copies of the same game

An account can make many reviews on many games but not multiple reviews on the same game

I am unsure how this would work relationship wise. I do believe that there should be a many to many relationship somewhere but do not know how this would work on Oracles Data Base Modeler.

#id o display_name o email o country oipaddress o purchase_id #acc_id account_info account_purchases ogame_id opayment meth review_id purchase_id o account_id o o review #id ogame_name ogenre_name o publisher_name o platform reviews game

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

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...

Three things set The Pampered Chef, a direct selling company, apart from its competition in the housewares industry: a passion for providing unique, quality products, a dedication to ensuring...

Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

Fuzzy Logic Radio (NYSE: FUZZ) is medial management company with a number of traditional (terestrial) radio stations as well as a number of "Internet" (streaming only) stations. Fuzzy Logic maintains...

Please help me with the questions below, I am using Oracle Data Modeler for this assignment: The objective of the assignment is to develop a database to support an on-line auction site called Nifty...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

Create a new Data Modeler file using Oracle SQL developer and give it a meaningful name (i.e. AttendanceSystem). Develop an E-R Diagram with Sub-view/External Schemas as indicated on the following...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Read the following article and write a 1-2 paragraph summary of the article. Answer the following questions 1. In your opinion after reading the article, what is the top issue related to ethics and...

Did strategies of Standard Oil encourage unethical behavior? Could Rockefellers vision have been fulfilled using nicer tactics?

This Question: 1 pt This Test: 50 pts A game theory analysis of deterring entry concludes that Te DS Ch DS CH OA deterring entry is always a bad idea. OB deterring entry is always a good idea. C...

The board of directors has asked you to provide a portfolio of research regarding the expansion of the company into a European country of your choice. Research the country you selected to prepare for...

Determine the following: a. For n = 4 and = 0.12, what is P(X = 0)? b. For n = 10 and = 0.40, what is P(X = 9)? c. For n = 10 and = 0.50, what is P(X = 8)? d. For n = 6 and = 0.83, what is P(X =...

On July 1, 2013, Flashlight Corporation sold equipment it had recently purchased to an unaffiliated company for $480,000. The equipment had a book value on Flashlight's books of $390,000 and a...

Salcedo Co. leased equipment to Erickson Inc. on April 1, 2011. The lease, appropriately recorded as a sale by Salcedo, is for an 8-year period ending March 31, 2019. The first of eight equal annual...

The number of arrivals per minute at a bank located in the central business district of a large city was recorded over a period of 200 minutes, with the following results: a. Compute the expected...

Deseret Finance Company purchased a printing press to lease to Quality Printing Company. The lease was structured so that at the end of the lease period of 15 years, Quality would own the printing...

Investors using the buy-and-hold technique can earn profits from an increase in stock value and from

Christa Clothing International is a well-known international company headquartered in Blusen City, North Carolina in the United States. Christa specializes in fashion clothing for men and women. In...

In mid-2004 the president of Elis Cheesecake Company, Mr Marc Schulman, was reviewing the policies that had guided the international expansion of the firm. In the 1990s the company had recognized the...

Is use of the Internet appropriate only for large companies? Explain.

19. How does L-dopa relieve the symptoms of Parkinsons disease?

17. Do monozygotic twins resemble each other more than dizygotic twins do for early-onset Parkinsons disease? For late-onset? What conclusion do these results imply?

22. What procedure enables physicians to predict who will or will not get Huntingtons disease and to estimate the age of onset?