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

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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