Describe the types of relationships

Assignment Help Basic Computer Science
Reference no: EM131561004

So here is the problem statement : Bracken Gallery is a broker for not-so-famous painters. Bracken maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting may be (and may be not) exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is painted by a single painter, but each painter can paint many paintings. There are several art exhibition events throughout this year. Each gallery can participate in many events, and may be not. However, each exhibition event must be participated by at least one gallery. Artists may or may not join any event, and each event may not have artists participate in. Using ARTIST, PAINTING, EVENT and GALLERY, in terms of a relational database. Question 1 is asking me to summarize the business rules that coven the relationship between the four entities. (from my view point there really isn't a clear business rule here) Question 2 is Describe the types of relationships (1:M, M:N, or 1:1) that the relationships between the entities are. Please help with this, I can't seem to figure it out.

Reference no: EM131561004

Questions Cloud

Calculate the effect on profits of processing product : Calculate the effect on profits of processing Product A further beyond the split-off point
Using expected values of present worth : Using Expected values of Present Worth, what choice has the best outcome?
What should be the value of the put : if the effective annual risk-free rate of interest is 4% and there are three months until expiration, what should be the value of the put?
How elements work together to help author create a reaction : How do the elements work together to help the author create a reaction? This essay will require analysis. Don't bother retelling the story.
Describe the types of relationships : Describe the types of relationships (1:M, M:N, or 1:1) that the relationships between the entities are. Please help with this, I can't seem to figure it out.
Explaining the various risks businesses : Participate in this discussion by researching and explaining the various risks businesses must consider when using cloud computing services.
Calculate variable cost per unit excluding utilities : Calculate variable cost per unit excluding utilities and maintenance, variable cost per unit for utilities and variable cost per unit for maintenance
Using the expected value of the net present worth : Using the Expected Value (EV) of the Net Present Worth EV (NPW) with joint probabilities for all combinations of outcomes, is this a worthwhile investment?
What are the payments to suppliers each quarter : What is the payables period in this case? What are the payments to suppliers each quarter?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Determine the actual and minimum theoretical operating costs

At steady state, a refrigerator whose coefficient of performance is 3 removes energy by heat transfer from a freezer compartment at 0°C at the rate of 6000 kJ/h and discharges energy by heat transfer to the surroundings, which are at 20°C.

  Creating access database for storing employee information

Investigate and present a proposal for the implementation of an Information Technology (IT) system for a small (4-user) business section (for example, Human Resources) of an organization of your choice (real or fictitious).

  Create a friend function that displays a customer number

Create a friend function that displays a customer number and the customer's city, state, and zip code. Write a brief main()function to test the classes and friend function. Save the file as Customer.cpp

  Define a class to hold multiple values in a hash-table

Implement a data structure, which can quickly do the following two operations: add an element and extract the smallest element. The structure should accept adding duplicated elements.

  Find the length of wire in the second coil

A coil which is made by winding 500 meters of copper wire of cross-sectional diameter 1.26 mm has the same mass as another coil of copper wire whose cross-sectional diameter is 1.4 mm. Find the length of wire in the second coil.

  Summarizes the six lessons for successful virtual teams

Write an essay that summarizes the six lessons for successful virtual teams. Are some more important than the others? What was your most important lesson in this class

  Assignment on mobile app work breakdown structure

Assignment On Mobile App (Work Breakdown Structure), This assignment contains two (2) deliverables: a summary document to be delivered in a word processor document format and a Work Breakdown Structure (WBS) to be delivered in a project file.

  How do you group data in sql

How do you group data in SQL? When you group data in SQL, are there any restrictions on the items that you can include in the SELECT clause? Explain.

  Proprietary nature of the apple platform

What are the benefits of apps? The disadvantages? Are there any benefits/disadvantages to the proprietary nature of theApple platform?

  Dbas formulate database policies

DBAs formulate database policies, communicate these policies to users, and enforce them. These policies include:

  What are labor costs in ms project

What are labor COSTS in MS project? How do we assign labor COSTS to a task in MS Project? Describe AND provide a screen shot of the steps.

  Define what is displayed on a computer screen

Computer users may encounter situations in which they can best express a computer-related problem or solution by showing the audience a graphic or video representation of what is displayed on a computer screen.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd