United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small network database to

Question:

United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting is 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. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database:

a. What tables would you create, and what would the table components be?

b. How might the (independent) tables be related to one another?

Broker
A broker is someone or something that acts as an intermediary third party, managing transactions between two other entities. A broker is a person or company authorized to buy and sell stocks or other investments. They are the ones responsible for...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: