Describe the types of relationships 1m mn or 11 that the


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.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Describe the types of relationships 1m mn or 11 that the
Reference No:- TGS02356550

Now Priced at $10 (50% Discount)

Recommended (98%)

Rated (4.3/5)